Question 14 Consider Follonwing Tobles Questions 13 Ond 14 Buses Make Accessible B001 B002 Q30637922

QUESTION 14 Consider the follonwing tobles for questions 13 ond 14. Buses make accessible B001 B002 8003 В 004 seats 12 36 60 52 Gala Aero no Aero yes Routes routelD R001 R002 R003 R004 R005 departs Queen Av Queen Av Mountain Rd River Dr Mountain Rd arrives King St Princess Dr Queen Av Mountain Rd Queen Av Records busID 8001 B002 8003 В 004 8001 B001 routelD R002 R004 R001 R003 R002 R004 recordID A001 A002 A003 A004 A005 A006 date 20/08/2018 25/08/2018 24/08/2018 25/03/2018 30 08/2018 29 08/2018 driver Jake Nikki Wayne Nikki Jack Consider the tables above that show the relations and the existing tuples within the Little Coach relational schema. Little Coach is a small bus company only operating on pre-defined routes. They allocate buses and drivers to routes as needed on a daily basis and want to keep a record of what route was a given bus in their fleet allocated to in any given day, and who was driving. Currently the database only has a few tuples in each relation. However, it will store significantly more information in the future Choose the correct answer below for the folloving What is the most appropriate primary key of the Records relation? What are the foreign keys in the Records relation? y and v (select the answers in alphabetical order)

QUESTION 14 Consider the follonwing tobles for questions 13 ond 14. Buses make accessible B001 B002 8003 В 004 seats 12 36 60 52 Gala Aero no Aero yes Routes routelD R001 R002 R003 R004 R005 departs Queen Av Queen Av Mountain Rd River Dr Mountain Rd arrives King St Princess Dr Queen Av Mountain Rd Queen Av Records busID 8001 B002 8003 В 004 8001 B001 routelD R002 R004 R001 R003 R002 R004 recordID A001 A002 A003 A004 A005 A006 date 20/08/2018 25/08/2018 24/08/2018 25/03/2018 30 08/2018 29 08/2018 driver Jake Nikki Wayne Nikki Jack Consider the tables above that show the relations and the existing tuples within the Little Coach relational schema. Little Coach is a small bus company only operating on pre-defined routes. They allocate buses and drivers to routes as needed on a daily basis and want to keep a record of what route was a given bus in their fleet allocated to in any given day, and who was driving. Currently the database only has a few tuples in each relation. However, it will store significantly more information in the future Choose the correct answer below for the folloving What is the most appropriate primary key of the Records relation? What are the foreign keys in the Records relation? y and v (select the answers in alphabetical order) Show transcribed image text

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *