ICTDBS506 Creating a 'Car Pool' Database with MySQL

Fill in the blank: The SQL query SELECT d.driver_id, d.first_name, d.last_name, c.car_id, c.make, c.model FROM Driver AS d JOIN Car AS c ON d.driver_id = c.driver_id WHERE d.last_name = '___'; is used to find drivers with a specific last name.

• Johnson

• Smith

• Brown

• Davis

Answer explanation

The SQL query retrieves drivers based on their last name. Among the options, 'Smith' is a common last name, making it a likely choice for the query. Thus, 'Smith' is the correct answer.

Which clause in SQL is used to filter records?

• SELECT

• FROM

• WHERE

• JOIN

Answer explanation

The WHERE clause in SQL is used to filter records based on specified conditions. It allows you to retrieve only those rows that meet the criteria, making it essential for data selection.

Fill in the blank: To update the database, you need to remove the old ______ reference from the Car table.

• A) Primary Key

• B) Foreign Key

• C) Unique Key

• D) Index

Answer explanation

To update the database, you need to remove the old Foreign Key reference from the Car table. A Foreign Key links to another table, and removing it is necessary to ensure data integrity when updating records.

What is the first step in updating the 'Car Pool' database to a many-to-many relationship?

• Remove the old reference

• Log In

• Create a new table

• Update the schema

Answer explanation

The first step in updating the 'Car Pool' database is to log in. This is essential to access the database and make any changes, including creating a new table or updating the schema for a many-to-many relationship.

Fill in the blank: The 'Driver' table includes columns for driver_id, first_name, last_name, and ______.

• Address

• Phone Number

• License Number

• Email

Answer explanation

The 'Driver' table typically includes essential information about drivers. Among the options, 'License Number' is a crucial identifier for drivers, making it the most appropriate choice to complete the table's columns.

Fill in the blank: To add sample rows in 'Driver', 'Car', and then create relationships in ______.

• A) CarDriver

• B) CarOwner

• C) DriverCar

• D) CarLink

Answer explanation

The correct choice is A) CarDriver because it logically represents the relationship between drivers and cars, indicating which driver is associated with which car.

Fill in the blank: The SQL query uses the ______ keyword to combine rows from two or more tables.

• A) SELECT

• B) JOIN

• C) WHERE

• D) INSERT

Answer explanation

The correct answer is B) JOIN. The JOIN keyword in SQL is specifically used to combine rows from two or more tables based on a related column between them, making it essential for querying multiple tables.

Fill in the blank: The SQL query is used to retrieve data from the ______ table.

• A) Driver

• B) CarDriver

• C) Car

• D) All of the above

Answer explanation

The SQL query can retrieve data from multiple tables, including Driver, CarDriver, and Car. Therefore, the correct answer is D) All of the above, as it encompasses all possible tables from which data can be retrieved.

What is the result of executing the SQL query in the image?

• A list of drivers

• A list of cars

• A list of driver-car combinations

• A list of car models.

Answer explanation

The SQL query likely joins tables containing drivers and cars, resulting in a combination of each driver with their respective cars. Thus, the correct answer is a list of driver-car combinations.

In a one-to-many relationship, one record in a table can be associated with _______ records in another table.

• one

• multiple

• zero

• infinite

Answer explanation

In a one-to-many relationship, one record in a table can be associated with multiple records in another table. This means that a single entry can link to many entries, making 'multiple' the correct choice.