Question$-3[10$ marks$]$

Using the functional dependencies identified in the given diagram, describe and illustrate

the process of normalization by converting the table to Third Normal Form $(3$NF$)$ relations.

Id entify the primary and foreign keys in your $3NF$ relations.

Question$-4[10$ marks$]$

Design an ntity Relationship Diagram describing the following domain:

A company has attributes name $($primary key$)$ and phone number $($alternate key$).$ An

Equipment has attributes equipment ID $($primary key$)$ and price. An Engineer has an

attribute engineer Number $($primary key$)$ and a composite attribute name that consists for

first name and last name. A Fault has attributes fault ID $($primary key$)$ and description.

Mechanical Fault is a type of Fault with attribute mechanical part $($mPart$).$ Electrical Fault

is a type of F ault w ith attribute electrical part $($ePart$).$ A fault $m$ ay or $m$ ay not participate as

an electrical or m echanical fault but if it participates, a Fault can be an electrical fault or a

mechanical fault but not both $($HINT: Use Specialization$/$Generalization Constraints$).$ A

company owns one or more equipment. Each equipment belongs to one company. An

equipment can have one or m ore faults. E ach fault belongs to one equipment. A company

employs one or m ore engineers. Each engineer is employed by one company. Whenever an

engineer is employed his joining date is recorded in the attribute dateloined. An engineer

repairs one or m ore faults. Each fault is repaired by one or m ore engineers. Whenever a

fault is repaired the date of repairmen and the number of hours spent on repairing are

recorded in the attributes dateand hours re spectively.