Question

BandID is the primary key in the Band table. The Bookings table needs BandID as a foreign key. You will not need to create an attribute in the Bookings table that will hold the BandID value; since Access will automatically create the foreign key attribute for you.

a) True
b) False

Answer 1

The statement is False. In Microsoft Access, you need to manually create the foreign key attribute in the second table.

Step-by-step explanation:

The statement is False. In Microsoft Access, when you create a relationship between two tables using a primary key and a foreign key, you need to manually create the foreign key attribute in the second table. Access does not automatically create the foreign key attribute for you.

In this case, since BandID is the primary key in the Band table, you will need to create a corresponding BandID attribute in the Bookings table to establish the relationship between the two tables.

For example:

Band table:BandID (Primary Key)BandNameBookings table:BookingID (Primary Key)BandID (Foreign Key)BookingDate...