Question: Jsing Draw.io, draw an ERD, using Chen notation that models these requirements for a university database. You nay add details to your ERD if they

Jsing Draw.io, draw an ERD, using Chen notation

Jsing Draw.io, draw an ERD, using Chen notation that models these requirements for a university database. You nay add details to your ERD if they seem necessary and don't conflict with the given requirements. State your additional assumptions. Think about how OSU course registration process works. - Students have a unique ID. - Courses have multiple sections. Each course has a unique ID. Sections have unique IDs. - Students may take several courses per semester. Students register for one section of the course they want to take. Students attend one section of a course they have registered for in that semester. - Students earn a grade for each section of a course they have attended. - Students remain in the system even if they are not currently enrolled. - Faculty can teach one or more sections per semester. - Both Faculty and Courses belong to one and only one department. Departments and faculty have their unique IDs. - Each faculty can act as an advisor to a student. A student can have at most one advisor but are not required to have one. - This scheduling system should also keep track of Semesters when each section of the course is offered. - Suggest at least 4 additional attributes for each entity and use correct symbols to show them in the diagram. - Check that your design would allow producing student transcripts with course dates, grades, and GPA information

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!