Question 13 Consider Following Tobfes Questions T3 14 Buses Busid B001 B002 8003 B004 Make Q30637917

QUESTION 13 Consider the following tobfes for questions T3 and 14. Buses busID B001 B002 8003 B004 make Isuzu Isuzu model accessible seats 12 36 Gala Aero no Aero 52 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 Record busID B001 B002 B003 B004 B001 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/08/2018 30/0812018 29/08/2018 driver Nikki Wayne Nikki 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 routs was a given bus in their fleet allocated to in any given day, and who was driving. Currently the database only has a faw tuples in each relation. However, it will store significantly more information in the future Choose the correct answer balow for the following: How many superkeys are there in the Routes relation? How many candidate keys are there in the Records relation

QUESTION 13 Consider the following tobfes for questions T3 and 14. Buses busID B001 B002 8003 B004 make Isuzu Isuzu model accessible seats 12 36 Gala Aero no Aero 52 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 Record busID B001 B002 B003 B004 B001 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/08/2018 30/0812018 29/08/2018 driver Nikki Wayne Nikki 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 routs was a given bus in their fleet allocated to in any given day, and who was driving. Currently the database only has a faw tuples in each relation. However, it will store significantly more information in the future Choose the correct answer balow for the following: How many superkeys are there in the Routes relation? How many candidate keys are there in the Records relation 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 *