2. Give an example of a column A and a column B such that B is functionally dependent on A. Give an example of a column C and a column D such that D is not functionally dependent on C.3. Define primary key. 4. Define candidate key. 5. Define first normal form. 6. Define second normal form. What types of problems would you find in tables that are not in second normal form? 7. Define third normal form. What types of problems would you find in tables that are not in third normal form? 8. Define fourth normal form. What types of problems would you find in tables that are not in fourth normal form? 9. Define interrelation constraint and give one example of such a constraint. How are interrelation constraints addressed? 10. Consider a Student table containing StudentNum, StudentName, StudentMajor, AdvisorNum, AdvisorName, AdvisorOfficeNum, AdvisorPhone, NumCredits, and Category (freshman, sophomore, and so on). List the functional dependencies that exist, along with the assumptions that would support those dependencies.
2. Give an example of a column A and a column B such that B is functionally dependent on A. Give an example of a column C and a column D such that D is not functionally dependent on C.
3. Define primary key.
4. Define candidate key.
5. Define first normal form.
6. Define second normal form. What types of problems would you find in tables that are not in second normal form?
7. Define third normal form. What types of problems would you find in tables that are not in third normal form?
8. Define fourth normal form. What types of problems would you find in tables that are not in fourth normal form?
9. Define interrelation constraint and give one example of such a constraint. How are interrelation constraints addressed?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images