Database Reference
In-Depth Information
Account
{Account#, Customer#, Customer-Name, Balance}
{03}
Supply
{Part#, Quantity, Supplier#, Supplier-Address}
{03}
3.
In the relation
Participation
, are attributes Manager, Project,
Hours (spent on project per month), Salary. A manager's
salary is fixed, and he/she can work on many projects.
3a.
Draw a FD diagram of the relation.
{03}
3b.
Would you store
Participation
as defined?
Justify your answer.
{04}
3c.
Provide some sample data for the relation.
{04}
3d.
What is the highest normal form of
Participation
?
{03}
3e.
Show how you would design a conceptual schema to store the
data mentioned for relation
Participation
?
{11}
4.
A scientific research establishment organizes its work in
projects, each project consisting of several experiments.
For each experiment, the following is recorded:
Project number
Project manager
Project name
Experiment number
Experiment name
Lab in which experiment is to be conducted
List of scientists to work on the project
Note:
A project manager may work on an experiment.
A scientist may work on more than one experiment, provided
that they are done in the same lab. A manager may manage
more than one project.
4a.
From the information given, develop an ERD.
{10}
4b.
Using the XR model, derive a set of BCNF relations for the
system. Use self- explanatory relation and attribute names
(you may introduce new attributes).
{20}
