Skip to main content

Some Database questions

Normalization is a set of rules used for the design of database tables and table are meant to be connected through relation ship. This set of rules are know as normalization. Normalization will avoid the repetitive entries, reduces the storage space, will avoid the need to restructure the table to accommodate new data. By doing the normalization you can increase the speed and flexibility of queries, summaries etc.
Data must be broken into the smallest unit as possible and should not contain any repetitive group of fields.
ID      Name                 Pet1   Pet2     Hours  Days  TotalHours/Week
1       Adarsh Soman    Cat    Cat2      5         5        25
Here name can be broken as first name and last name and pet repeating. So based on the first normal form the table will become as
ID      First Name      LastName  Pet    Hours  Days  TotalHours/Week
1        Adarsh           Soman       Cat       5         5        25

Each non key field should be fact about the field in the primary key. Here pet can be moved into a different table


ID      First Name      LastName  PetID    Hours  Days  TotalHours/Week
1        Adarsh           Soman       1           5         5        25
PetID  PetName
1         Cat
2         Dog
A non-key field should not depend upon the other non key field. Here 
In the above table TotalHours/Week is calculated by multiplying hours into days.(total=hours*days). So based on the third normal form we can remove it.





ID      First Name      LastName  PetID    Hours  Days  
1        Adarsh           Soman       1           5         5        

Process of putting one fact in numerous place is know as denormalization and we can tell its a vice versa of normalisation. By doing it we can increase the performance (increasing redundancy as well)

Comments

Post a Comment

Popular posts from this blog

Compiled Query- Improve the performance of Linq to Entity Query

Most of the small or medium IT firms are using the Entity framework for the Data Access layer (DAL). If we write a complex linq to Entity queries performance will always be an issue. But with the Compiled Query Performance can be improved. This below definitions are from MSDN and more details can be found on the MSDN Link that is at the end of this post           When you have an application that executes structurally similar queries many times in the Entity Framework, you can frequently increase performance by compiling the query one time and executing it several times with different parameters. For example, an application might have to retrieve all the QuoteRevision for a particular quotelineStatus, the quotelinestatus is specified at runtime. LINQ to Entities supports using compiled queries for this purpose.               The  compiled query class provides compilation and caching of queries for reuse . Co...
1 comment
Read more

Sql Server Internals - Named Pipes

Named pipes enables clients applications to request a reliable and two way connection between the client application and Sql Server, across a network. A named pipe has a name which follows the UNC naming convention : \\Server\pipe\name The default names pipe for SQL server is :                 \\Server\pipe\sql\query A named instance would have a named pipe of                \\server\pipe\MSSQL$instancename\sql\query Early versions of SQL Server only provided Named Pipes. Named Pipes also allows for impersonation of a clients credentials. The feature is used by SQL server when using Linked Servers. The clients logon credentials are passed across to the Linked Server for authentication. Named Pipes can operate over TCP/IP, NETBEUI or IPX as it indirectly relies on the Common Internet Files Sytems
Post a Comment
Read more

CV Preparation

An old saying, - First Impression is the best impression. When we are applying for the jobs, chances of getting interview depend mainly on CV . Each location has its own CV format. While applying for an UK based job you need to sent a standard UK  format CV (optional cases some organisations do not accepts CV ).  1 Header with Name, phone number and email address (avoid address) 2 Career Conspectus – Describe about your experience, what technology you familiar with, what domain you got experience etc 3. Technical Skills – Mention all the technical skills on this section (In good format, if necessary use tables) 4. Certifications - Mention about the Certifications passed. 5. Employment Chronicle- Mention about the professional experience (Most recent first).Include Project name/Client name  , a brief summary  of project, your responsibility (Means role in the project), and the environment(Which  technologies used) which the projects works 6....
2 comments
Read more