Question: Create unique database and better explain the keys and relations perfectly. First Part: Come up with an idea for a database and throw all the

Create unique database and better explain the keys and relations perfectly.

  1. First Part: Come up with an idea for a database and throw all the columns (parameters) together you think you will need in one table (as start).
  2. Second Part: Show me how you would normalize it to 1st Normal Form. (Tell me what 1st normal form is and how you achieved it.)
  3. Third Part: Show me how you would normalize it to 2nd Normal Form. (Tell me what 2nd normal form is and how you achieved it.)
  4. Fourth Part: Show me how you would normalize it to 3rd Normal Form. (Tell me what 3rd normal form is and how you achieved it.)
  5. Fifth Part: I would like you to identify the Primary Key for each table and also identify the possible Foreign Key relationships you need to make the database relational.

Step by Step Solution

3.53 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

lets go through the process of designing and normalizing a database step by step Part 1 Initial Database Design Lets imagine a database for a library ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!