Question: Draw EER Model Like this notation and the schema for all tables for this scenario STUDENT COURSE begin{tabular}{|l|} hline student-id hline student-name hline
Draw EER Model Like this notation and the schema for all tables

for this scenario

STUDENT COURSE \begin{tabular}{|l|} \hline student-id \\ \hline student-name \\ \hline \end{tabular} \begin{tabular}{|l|} \hline course-id \\ \hline course-name \\ \hline \end{tabular} COURSE-ROSTER student-id (FK) course-id (FK) course-time - 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
