Question details

Entity-Relationship-Diagram (ERD)
$ 20.00

. Create an entity-relationship diagram (ERD) based on the following information.

A building contains one or more labs and a lab is contained in one building. A lab contains one or more computers and a computer is contained in one lab. (5 points)

 

2. Create an entity-relationship diagram (ERD) based on the following information.

At a community college, courses are offered as course sections but some semesters some courses might not be offered. In order to manage these courses, selected faculty members are served as courses coordinators. One faculty member is assigned as course coordinator to oversee the course, and each faculty member can be coordinator of many courses. A student enrolls in many course sections and each

course section contains many students. (30 points)

For each ERD, identify reasonable entities and their relationships (one-to-one, one-to-many, or many-to-many) using the crow’s foot notation described in Chapter 2 of Kendall & Kendall 9th textbook among these entities.

Available solutions