Search Header Logo

Database Design Revision pre topic quiz

Authored by Fiona Jorgenson

Computers

12th Grade

Database Design Revision pre topic quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

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

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

Examine the data model which contains the following tables.

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

Media Image
Media Image
Media Image
Media Image

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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?

Media Image
Media Image
Media Image
Media Image

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Media Image

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.

5.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Media Image

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?

Media Image
Media Image
Media Image
Media Image

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?