Answered step by step
Verified Expert Solution
Question
1 Approved Answer
pls give answer in 20min pls.. Draw Entity-Relationship Diagram with proper E-R notations for the following scenario: A university registrar's office maintains data about the
pls give answer in 20min pls..
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