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
database
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