Page 1 of 1
Problem 1. The following diagram is an ER model for a course administration with minimal and maximum cardinalities speci
Posted: Thu May 05, 2022 1:36 pm
by answerhappygod
- Problem 1 The Following Diagram Is An Er Model For A Course Administration With Minimal And Maximum Cardinalities Speci 1 (82.92 KiB) Viewed 34 times
Problem 1. The following diagram is an ER model for a course administration with minimal and maximum cardinalities specified. cnbcname Tocation date 1..1 organizes D COURSE 0..n result prerequisites enrollment qualified 10.n 0.n 1.n TEACHER STUDENT tname Сtnb】 sname a. [20 points] Map this ER model to a relational model presentation. Clearly indicate the primary- foreign key relationships and specify NOT NULL or NULL ALLOWED declarations wherever necessary 2 0..n 0.n 0.n teaches SESSION 0..n/0..n IE 6700 Data Management for Analytics b. [5 points] For each relationship type, specify clearly which cardinalities are supported and which cardinalities are not supported by the relational model presentation.