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

In order to utilize an index, an attribute's values must be sufficiently varied.
Explain the database structure.
Explain the concept of database normalization and its importance in designing efficient relational databases.
how to build a bookstore database with Entities for Tables Books This entity will store information about the books in the bookstore, such as title, author, publisher, and publication date. The table could also include additional fields such as genre, language, and the number of pages. Authors This entity will store information about the authors of the books in the bookstore, such as name, date of birth, nationality, and biography. The table could also include additional fields such as gender, education, and awards. Bookstore Members This entity will store information about the bookstore members, such as name, address, phone number, email address, and membership status. The table could also include additional fields such as date of birth, occupation, and membership type.
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
Subject = database system Please help with the problem in the picture below
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.