Question
Draw Entity-Relationship Diagram with proper E-R notations for the following scenario: A university registrar's office maintains data about the following entities: Courses: including number, title,
Draw Entity-Relationship Diagram with proper E-R notations for the following scenario:
A university registrar's office maintains data about the following entities: Courses: including number, title, credits, syllabus, and have relationship as "requires" prerequisites as well as main course with course entity itself; courses taught (week entity of course): including course number, year, semester, section number, instructors), timings, and classroom; students: including student-id, name, and program; and instructors: including identification number, name, department, and title.
Further, "the enrollment of students in courses-taught" and "grades awarded to students in each course they are enrolled for" must be appropriately modeled. Construct an E-R diagram for the registrar's office. Show different types of attributes (Simple, Multivalued, Composite, Derived) wherever found applicable. Also, document all assumptions that you make about the mapping constraints.
Note: Read about all entities and scenario properly.
Draw Entity-Relationship Diagram with proper E-R notations for the following scenario: A university registrar's office maintains data about the following entities: - Courses: including number, title, credits, syllabus, and have relationship as "requires" prerequisites as well as main course with course entity itself; - courses taught (week entity of course): including course number, year, semester, section number, instructor(s), timings, and classroom; - students: including student-id, name, and program; and - instructors: including identification number, name, department, and title. Further, "the enrollment of students in courses-taught" and "grades awarded to students in each course they are enrolled for" must be appropriately modeled. Construct an E-R diagram for the registrar's office. Show different types of attributes (Simple, Multivalued, Composite, Derived) wherever found applicable. Also, document all assumptions that you make about the mapping constraints. Note: Read about all entities and scenario properlyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started