Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

image text in transcribedDraw 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 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

Step: 3

blur-text-image

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

Databases In Networked Information Systems 6th International Workshop Dnis 2010 Aizu Wakamatsu Japan March 2010 Proceedings Lncs 5999

Authors: Shinji Kikuchi ,Shelly Sachdeva ,Subhash Bhalla

2010th Edition

3642120377, 978-3642120374

More Books

Students also viewed these Databases questions

Question

You have

Answered: 1 week ago