Relational_3 (project1)

Catagory
P * catagory_id NUMBER (5)
* category_name VARCHAR2 (30)
Catagory_PK (catagory_id)
Manufacturer Product

P * manufacturer_id NUMBER (10) P * Product_ID NUMBER

manufacturer_name VARCHAR2 (30) product_name VARCHAR2 (20)
product_description VARCHAR2
Manufacturer_PK (manufacturer_id) price NUMBER
PF * Manufacturer_manufacturer_id NUMBER (10) Product_Catagory
Product_PK (Product_ID, Manufacturer_manufacturer_id) PF * Product_Product_ID NUMBER
Product_Manufacturer_FK (Manufacturer_manufacturer_id) PF * Product_Manufacturer_manufacturer_id NUMBER (10)
PF * Catagory_catagory_id NUMBER (5)
Product_Catagory_PK (Product_Product_ID, Product_Manufacturer_manufacturer_id, Catagory_catagory_id)
FK_ASS_8 (Product_Product_ID, Product_Manufacturer_manufacturer_id)
FK_ASS_9 (Catagory_catagory_id)

Customer_Product
PF * Customer_customer_id NUMBER (5)
PF * Product_Product_ID NUMBER OrderProduct
PF * Product_manufacturer_id NUMBER (10) PF * Product_Product_ID NUMBER
Customer_Product_PK (Customer_customer_id, Product_Product_ID, Product_manufacturer_id) PF * Product_Manufacturer_manufacturer_id NUMBER (10)
PF * Order_OrderId NUMBER (5)
FK_ASS_2 (Customer_customer_id)
FK_ASS_3 (Product_Product_ID, Product_manufacturer_id) OrderProduct_PK (Product_Product_ID, Product_Manufacturer_manufacturer_id, Order_OrderId)

FK_ASS_6 (Product_Product_ID, Product_Manufacturer_manufacturer_id)

FK_ASS_7 (Order_OrderId)

Customer Order
P * customer_id NUMBER (5) P * OrderId NUMBER (5)
customer_first_name VARCHAR2 (30) quantiy NUMBER
customer_last_name VARCHAR2 (30) gift_voucher_ID NUMBER (10)
customer_gender VARCHAR2 (10) F * Customer_customer_id NUMBER (5)
phone_number NUMBER (11) F * adress_adressID NUMBER (5)
F adress_adressID NUMBER (5)
adress Order_PK (OrderId)
Customer_PK (customer_id) P * adressID NUMBER (5)
Order_Customer_FK (Customer_customer_id)
Customer_adress_FK (adress_adressID) house_number CHAR
Order_adress_FK (adress_adressID)
street_name VARCHAR2
city VARCHAR2 (20)
area VARCHAR2 (50)
adress_PK (adressID)

1.1 / 1 2017.03.15 [Link]