Problem 6 : Product Market A Client may generate many facture. Each facture is generated by only one Client. A Market sells many products. Many products are sold by one Market. A client pay by only one credit card. Each credit card payment is generated by one client. Each facture has many products. One or more products are printed on each facture. Zero to many products are tracked in inventory by date last used. An Inventory has zero to many products. Products have one or more manufactures. Manufactures must have one or many product. A Client is defined with the attributes : Client_Id, Client_Name, Client_Mobile, Client_Adress. A facture is defined with the attributes : Fact_Code, Fact_Name, Fact_Date. A Market is defined with the attributes : Market_Id, Market_Name, Market_Fax, Market_Adress. credit card is defined with the attributes : Card_Id, Delivry_Date . A product is defined by :Prod_Code, Prod_Name, Prod_Price, Prod_Qantity, Prod_Country. An Inventory is defined by :Invent_Code, Invent_Name, Invent_Total. Manufacture is defined by : Manufacture _Code, Manufacture _Name, Manufacture_Country, Manufacture_Budget .Problem 6 : Product Market A Client may generate many facture. Each facture is generated by only one Client. A Market sells many products. Many products are sold by one Market. A client pay by only one credit card. Each credit card payment is generated by one client. Each facture has many products. One or more products are printed on each facture. Zero to many products are tracked in inventory by date last used. An Inventory has zero to many products. Products have one or more manufactures. Manufactures must have one or many product. A Client is defined with the attributes : Client_Id, Client_Name, Client_Mobile, Client_Adress. A facture is defined with the attributes : Fact_Code, Fact_Name, Fact_Date. A Market is defined with the attributes : Market_Id, Market_Name, Market_Fax, Market_Adress. credit card is defined with the attributes : Card_Id, Delivry_Date . A product is defined by :Prod_Code, Prod_Name, Prod_Price, Prod_Qantity, Prod_Country. An Inventory is defined by :Invent_Code, Invent_Name, Invent_Total. Manufacture is defined by : Manufacture _Code, Manufacture _Name, Manufacture_Country, Manufacture_Budget .

Part 4 Storage and Security Phase :

CHECK CONSTRAINT code

TRIGGER code

give OR take away (permissions) code.