Database Design is very essential for all Softwares. We Know that database is used to store data.

Database is known as collection of tables. Table is collections  of fields.

Primary key is used in tables to make the field unique and avoid repetation. The table should have only one primary key.

To design the database we are using Normalization. Normalization is used to remove repetations and increases the clarity in organizing data in a database.

There are 5 rules in normalization. They are

  • 1st Normal Form -  Each column type should be unique to eliminate duplication.

  • 2nd Normal Form -  Use 1st normal form and then remove subsets of data that apply to multiple rows of a table and place them in separate tables. Create relationship between tables.

  • 3rd Normal Form - Use 2nd normal form and then delete column that are not dependent on primary key

  • 4th Normal Form - Use 3rd normal form and check it has multi-value dependencies.

  • 5th Normal Form - Use 4th normal form and  check it should not have cyclic dependencies in a composite key

For more details and information we see the following site

http://en.wikipedia.org/wiki/Database_normalization

http://databases.about.com/od/specificproducts/a/normalization.htm

http://www.devshed.com/c/a/MySQL/An-Introduction-to-Database-Normalization/


Like it on Facebook, Tweet it or share this article on other bookmarking websites.

Comments (0)

There are no comments posted here yet

Whom are you supporting this IPL4?

Now that the heat is ON (cricket fever), let's add some Spice (IPL)...Whom are you supporting this IPL4?
No answer selected. Please try again.
Please select either existing option or enter your own, however not both.
Please select minimum 0 answer(s) and maximum 10 answer(s).
/polls/sports-and-games/5973-whom-are-you-supporting-this-ipl4.json?task=poll.vote
5973
radio
[{"id":"20569","title":"CSK","votes":"26","type":"x","order":"0","pct":28.89,"resources":[]},{"id":"20570","title":"DD","votes":"9","type":"x","order":"0","pct":10,"resources":[]},{"id":"20571","title":"MI","votes":"19","type":"x","order":"0","pct":21.11,"resources":[]},{"id":"20572","title":"KXIP","votes":"4","type":"x","order":"0","pct":4.44,"resources":[]},{"id":"20573","title":"KKR","votes":"9","type":"x","order":"0","pct":10,"resources":[]},{"id":"20574","title":"PWI","votes":"4","type":"x","order":"0","pct":4.44,"resources":[]},{"id":"20575","title":"RR","votes":"3","type":"x","order":"0","pct":3.33,"resources":[]},{"id":"20576","title":"RCB","votes":"7","type":"x","order":"0","pct":7.78,"resources":[]},{"id":"20577","title":"KTK","votes":"6","type":"x","order":"0","pct":6.67,"resources":[]},{"id":"20578","title":"DC","votes":"3","type":"x","order":"0","pct":3.33,"resources":[]}] ["#ff5b00","#4ac0f2","#b80028","#eef66c","#60bb22","#b96a9a","#62c2cc"] ["rgba(255,91,0,0.7)","rgba(74,192,242,0.7)","rgba(184,0,40,0.7)","rgba(238,246,108,0.7)","rgba(96,187,34,0.7)","rgba(185,106,154,0.7)","rgba(98,194,204,0.7)"] 350
bottom 200
No married couple wants to end up getting divorced. It is not like they have planned for it. They try to put up with their partners for as long as they
Due to our modern lifestyle, we feel that digestion related disorders are a common problem. Thus, we neither give importance to them nor seek any help
The bond of marriage brings the two people together. Initially, everything may seem okay and both of them slowly start discovering each other in the journey.
English literature never had it so good as in the present age. Larissa Lone is an American writer who has tapped the demand of the reading public for
Colleen Hoover Colleen Hoover is an American author who is a writer of the genre classified as Young Adult fiction. This genre of books appeals to a wide
Building up the Conversation(Part 10)   The Art of Speaking A man of the world will know another man from the moment the latter speaks. Words and
Building up the Conversation (part 9)   Building up the Conversation    Rounding Off All games are played according to the rules. They
Building up the conversation ( part 8) Diversity of Situations Conversation between two People When two people are talking to each other, there is