For each of the following relations, indicate the normal form for that relation. If the relation is not in third normal form, decompose it into 3NF relations. Functional dependencies (other than those implied by the primary key) are shown where appropriate: [8 Marks]
a. EMPLOYEE(EmployeeNo, ProjectNo)
b. EMPLOYEE(EmployeeNo, ProjectNo, Location)
c. EMPLOYEE(EmployeeNo, ProjectNo, Location, Allowance) [FD: Location ? Allowance]
d. EMPLOYEE(EmployeeNo, ProjectNo, Duration, Location, Allowance) [FD: Location ? Allowance], [FD: ProjectNo ? Duration]

Found something interesting ?

• On-time delivery guarantee
• PhD-level professional writers
• Free Plagiarism Report

• 100% money-back guarantee
• Absolute Privacy & Confidentiality
• High Quality custom-written papers

Related Model Questions

Feel free to peruse our college and university model questions. If any our our assignment tasks interests you, click to place your order. Every paper is written by our professional essay writers from scratch to avoid plagiarism. We guarantee highest quality of work besides delivering your paper on time.

Grab your Discount!

25% Coupon Code: SAVE25
get 25% !!