Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data Base question! Section 1: Using the table below, answer the following questions relating to Functional Dependencies, clo- sures and keys. Save your results to
Data Base question!
Section 1: Using the table below, answer the following questions relating to Functional Dependencies, clo- sures and keys. Save your results to a word document, PDF or a clear picture of a hand written solution. Pay close attention to the content of each column. Also, consider this to be the only data available to you. For example, knowing that there may be more two towns, in different states, with the same name, does not apply to this small sample set. Use only the data presented to answer the questions. FirstName LastName DOB StreetCity State ZIP John Doe 09/20 Pacific Ave Tacoma WA 98402 Doe 09/21 Market AveTacoma WA 98405 Portland OR 97035 Seattle WA 98104 EarnestSmith 06/04Paific Ave TacomaWA98402 Smith 06/04 Main StArlington TX 76001 MarkSmith05/05 Pacific Ave Los Angeles CA 90012 Doe 10/20 Market Ave Los Angeles CA 90012 JohnOberg09/2112th S P Steve Adkisson 05/05 12th St Mark John 1. List at least 12 completely non-trivial functional dependencies (list only dependencies with a single attribute on the right side (eg AB C, AB D) 2. Calculate (Street, City)+ 3. Calculate (City, ZIP) 4. What columns if combined would make a key for this table? Use closure to prove it is the key. (Calculate the closure, show your steps)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started