Page 153 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database

Notes 6. From the following given table.
Pet Id Pet Pet Pet Owner Visit Date Procedure
Name Type Age
246 Rover Dog 12 Sam Jan 13/2002 01 - Rabies Vaccination
Cook
Mar 27/2002 10 - Examine And Treat
Wound
Apr 02/2002 05 - Heart Worm Test
298 Spot Dog 2 Terry Jan 21/2002 08 - Tetanus Vaccination
Kim
Mar 10/2002 05 - Heart Worm Test
341 Morris Cat 4 Sam Jan 23/2001 01 - Rabies Vaccination
Cook
Jan 13/2002 01 - Rabies Vaccination
519 Tweedy Bird 2 Terry Apr 30/2002 20 - Annual Check Up
Kim
Apr 30/2002 12 - Eye Wash

Find:

UNF:
1NF:
2NF:
3NF:

7. Give the current Normal Form and Normalize to 3rd if necessary.
(a) Property (PropertyID, Address, City, State, Zip, Description, Price, {Type,
Tdescription}, OfficeNbr)

Type Tdescription
(b) PC (PC#, Location)
PCAccess (PC#, EmpID, AccessType)
MgrPCAccess (PC#, EmpID, OfficeNbr, AccessType)

PC# is only unique within an office.
(c) OfficeEmp (OfficeNbr, Oaddress, EmpID, Ename, Eaddress)
OfficeNbr Oaddress
EmpID Ename, Eaddress

(c) Registration (Course#, CourseName, Student#, StudentName, Grade, Major)
(d) Sale (Order#, Date, Clerk#, ClerkName)
(e) Student (StudentID, Name, Address, Major, Minor)
Only 1 major and minor per student

(f) Student (StudentID, Name, Address, {Major}, {Minor})
Multiple majors and minors per student

146 LOVELY PROFESSIONAL UNIVERSITY