Represent each of the following requirements with an ER diagram:
A regional council requires the design of a database system that can provide information on all schools in the region. The requirements collection and analysis phase of the database design process has provided the following data requirements for the schools database system.
(a) Every school has many pupils and many teachers. Each pupil is assigned to one school and each teacher work for one school only.
(b) Each teacher teaches more than one subject but a subject may be taught by more than one teacher. The database should store the number of hours a teacher spent teaching a subject. Data held on each teacher includes his/her national Insurance Number (NIN) name (first and last), sex, and qualifications. The data held on each subject includes subject title and type.
(c) Each pupil can study more than one subject and a subject may be studied by more than one pupil. Data held on each pupil includes the pupil's code, name (first and last), sex, and date of birth.
(d) Each school is managed by one of its teachers. The database should keep track of the date he/she started managing the school. Data stored on each school includes the school's code, name, address (town, street, and post code) and phone.
Correct Answer:
Verified
Q1: Represent each of the following requirements with
Q3: Reliable Rentals Case Study
The requirements collection
Q4: Explain the purpose of data normalization and
Q5: The table shown below displays the details
Q6: Briefly describe how the techniques of normalization
Q7: Describe the purpose of normalizing data and
Q8: The table below lists customer/car hire data.
Q9: Examine the table shown below. This table
Q10: The table below lists customer/car hire data.
Q11: The table below lists customer/car hire data.
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents