Table name: TRAINING INSERT TIMES TAMP ID 1 2 + m 4 5 6 2023-02-04...

 

Transcribed Image Text:

Table name: TRAINING INSERT TIMES TAMP ID 1 2 + m ليا 4 5 6 2023-02-04 10:33:12 2023-02-05 15:30:02 2023-02-06 20:26:52 2023-02-08 12:23:42 2023-02-09 6:20:32 2023-02-10 11:17:03 WORKOUT _DATE WORKOU WORKO T_TYPE UT DUR ATION 1/12/2023 Running 1:05:34 1/3/2023 Please review the proposed data structure and answer the questions listed below. 2/2/2023 10/13/202 3 g Swimmin 0:22:10 0.5 Hiking WORKOU T DISTAN CE MILES 2/3/2023 Weight 0:45:01 Lifting 8.12 2/2/2023 Walking 3:15:33 6.48 3:12:09 6.41 Running 1:58:12 26.2 WORKOUT C ITY Cambridge Boston WORK OUT S TATE Chicago MA Awesome lisa@my run! MA Burlington Vi New Haven CT WORKOU USER EM T COMME AIL NT IL Boring but necessar y Scenic views Nailed it! Set my PR on this one! Lisa mail.com Simpson wonka@y Willie ahoo.com Wonka USER NA ME jhn@work John Doe org jdoe@vz com jdoe@vz com jr@yahoo .com Jane Doe USER PA YMENT Jack Rabbit VISA Jane Doe MC PAYPAL MC Question 1.1: Which field(s) could be selected as Candidate Keys and why?_ Question 1.2: Among the keys you listed in your answer above, which would be considered Composite Keys? Question 1.3: Which one of the candidate keys would you select to be the Primary Key and why? Question 1.4: Which fields would be good candidates for moving into a separate table? Why would you store them in a separate table? Question 1.5: Suppose you were told that instead of storing the workout, the city and state in the same table, you need to reference the location stored in a separate locations table (example shown below). Describe how you would reference the locations table from your training table? Which fields would you drop and/or add from/to your training table? What would be your foreign key? LOCATION_ID 34561 30999 CITY Boston New York STATE MA NY ZIP CODE 02101 10001 Table name: TRAINING INSERT TIMES TAMP ID 1 2 + m ليا 4 5 6 2023-02-04 10:33:12 2023-02-05 15:30:02 2023-02-06 20:26:52 2023-02-08 12:23:42 2023-02-09 6:20:32 2023-02-10 11:17:03 WORKOUT _DATE WORKOU WORKO T_TYPE UT DUR ATION 1/12/2023 Running 1:05:34 1/3/2023 Please review the proposed data structure and answer the questions listed below. 2/2/2023 10/13/202 3 g Swimmin 0:22:10 0.5 Hiking WORKOU T DISTAN CE MILES 2/3/2023 Weight 0:45:01 Lifting 8.12 2/2/2023 Walking 3:15:33 6.48 3:12:09 6.41 Running 1:58:12 26.2 WORKOUT C ITY Cambridge Boston WORK OUT S TATE Chicago MA Awesome lisa@my run! MA Burlington Vi New Haven CT WORKOU USER EM T COMME AIL NT IL Boring but necessar y Scenic views Nailed it! Set my PR on this one! Lisa mail.com Simpson wonka@y Willie ahoo.com Wonka USER NA ME jhn@work John Doe org jdoe@vz com jdoe@vz com jr@yahoo .com Jane Doe USER PA YMENT Jack Rabbit VISA Jane Doe MC PAYPAL MC Question 1.1: Which field(s) could be selected as Candidate Keys and why?_ Question 1.2: Among the keys you listed in your answer above, which would be considered Composite Keys? Question 1.3: Which one of the candidate keys would you select to be the Primary Key and why? Question 1.4: Which fields would be good candidates for moving into a separate table? Why would you store them in a separate table? Question 1.5: Suppose you were told that instead of storing the workout, the city and state in the same table, you need to reference the location stored in a separate locations table (example shown below). Describe how you would reference the locations table from your training table? Which fields would you drop and/or add from/to your training table? What would be your foreign key? LOCATION_ID 34561 30999 CITY Boston New York STATE MA NY ZIP CODE 02101 10001

Answer rating: 100% (QA)

Lets address each of the questions based on the provided data structure Question 11 Which fields could be selected as Candidate Keys and why Answer A candidate key is a column or a set of columns that ... View the full answer