What is normalization A process that assigns attributes to entities so that

What is normalization a process that assigns

This preview shows page 1 - 3 out of 3 pages.

7.What is normalization?
Image of page 1
8.When is a table in 1NF? 9.When is a table in 2NF? 10.When is a table in 3NF? 11.When is a table in BCNF? 12.Given the dependency diagram shown in Figure Q12.6, answer items 12a-12c: FIGURE Q12.6 Dependency Diagram for Question 12C1C2C3C4C5a.Identify and discuss each of the indicated dependencies. b.Create a database whose tables are at least in 2NF, showing the dependency diagrams for eachtable. 2NF (C1, C2) (C3 , C4, C5) C1 C2
Image of page 2
Transitive Dependencies C4 C5 Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table. Submit the questions and answers in a Word Document by clicking on the Assignment Link located in the Assignment Submission Folder. C5 C4 C3 C3 C4 C5 C1 C2 C4
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Fall '17
  • Steven King

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture