Define functional dependency, and explain one row of the functional dependencies

1) Review the existing report, functional dependencies provided and the sample data (as well as field domains and common knowledge) and document any assumptions you feel are appropriate (beyond those in the key points) and identify initial entities (person, place, thing). (10%)

2 Define functional dependency, and explain one row of the functional dependencies provided above in plain English (use field names). (15%) (you do not need to explain partial or transitive dependency)

3) Based on multiplicity – explain the relationship between the initial Entities in plain English – (either one-to-many, or many-to-many). (15%)

4) Design: specify all tables and fields at each normal form level
a) First Normal Forum (1NF) assessment / action – if needed 10%
Copy the 1NF definition from the text (include quotes and page number)
Assess the UNF table provided and if necessary, make the changes needed to conform to the 1NF definition. Document the resulting 1NF table(s) using relational schema notation or spreadsheet format (see the above example or page 111 Figure 4.2.6 of the text).
Explain how each table(s) meets the 1NF definition (use field names)
b) Second Normal Form (2NF) assessment / action – if needed 10%
Copy the 2NF definition from the text (include quotes and page number)
Assess the 1NF table(s) in the previous section and if necessary, make the changes needed to conform to the 2NF definition. Document the resulting 2NF table(s) using relational schema notation or spreadsheet format.
Explain how each table meets the 2NF definition (use field names)
c) Third Normal Form (3NF) assessment / action if needed 10%
Copy the 3NF definition from the text (include quotes and page number)
Assess the 2NF table(s) in the previous section and if necessary, make the changes needed to conform to the 3NF definition. Document the resulting 3NF table(s) using relational schema notation or spreadsheet format.
Explain how each table meets the 3NF definition (use field names)

Answer & Explanation

Solved by an expert writer

Rated Helpful

Answered by Best writer

Looking for a similar assignment? Let Us write for you! We offer custom paper writing services Order Now.

REVIEWS


“ This is exactly what I needed and the confidence that I am heading in the right direction to finish the assignment. Thank you so much.”

Joanna David.


"Great job, completed quicker than expected. Thank you very much!"

Harrison James.


"Very efficient definitely recommend this site for help getting your assignments to help"

Hannah Seven