To access the Database Design Module, go to: ign Module, go to: http:/ladbe.kenn

Question

To access the Database Design Module, go to: ign Module, go to: http:/ladbe.kennesaw.edu/ http://adbc.kennesaw.edu/ Functional Dependencies In this section go through the following sections/scenarios: Introduction Help (Read instruction on how to use this sub module) Hospital scenario University scenario Stocks scenario Normalization In this section go through the following sections/scenarios: Help (Read instructions on how to create tables and designate Primary Keys) Employee scenario Auto Theft Scenario Property scenario Customer scenario Medicine scenario

Explanation / Answer

Solution :

3)

a) Functional dependencies :
Pid->Pname
Mid->Mname
Eid->Ename
Eid->Pid
Eid->Mid

here Eid is a candidate key of table.

b) Normalizing to 3NF :
- check for 2NF :
   - here there are two partial dependencies :
       1) Pid->Pname
       2) Mid->Mname
   - Decompose table into small tables to convert into 2NF :
       - Consider two tables given below :
           1) Project(Pid, Pname) where Pid is candidate key
           2) Manager(Mid, Mname) where Mid is candidate key
- hence given decomposed relations are in 2NF and ready to be converted to 3NF :
1) Project(Pid, Pname) where Pid is candidate key
2) Manager(Mid, Mname) where Mid is candidate key
3) Employee(Eid, Ename, Pid, Mid) where Eid is candidate key.

- check for 3 NF :
   - No functional dependency has transitive dependency hence given decomposition is already in 3NF :
       1) Project(Pid, Pname) where Pid is candidate key
       2) Manager(Mid, Mname) where Mid is candidate key
       3) Employee(Eid, Ename, Pid, Mid) where Eid is candidate key.

-----------------------------------------------------------

4)

a) Functional dependencies :
       Owner ->OwnerPhone
       Owner->OwnerEmail
      
       here candidate key is PetName, Type, Breed, DOB, Owner, Service, Date, Charge)
      
b) Normalizing into 3NF :

- cheking for 2NF :
table is already in 2NF as there is no partial dependencies.

- checking for 3NF :
here there are two transitive dependencies:
Owner ->OwnerPhone
Owner->OwnerEmail

- by decomposing into following two tables , the result will be in 3NF :

   1) OwnerDetails(Owner, OwnerPhone, OwnerEmail)
   2) Veterinary_Office(PetName, Type, Breed, DOB, Owner, Service, Date, Charge)
  
if you have any doubts then you can ask in comment section.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.