Question A:

1. 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.

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 among these entities.

Question B:

A summary of business activities for enrolling courses for students and for enrolledclass 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.