Question: Requirements . The system shall allow students to request enrollment in a course The system shall allow the registrar's office to input course offerings, but

Requirements . The system shall allow students toRequirements . The system shall allow students to

Requirements . The system shall allow students to request enrollment in a course The system shall allow the registrar's office to input course offerings, but will only create new records if the course offering doesn't already exist in the system The system shall allow the registrar's office to input new student records, but will only create new records if the student doesn't already exist in the system The system shall send reports to the registrar's office on course enrollment data The system shall validate student enrollment requests against current course enrollments to not allow duplicate enrollment in the same course The system shall enroll students in courses if they are not already enrolled The system shall return a success or error message to students based on course enrollment transaction status The system shall store data about all active students, including their unique student id, first name, last name, and email address The system shall store data about all course offerings, including the unique class id, class subject, class number, and class name The system shall store student enrollment data, including student id, class id, and enrollment date . Assumptions: All students are active an eligible for enrollment Students are not required to enroll in any course, and courses are not required to have any students Students can only register for a course once There are no prerequisites for any course There is no enrollment capacity for each course . . Part 3: Entity Relationship Diagram (in 3rd normal form) Using the requirements above, create a context-level entity relationship diagram (ERD) in 3rd normal form. Be sure your diagram meets the following requirements: All entities are properly labeled as singular nouns. All entities include a primary key. This may be a simple key or composite key. All entities must include relevant attributes per the requirements. All entity relationships should be properly labeled as verbs

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!