Construct an e-r diagram for the registrars office

Assignment Help Database Management System

Reference no: EM132125710

A School's office of the registrar maintains data about the following entities:

a) courses (including course number, title, credits, syllabus and prerequisites),

b) course offerings (including course number, year, semester, section number, instructor(s), scheduled times and classroom),

c) students (including student id#, name and major), and d) instructors (including id #, name, department and title).

Further, the enrollment of students in courses 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. Justify all assumptions you made that were not specified above.

Reference no: EM132125710

Questions Cloud

What is the fair value of the leased building : The appropriate interest rate to reflect the time value of money is 8%. What is the fair value of the leased building

When the same efforts must be made to uncork bottles : Most restaurant customers tip according to a percentage rule-between 15 and 25 percent of the bill. Diners who have dinner and a $20 bottle of wine usually pay.

Review problem related to airlines : The directors of Ace Airlines have decided to incentivize their 1,000 employees by issuing every one of them 200 shares of stock.

Display the appropriate greeting for the users choice : SDEV 140 : Include the comment lines for Author, Date and Description. Display the menu presented in Exercise 1.

Construct an e-r diagram for the registrars office : The enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled.

Show all workings including the use of the poly functions : Show all workings including the use of the poly and horner functions

Design a program that let the user enter the total : SDEV 140 : Design a program that let the user enter the total rainfall for each of 12 months into an array.

How many entries will be considered before discovering : How many entries will be considered before discovering that the entry is not present? (Note that the list is in alphabetical order.)

Find the full names of supervisors together with the total : Find the full names of supervisors together with the total number of employees directly supervised by each one of them.

User Account

All Pages