Question 1 1. 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. ? Question 2 A summary of business activities for enrolling courses for students and for enrolled class lists for faculty members at an online university is as follows: An academic department provides information on offered courses. Students request enrollment in offered courses and the system sends to each student an enrollment schedule. Faculty members receive enrolled class lists when the registration period is complete. 1. Draw a context-level data flow diagram for the “Courses Registration” system using the following “recommended” items (but you can develop your own items, if preferred) Process name: Courses registration system External entities: Student, Academic department, and Faculty member Data flows: Derived from the above narrative. 2. Explode the above context-level diagram by drawing the logical data flow diagram level 0 showing all the major processes using the following “recommended” items (but you can develop your own items, if preferred) Process names: (1) Schedule course (2) Enroll student (3) Produce class list Data stores: (1) Offered courses (2) Course enrollment (3) Students External entities: Student, Academic department, and Faculty member Data flows: Derived from the above narrative.
