Convert each table or schema to the desired form. Make sure to clearly indicate the final...

  

Transcribed Image Text:

Convert each table or schema to the desired form. Make sure to clearly indicate the final form. 1. Take the unnormalized table below and convert it into its First Normal Form. Student ID 100 101 102 103 104 FirstName Bill Larry Michael Erving John First Normal Form LastName Russell Bird Jordan Johnson Stockton Phone 3171231234 3171231235 3171231236 3171231237 3171231238 SubjectID 1 2 3 1 4 1 4 5 6 7 Subject Math Science Biology Math English Math English History Chemistry Spanish 2. Take the First Normal Form table below and convert it into its Second Normal Form. CustomerID 101 101 102 103 103 103 CustomerName Clark Clark Porter Dawson Dawson Dawson Second Normal Form OrderID 10 11 12 13 14 15 OrderName Order1 Order2 Order3 Order4 Order5 Order6 SalesDetail Baseballs & Gloves Basketballs Soccer Balls Baseballs & Gloves Basketballs Soccer Balls 3. Looking at the schema (the structure) of the table below, convert the schema from Second Normal Form table below and convert it into its Third Normal Form. StudentLast StudentID StudentFirst Third Normal Form AdvisorID AdvisorFirst AdvisorLast Convert each table or schema to the desired form. Make sure to clearly indicate the final form. 1. Take the unnormalized table below and convert it into its First Normal Form. Student ID 100 101 102 103 104 FirstName Bill Larry Michael Erving John First Normal Form LastName Russell Bird Jordan Johnson Stockton Phone 3171231234 3171231235 3171231236 3171231237 3171231238 SubjectID 1 2 3 1 4 1 4 5 6 7 Subject Math Science Biology Math English Math English History Chemistry Spanish 2. Take the First Normal Form table below and convert it into its Second Normal Form. CustomerID 101 101 102 103 103 103 CustomerName Clark Clark Porter Dawson Dawson Dawson Second Normal Form OrderID 10 11 12 13 14 15 OrderName Order1 Order2 Order3 Order4 Order5 Order6 SalesDetail Baseballs & Gloves Basketballs Soccer Balls Baseballs & Gloves Basketballs Soccer Balls 3. Looking at the schema (the structure) of the table below, convert the schema from Second Normal Form table below and convert it into its Third Normal Form. StudentLast StudentID StudentFirst Third Normal Form AdvisorID AdvisorFirst AdvisorLast

Answer rating: 100% (QA)

ANSWER 1 First Normal Form All attributes should be atomic Student StudentID FirstName LastName Phon... View the full answer