A database is to be designed for a college to monitor students' progress throughout their course of study. The students are studying for a degree (such as BA, M.Sc., etc.) within the framework of the modular system. The college provides a number of modules, each being characterized by its code, title, and credit value, module leader, teaching staff and the department they come from. A module is coordinated by a module leader who shares teaching duties with one or more lecturers. A lecturer may teach (and be a module leader for) more than one module. Students are free to choose any module they wish but the following rules must be observed: some modules require prerequisites modules and some degree programs have compulsory modules. The database is also to contain some information about students including their numbers, names, addresses, degrees they study for, and their past performance (i.e. modules taken and examination results). Draw an ER diagram for this database using as much of the ER model as appropriate.

A database is to be designed for a college to monitor students' progress throughout their course of study. The students are studying for a degree (such as BA, M.Sc., etc.) within the framework of the modular system. The college provides a number of modules, each being characterized by its code, title, and credit value, module leader, teaching staff and the department they come from. A module is coordinated by a module leader who shares teaching duties with one or more lecturers. A lecturer may teach (and be a module leader for) more than one module. Students are free to choose any module they wish but the following rules must be observed: some modules require prerequisites modules and some degree programs have compulsory modules. The database is also to contain some information about students including their numbers, names, addresses, degrees they study for, and their past performance (i.e. modules taken and examination results). Draw an ER diagram for this database using as much of the ER model as appropriate.

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 concept of data warehousing in the context of a distributed database, highlighting its advantages and challenges.
A database has student records, with four different options for grade level: 9th, 10th, 11th, or 12th. What are two different ways that you could write a query that would locate all students who are not in 11th grade? Which method would you prefer? Why?
DATABASE MANAGEMENT ABC Walk-in Clinic is located in a large metropolitan city in Canada. The clinic staff consists of ten doctors, six nurses, five office secretaries, two administrative assistants and one manager. First time Patients have to visit the clinic personally and fill a registration form that contains their personal and health related information. An office secretary would then enter that information in the computer based information system. Patients may become a permanent patient (at any time) for one of the doctors at the clinic by filling up necessary forms (they are called enrolled patients) or they may choose to come walk-in for every visit. (They usually called walk-in patients) Enrolled Patients may book their appointments online or by calling, the office and one of the secretaries would then book their appointment with their doctor on a particular day/time. Any booked appointment may be cancelled up to 24 hours in advance after which the clinic charges a…
It's possible that the level of granularity available in a database is far lower than what's available in a data warehouse.
Computer Science Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements.
The data dictionary plays a significant role in the Database Life Cycle (DBLC) process.
a programming language for accessing and manipulating data in a relational database
Define data binding in the context of software development, and explain how it simplifies the interaction between the user interface and data.
In what specific ways may the Requests for Information be tracked all the way back to the place where they first originated?
There should be at least nine distinct components of a typical database environment stated.
In databases, what kinds of choices are available for controlling the integrity of the data stored in individual fields?
Describe the Database Planning stage of the Database System Development Lifecycle.