Randall_Hall_week_3_homework

Randall_Hall_week_3_homework - the set of 3NF relations. I...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Week 3 Homework Problems Randall Hall Chapter 5, page 202, Review Question 2 Match the following terms and definitions. (Textbook: Glossary of terms, p. 192-193)   F    Well-structured relation   E    anomaly   A    functional dependency   J    determinant   G    composite key   D    1NF   H    2NF   I    3NF   C    Recursive foreign key   K    relation   B    transitive dependency Chapter 3, page 203, Problems and Exercises 4 Covert the user view to a set of 3NF relations using an enterprise key. (I don’t get how to do this. I see the example in the book, but am confused when I try to covert the class list to 
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the set of 3NF relations. I probably botched it for the homework points, but would you explain and help me understand how to do this? I would really appreciate it.)-53 pts: unfortunately, no attempt receives any points for this problem. If you have a question, do not put it in the homework, send me an email or post in the Questions thread. If you put the question here, it is way too late for me to help you with it....
View Full Document

Ask a homework question - tutors are online