And draw the new dependency diagrams
Problem 1
| INV_NUM | PROD_NUM | SALE_DATE | PROD_LABEL | VEND_CODE | VEND_NAME | QUANT_SOLD |
|---|
2. Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created.
2NF:
| INV_NUM | PROD_NUM | SALE_DATE |
|---|
Relational schema: Invoice (INV_NUM, PROD_NUM, SALE_DATE, QUAT_SOLD)
3. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also, identify the normal forms for each table structure you created.
VEND_CODE
VEND_NAME
| PROD_NUM | SALE_DATE |
|---|
4. Draw the Crow’s Foot ERD.
PK VEND_CODE
VEND_NAME
| A | B | C | E | F | G |
|---|
A D
A D
| A | B | F |
|---|
