Scribd
Upload
3 views2 pages

Normalization Assignment Solution

The document outlines the normalization process for a given table with attributes related to products and suppliers. It identifies functional dependencies and analyzes the table's normal forms, concluding that it satisfies First Normal Form (1NF) but not Second Normal Form (2NF) due to partial dependencies. The primary key is determined to be a composite of Product_Num and Supplier.

Uploaded by

aswavirk
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views2 pages

Normalization Assignment Solution

The document outlines the normalization process for a given table with attributes related to products and suppliers. It identifies functional dependencies and analyzes the table's normal forms, concluding that it satisfies First Normal Form (1NF) but not Second Normal Form (2NF) due to partial dependencies. The primary key is determined to be a composite of Product_Num and Supplier.

Uploaded by

aswavirk
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Normalization Assignment Solution

Normalization Assignment Solution

Step 1: Given Table

(Product_Num, Product_Name, Supplier, Supplier_City, Unit_Price, Stock)

Step 2: Functional Dependencies

1. Product_Num → Product_Name, Stock

2. Supplier → Supplier_City

3. Product_Num, Supplier → Unit_Price

Step 3: Dependency Graph

Product_Num ───────▶ Product_Name

│ │

└────────────▶ Stock

Supplier ──────────▶ Supplier_City

(Product_Num, Supplier) ──────────▶ Unit_Price

Step 4: Primary Key

→ (Product_Num, Supplier)

Step 5: Normal Form Analysis

1NF (First Normal Form):

- All attributes are atomic: Yes


Normalization Assignment Solution
- No repeating groups: Yes

→ Satisfies 1NF

2NF (Second Normal Form):

- Must be in 1NF: Yes

- No partial dependency on part of a composite key:

- Product_Name, Stock depend only on Product_Num → partial dependency

- Supplier_City depends only on Supplier → partial dependency

→ Not in 2NF

Final Answers:

- Functional Dependencies:

• Product_Num → Product_Name, Stock

• Supplier → Supplier_City

• (Product_Num, Supplier) → Unit_Price

- Primary Key:

• (Product_Num, Supplier)

- Current Normal Form:

• 1NF (Not in 2NF due to partial dependencies)

You might also like