Database Design Revision pre topic quiz

This entity-occurrence diagram shows the links between instances in two entities.

What is the relationship between the two entities?

• One-to-many

• Many-to-many

• One-to-one

• Indeterminate

Examine the data model which contains the following tables.

Which is the correct entity-relationship diagram for the model?

• 
• 
• 
• 

Consider the following statements.

•   An employee can make several sales throughout the day.

•     Each sale is made by only one employee.

Which entity-relationship diagram represents the statements?

• 
• 
• 
• 

Consider the following entity-relationship diagram and complete the statement that it represents.

A car is repaired by:

• one mechanic, but a mechanic can repair several cars.

• several mechanics and each mechanic repairs only one car.

• several mechanics and each mechanic repairs several cars.

• one mechanic and a mechanic only repairs one car.

The following database table is used by a company.

Which would be the correct query to only produce a list of businesses and the number of locations they have?

• 
• 
• 
•