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.
