1.What is normalization?
2.When is a table in 1NF?
3.When is a table in 2NF?
4.When is a table in 3NF?
5.When is a table in BCNF?
Page 217 Review Question
5. To keep track of office furniture, computers, printers, and other office equipment, the FOUNDIT Company uses the table structure shown in Table P6.5. (Please refer to the attachment below for this question.
a. Given that information, write the relational schema and draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies.
b. Write the relational schema and create a set of dependency diagrams that meet 3NF requirements. Rename attributes to meet the naming conventions, and create new entities and attributes as necessary.
c. Draw the Crow‘s Foot ERD.
