Is this data set in third normal form?

Posted by user2980802 on Stack Overflow See other posts from Stack Overflow or by user2980802
Published on 2013-11-11T21:23:57Z Indexed on 2013/11/11 21:53 UTC
Read the original article Hit count: 237

Filed under:

UNF:

(Customer-name, Customer-id, Customer-address, 
(Unit-price, Order-id, Quantity, Product-id, Delivery-date) 
(Supplier-name, Supplier-id, Supplier-Address)

3NF:

CUSTOMER 
(Customer-id, Order-id, Customer-name, Customer-address)

ORDER

(Order-id, Customer-id)

ORDER/PRODUCT

(Order-id, Quantity, Product-id)

PRODUCT

(Order-id, Product-id, Delivery-date, Supplier-id, Unit-price,) 

SUPPLIER

(Supplier-name, Supplier-id, Supplier-Address, Product-id)

Basically, the UNF is the un-normalised form. The information should have EXACTLY five tables, it's a hint we were given. The tables listed are the definite table names. We were told to make assumptions based on this information:

Customer Invoice is generated from customer orders (Order & Order/Product entities) Supplier Order is generated for products that are low in stock (Product entity)

Assumptions A customer can place many orders but an order is placed by only one customer An order can be for many products and a product can be ordered many times A product is supplied by only one supplier, a supplier may supply many products

This is one of my modules in university and my lecturer is all but useful, I'm really struggling so any help is really appreciated.

© Stack Overflow or respective owner

Related posts about database