Search Header Logo

Chapter 5

Authored by Aiman Hanif

Computers

University

Used 1+ times

Chapter 5
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main goal of normalization?

Add more tables to the database

Minimize redundancy and avoid anomalies

Speed up queries

Convert SQL to ERD

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a type of anomaly?

Update

Foreign key

Insertion

Deletion

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What causes an update anomaly?

Redundant data stored in multiple rows

Missing foreign key

Incomplete primary key

Empty table

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In 1NF, a table must NOT contain:

Repeating groups

Primary keys

NULL values

Foreign keys

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following ensures a table is in 1NF?

All attributes are atomic and have no repeating groups

All attributes are numeric

All rows are unique

All values are sorted

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a partial dependency?

Non-key attribute depends only on part of a composite key

Attribute depends on foreign key

Primary key is divided

Multiple foreign keys exist

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is required for 2NF?

Only atomic values

No partial dependencies and already in 1NF

No transitive dependencies

At least two candidate keys

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?

Discover more resources for Computers