A university registrar's office maintains data about the following entities: courses including number, title, credits, syllabus, and prerequisites; course offerings, including course number, year, semester, section number, instructor, 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 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. Document all assumptions that you make about the mapping constraints.

A university registrar's office maintains data about the following entities: courses including number, title, credits, syllabus, and prerequisites; course offerings, including course number, year, semester, section number, instructor, 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 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. Document all assumptions that you make about the mapping constraints.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Explain the database structure.
Explain the concept of database normalization and its importance in designing efficient relational databases.
The rules used by the DBMS during the optimization of queries and the effect this has on reducing the amount of labor a DBA must do.
What's the method for storing and maintaining data?
Draw the ERD a third normal form solution for the following: A college keeps track of students and the courses they take. The following is kept for each student: Data Description Student number - a number that uniquely identifies a student Student last name -the last name of a student Student fırst name the first name of a student Student email - the email address of a student Course name - the name of a course; a student may take many courses and a course may have many students enrolled in it Course index number - a number that uniquely identifies a course Course credit - the number of credits a course is worth
When deciding on a system for managing databases, what factors should you take into consideration?
Please list DBA technical function design and implementation activities.
Describe the purpose of indexes and the important considerations in selecting attributes to be indexed.
Please describe what is the purpose of the database. Your design proposal should include the elements below: the problem a database is supposed to solve (or the reason for the database) the constraints associated with the database project the objectives you what to accomplish by designing a database the scope of your database design project the boundaries that describe what is and what is not included in your database project.
List the database's various relationships.
List the reasons why an index is only helpful for attributes that have a wide range of values.
Question 35