Figure 11–33 contains sample data for a Student table that could have been used for a college. Use this figure to answer the following:
a) Is the table in first normal form (1NF)? Why or why not?
b) Is the table in second normal form (2NF)? Why or why not?
c) Is the table in third normal form (3NF)? Why or why not?
d) Identify candidate keys for the table.
Figure 11–33
2. 2
Figure 11–34 contains sample data for pet sitters and customers who hire those sitters. In discussing the data with users, you find that customer IDs — but not customer names — uniquely identify customers and their offered pay rate, and that sitter numbers uniquely identify pet sitters. Multiple customers can use the same sitter and customers can use more than one sitter. For example, Carl Rogers pet sits for Eileen Anderson and Anne Carlson.
Figure 11–34
a) Convert the data in Figure 11–34 into a relation in first normal form (1NF) using the shorthand representation used in this module.
b) Identify all functional dependencies using the notation demonstrated in the module.
