what are the responsibilites of the database users for the given case staudy student. Every student has a unique ID. The system also keeps the studentname, birthday and the year he/she enrolled in the course.The school employs lecturers to teach the students. A lecturer is allowed towork for one school only. Each lecturer is assigned an ID which is uniqueacross the whole university. The system keeps the lecturer's name, title andthe office room. A supervisor maybe in charge of several lecturers, but alecturer, however reports to only one supervisor. A lecturer can teach manydifferent courses. A course may also have been taught by many differentlecturers.The university is operated by committees. Each faculty has to have a numberof committees with the same titles across the university, such as the FacultyExecutive, the Post Graduate Studies Committee, the Health and SanityCommittee, and so on. The committees meet regularly, such as weekly ormonthly. The frequency is determined by the faculty involved. A committee'smembers are all lecturers. A lecturer may be a member of several committees. Case StudyPriority University is a large institution with several campuses. Each campushas a different name, address, distance to the city center and the only busrunning to the campus. Each campus has one club. The name of the club, thebuilding in which the club is located, the phone number of the club and themultiple sports which club offers, should all be recorded.The University consists of a number of faculties, such as the Art Faculty, theScience Faculty, and so on. Each faculty has a name, dean and building. Afaculty may be divided into a number of schools, for example, the ScienceFaculty has a School of Physics and a School of Chemistry. Each schoolbelongs to one faculty only and is located on just one campus, but onecampus maybe the location of many schools.Every school has name and a building assigned to. Each school offers differentprogrammes and each programme can be offered by only one school. Eachprogramme has a unique code, title, level and duration. Each programmecomprises several courses, different programmes have different courses.Each course has a unique code and course title. Some courses may have oneor more prerequisite courses and one course can be the prerequisite course ofsome other courses.Each of the students is enrolled in a single programme of study which involvesa fixed core of courses specific to that programme as well as a number ofelectives taken from other programmes. Students work on courses and areawarded a grade in any course if he/she passes the course. Otherwise thestudent has to re-take the failed course. The system needs to record the yearand term in which the course was taken and the grade awarded to the

The question has been answered in step2

student. Every student has a unique ID. The system also keeps the student name, birthday and the year he/she enrolled in the course. The school employs lecturers to teach the students. A lecturer is allowed to work for one school only. Each lecturer is assigned an ID which is unique across the whole university. The system keeps the lecturer's name, title and the office room. A supervisor maybe in charge of several lecturers, but a lecturer, however reports to only one supervisor. A lecturer can teach many different courses. A course may also have been taught by many different lecturers. The university is operated by committees. Each faculty has to have a number of committees with the same titles across the university, such as the Faculty Executive, the Post Graduate Studies Committee, the Health and Sanity Committee, and so on. The committees meet regularly, such as weekly or monthly. The frequency is determined by the faculty involved. A committee's members are all lecturers. A lecturer may be a member of several committees.

student. Every student has a unique ID. The system also keeps the student name, birthday and the year he/she enrolled in the course. The school employs lecturers to teach the students. A lecturer is allowed to work for one school only. Each lecturer is assigned an ID which is unique across the whole university. The system keeps the lecturer's name, title and the office room. A supervisor maybe in charge of several lecturers, but a lecturer, however reports to only one supervisor. A lecturer can teach many different courses. A course may also have been taught by many different lecturers. The university is operated by committees. Each faculty has to have a number of committees with the same titles across the university, such as the Faculty Executive, the Post Graduate Studies Committee, the Health and Sanity Committee, and so on. The committees meet regularly, such as weekly or monthly. The frequency is determined by the faculty involved. A committee's members are all lecturers. A lecturer may be a member of several committees.

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

Views are explained as a data security component, as well as the constraints of their use in terms of data security.
In the event that database referential integrity is not enforced, what would happen? What are the most likely blunders to make?
What are the most typical database failures if referential integrity isn't enforced?
what kind of database users are suitable forthe given case study
In a nutshell, there are six distinguishing features of relational databases.
If we want to keep track of the annual salary that is calculated depending on the stored monthly salary in the database, then what is the suitable attribute type to be used for annual salary? Maximum file size: 10KB, maximum number of files: Files
What are the most typical database failures if referential integrity isn't enforced?
Given the following two relations, if there was a delete request on the student Jones, list and describe all possible actions that could be taken according to referential integrity. (sid is the primary key for Students, (sid, cid) is the primary key for Enrolled)
List two scenarios in which null values may be inserted into a database.
Developing a smart phone's user interface is a team effort.Is UI design hard? Describe what's done.How do you determine whether an item or category list has been presented during interface design?
What would happen if the referential integrity of a database was violated?What are the most prevalent mistakes?
What consequences will there be if your database does not have referential integrity? What errors are possible?