Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedpls 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 properly

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Office 365 For Beginners 2022 8 In 1

Authors: James Holler

1st Edition

B0B2WRC1RX, 979-8833565759

More Books

Students also viewed these Databases questions