1NF

Table format, no repeating groups, PK identified

2NF

1NF and no partial dependencies

3NF

2NF and no transitive dependencies

Transitive Dependencies

A non-key attribute determines the value of another non-key attribute

  1. Given the dependency diagram shown in Figure 1 below.

C1 C2 C3 C4 C5

  1. Identify and discuss each of the indicated dependencies.

  2. Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table.

   c. Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table.

C1 C2 C3 C4 C5



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *