Database Design & Development Normalisation 1

Database Design & Development Normalisation 1

University

12 Qs

quiz-placeholder

Similar activities

Round 2: Solve It

Round 2: Solve It

University

9 Qs

Sains Komputer Tingkatan 4 - 2.2.6 Melaksanakan proses

Sains Komputer Tingkatan 4 - 2.2.6 Melaksanakan proses

1st Grade - Professional Development

8 Qs

MBL_Flutter_03

MBL_Flutter_03

University

10 Qs

DBMS Quiz-1 (BCS3C)

DBMS Quiz-1 (BCS3C)

University

10 Qs

SE2 (LEC) Week 3 - 4 Gantt Chart

SE2 (LEC) Week 3 - 4 Gantt Chart

University

14 Qs

Spring and Spring boot

Spring and Spring boot

University

10 Qs

Understanding Database Normalization

Understanding Database Normalization

University

10 Qs

Java Programming Pt. 1

Java Programming Pt. 1

University

10 Qs

Database Design & Development Normalisation 1

Database Design & Development Normalisation 1

Assessment

Quiz

Computers

University

Medium

Created by

Nicole Donnelly

Used 2+ times

FREE Resource

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main goal of the First Normal Form (1NF) in database normalisation?

To eliminate repetitive groups of data

To ensure referential integrity

To reduce data redundancy

To establish foreign keys

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which form of normalisation is achieved when transitive dependencies are removed?

First Normal Form

Second Normal Form

Third Normal Form

Boyce-Codd Normal Form

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a partial dependency in the context of normalisation?

A dependency on a non-primary key

A dependency involving a candidate key

A dependency on part of a composite key

A dependency on a foreign key

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In which normal form is a table if it contains no transitive dependencies but still has partial dependencies?

1NF

2NF

3NF

4NF

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a characteristic of a table in Second Normal Form (2NF)?

It has no transitive dependencies

It has no partial dependencies

It has no duplicated data

It has a primary key

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When is a table considered to be in Third Normal Form (3NF)?

When it is in 2NF and all non-key attributes are mutually independent

When it is in 2NF and there are no transitive dependencies

When it is in 1NF and all attributes are atomic

When it is in 4NF and has no multivalued dependencies

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the term "functional dependency" imply in the context of normalisation?

An attribute uniquely determines another attribute

A table is in 2NF

There are no repeating groups

All attributes are atomic

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?