Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Tutorial 2 Represent each of the following requirements with an ER diagram: - A regional council requires the design of a database system that can
Tutorial
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.
Every school has many pupils and many teachers. Each pupil is assigned to one school and each teacher work for one school only.
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 hisher national Insurance Number NIN name first and last sex, and qualifications. The data held on each subject includes subject title and type.
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.
Each school is managed by one of its teachers. The database should keep track of the date heshe started managing the school. Data stored on each school includes the school's code, name, address town street, and post code and phone.
a Identify the main entity types
b Identify the main relationship types
c Determine the multiplicity constraints for each relationship described in
d Identify the attributes and associate them with entity or relationship types.
e Determine candidate and primary key attributes for each strong entity type.
f Create single ER diagram. State any assumptions necessary to support your design.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started