Search Header Logo

Normalization with ERD Part #2

Authored by Joseph Huelgas

Instructional Technology

University

Used 12+ times

Normalization with ERD Part #2
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

11 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

Choose the correct 1NF form from the Ticket entity

Media Image
Media Image
Media Image

2.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

In the 2NF form, particularly in the Passenger entity. What is the correct normalized attribute and data type for the passenger entity?

Media Image
Media Image
Media Image

3.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

In the 2NF form, particularly in the Airport entity. What is the correct normalized attribute and data type for the Airport entity?

Media Image
Media Image
Media Image

4.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

In the 2NF form, particularly in the Airline entity. What is the correct normalized attribute and data type for the Airline entity?

Media Image
Media Image
Media Image

5.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

In the 2NF form, particularly in the Flight entity. What is the correct normalized attribute and data type for the Flight entity?

Media Image
Media Image
Media Image

6.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

In the 2NF form, particularly in the Ticket entity. What is the correct normalized attribute and data type for the Ticket entity?

Media Image
Media Image
Media Image

7.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

In the 2NF form, there is a relationship between the passenger and the ticket.

Each passenger can book multiple tickets, and each ticket is for one passenger.

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?