Database Normal Forms Quiz

Database Normal Forms Quiz

11th Grade

8 Qs

quiz-placeholder

Similar activities

Computer Basics 2 - CESA

Computer Basics 2 - CESA

7th Grade - University

10 Qs

WAN Sesi 1

WAN Sesi 1

1st Grade - University

10 Qs

HARD DISK DRIVE

HARD DISK DRIVE

11th - 12th Grade

10 Qs

Bài làm việc Access, cấu trúc bảng

Bài làm việc Access, cấu trúc bảng

9th - 12th Grade

10 Qs

Jarkom

Jarkom

1st Grade - Professional Development

11 Qs

DTJSQuiz

DTJSQuiz

11th Grade

10 Qs

Testas: Saugesnis internetas

Testas: Saugesnis internetas

11th Grade

10 Qs

ULANGAN HARIAN TIK

ULANGAN HARIAN TIK

10th Grade - University

10 Qs

Database Normal Forms Quiz

Database Normal Forms Quiz

Assessment

Quiz

Computers

11th Grade

Practice Problem

Hard

Created by

RESMI ICT TEACHER

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

8 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Storing the same data multiple times in a database.

Inefficient Data Maintenance

Non-Key/Transitive Dependency

Lack Of Data Flexibility

Data Duplication/Redundancy

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A table is in this NF if it is in 1NF and all non-key attributes are fully functionally dependent on the entire primary key (applies to tables with composite primary keys).

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The process of organizing data in a database to reduce redundancy and improve data integrity.

Data Duplication/Redundancy

Insert Anomaly

Normalization (Database)

Atomicity (in Databases)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The property of a column holding only indivisible values.

Normalization (Database)

Atomicity (in Databases)

Third Normal Form (3NF)

Data Duplication/Redundancy

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A dependency where a non-key attribute depends on only part of a composite primary key.

Update Anomaly

Functional Dependency

Partial-Key Dependency

Non-Key/Transitive Dependency

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A dependency where a non-key attribute depends on another non-key attribute, which depends on the primary key. (A -> B -> C)

Data Duplication/Redundancy

Partial-Key Dependency

transitive/Functional Dependency

Non-Key/Transitive Dependency

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Inconsistency in data resulting from a partial update.

Insert Anomaly

Insertion Anomaly

Delete Anomaly

Update Anomaly

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?