. 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

QUESTION

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

Order This Solution

Ask your homework question

 

INDIVIDUAL APPROACH:
Chat with every writer who applies to your request, and view their skills and portfolio. Make the choice that’s right for you.
MANAGE YOUR ORDER:
Monitor progress and see any changes made. Have full control over every phase of the process.
COMMUNICATE:
Ask your writer questions and provide your ideas about your paper. Produce the exact result that you want.
ENJOY THE OUTCOME:
Get everything done on time with high quality. Writing papers is much simpler with us.

Ask your homework question

 

© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.
Loading...