Description
A Park consists of a collection of Wood-Sections each has a number of specific species
of trees. You can access everywhere by Roads. The forest also has a Manager. There
are Fire-Stations in the park. Each one monitors fires in the Park. There are Facilities
which consists of camps and offices in the park. There are also Rivers. Each river
supply water to a different facility.
Answer the questions using the text above.
1- (35 points) Draw the E-R diagram of the park.
2- (5 points) Give all the functional dependencies in the question.
3- (10 points) Is there a weak entity in the E-R diagram. If there isn’t, modify
the question so that there will be a weak entity. Explain every detail. Explain
why you need a weak entity in both cases.
4- (15 points) Create tables for your E-R diagram.
(Do not forget that you should consider the effect of type of
relationships to the tables.)
5- (20 points) Give 2 relations. Show if they hold or does not the criteria of 3NF
and Boyce-Codd Normal Form. Explain why they are (or not) in 3NF and
Boyce-Codd Normal Form, give your reasons and proofs in details.
6- (15 points) Create database schema where the relations must hold BoyceCodd Normal Form or 3NF after the normalization steps.
