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

 Draw EER Model Like this notation and the schema for all

for this scenario

tables for this scenario STUDENT COURSE \begin{tabular}{|l|} \hline student-id \\ \hline student-name

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!