1 / 16

Normalization Exercises

Learn about normalization by solving exercises. In this example, we create 3 tables and distribute the attributes among them.

mstorms
Download Presentation

Normalization Exercises

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Normalization Exercises A337

  2. Normalization Example 1

  3. 1st Normal Form

  4. 2nd Normal Form Create 3 Tables Distribute the remaining Attributes COMPID INSTDATE SOFTCOST EMPNUM EMPNAME LOCATION

  5. 2nd Normal Form INSTDATE, SOFTCOST (none in this example), could be things like package name, version, etc. COMPID, EMPNUM, EMPNAME, LOCATION Because the Package table has only one field (PACKID), we really don’t need this table

  6. Normalization Example 2 Don’t be tricked!!! The first column of the data is not always the primary key of the 1NF table.

  7. 1st Normal Form If 1NF has only one column as the primary key (no composite key) then 1NF and 2NF are the SAME!!!!!

  8. 2nd Normal Form

  9. 3rd Normal Form Knowing the nature of the information, we can see that one person can have two cars and probably LIC_PLATE_NO should be the primary key for the REGISTRATION table and the foreign key for the PARKING_TICKETS table and that another table with LIC_PLATE_NO and LIC_PLATE_ST as a primary key and SSN as a foreign key should exist

  10. 3rd Normal Form

  11. Normalization Example 3

  12. 1st Normal Form

  13. 2nd Normal Form

  14. 3rd Normal Form

More Related