1. (Consider a table S which stores information about projects using the following attributes: project_name, project_description, project_manager, project_manager_position.
a) Find functional dependencies in S. Based on this, determine all candidate keys of S.
b) Transform the table Sinto two or more tables in BCNF. For every new (or transformed) table, determine candidate keys and foreign keys.
2. Consider a table T which stores information about a dog competition using the following attributes: dog_number, dog_name, kennel_code, kennel_name, kennel_location, trick_id, trick_name, trick_where_learned, skill_level, costume. (Assume that the attribute trick_where_learned refers to some kennel_code).
For example, typical data might be
(52, Beau, 16, DaisyPuppyFarm, Hamden, 2343, rollover, 18, 2, none) (89, Missy, 9, DansDogHouse, Hartford, 2345, shake-hands, 16, 4, red-coat).
a) Find “natural” functional dependencies in T. Based on this, determine all candidate keys of T.
b) Transform the table T into two or more tables in BCNF. For every new (or transformed) table, state the candidate keys and foreign keys.
3. ) Exercise 3.59 (again, note that the part C should begin with finding all candidate keys of the original table, based on your findings in A and B). In this exercise, exclude the attributes “Club” and “ClubCost” from the original table.
I have read this is it research then i can find accurate information . Thank you