Question: Activities: Please draw a Crows Foot Notation ERD for the Institute/University relational database, according to Business rules (i.e., relationships) below: 1. a professor teaches zero,
Activities: Please draw a Crows Foot Notation ERD for the Institute/University relational database, according to Business rules (i.e., relationships) below: 1. a professor teaches zero, one or many classes and a class is taught by one professor. 2. a course may generate zero, one or many classes and a class comes from one course. 3. a class is held in one room, but a room has many classes. 4. a class may enrol zero or many students, and a student may enrol in zero or many classes in each semester. Note: 1. Primary Keys (PKs) and Foreign Keys (FKs) must be included in the ERD; 2. Any Many-to-Many relationship must be converted to a pair of One-to-Many relationship by adding a bridge entity or an associative entity.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
