Using the information in the figure below, answer the following questions:
a) Define functional dependency – you only need to include one-to-one relationships. Use plain English and explain the concept and how it applies to this exercise. You may use the fields in this exercise to aid your explanation.
Using the functional notation shown on pages 412, 413 Examples 14.4, 14.5 identify the functional dependencies that exist between the attributes in the below figure. All attributes should be included. There may be more than one row of functional notation needed.
The sample data in the spreadsheet is not representative of “all” possible data, use your common knowledge of cars and owners to finalize the functional dependencies. Consider the pool of possible values for each field, this is called a domain.
b) Identify a primary key for the table in the figure and indicate whether there are any other candidate keys (for this table) – explain your choices.<o:p>
c) Is the table in 3NF? If not, explain why – (if you reference transitive dependency, you must provide a specific example, using field names and values in the table to demonstrate your understanding). Explain what normal form the existing table is in.
Each car can be owned by only one person; each person can own many cars.
<v:shapetype> <v:stroke> <v:formulas> <v:f> <v:f> <v:f> <v:f> <v:f> <v:f> <v:f> <v:f> <v:f> <v:f> <v:f> <v:f> <v:path> <o:lock> <v:shape> <v:imagedata>
Include each question with your answer. Submit a Word compatible document. Name your document Last Name_Assignment6 (i.e. Smith_Assignment6).
Please No Plagiarism
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post INFO 321 Case Study Week 6 appeared first on Top Premier Essays.