Companies manufacture ranges of products which are purchased by customers. The relation schema for this operation is given by: Company (company_code#,company_name, director#, dircector_name, {product_name,cost,{cust#,customer_name,address}}) where { }represents a repeating groups and company_code, and company_code,director# and cust# contains unique values. Normalize this relation to third normal form.

3NF Normalization

• Companies manufacture a range of products that are purchased by customers.

• The Relation Schema for this operation is given by:

Company (company_code#,company_name, director#, dircector_name, {product_name,cost,{cust#,customer_name,address}})

• Where { } represents a repeating group and company_code, director and cust contain unique values.

First Normal Form (1NF) -

• A relation will …