Database Normalisation

Database Normalisation

12th Grade

37 Qs

quiz-placeholder

Similar activities

ULANGAN HARIAN KE-1 SMT GENAP INFORMATIKA KELAS XII FASE F

ULANGAN HARIAN KE-1 SMT GENAP INFORMATIKA KELAS XII FASE F

12th Grade

35 Qs

[SMP-VII] Soal ASAS 2024 Ganjil

[SMP-VII] Soal ASAS 2024 Ganjil

7th Grade - University

40 Qs

Latihan Soal AAS Ganjil Kelas 7

Latihan Soal AAS Ganjil Kelas 7

7th Grade - University

40 Qs

Final Revision G12_2T

Final Revision G12_2T

12th Grade

37 Qs

[SMP-IX] ASAS 2024 Ganjil

[SMP-IX] ASAS 2024 Ganjil

9th Grade - University

40 Qs

PRE TEST_OS_MIDTERMS

PRE TEST_OS_MIDTERMS

12th Grade

40 Qs

java

java

10th - 12th Grade

40 Qs

BTec DIT Comp3 - Revision

BTec DIT Comp3 - Revision

10th - 12th Grade

40 Qs

Database Normalisation

Database Normalisation

Assessment

Quiz

Computers

12th Grade

Practice Problem

Hard

Created by

Moses Balogun

Used 11+ times

FREE Resource

AI

Enhance your content in a minute

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

37 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Normalisation is:

Removing all necessary data from a database

Organising a database to remove repeated entries and increase the accuracy of the data

Putting fields from different tables into one big database

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following statements fully describes data in 2NF:

When any repeating fields have been removed and the table is given a primary key

When all repeating entries of data are removed and the fields in each table are directly related to the primary key and no fields are present that are not related to each other

When all the fields in each table are directly related to the primary key

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An advantage of normalisation is:

The storage space needed for a normalised database is likely to be smaller

The process of normalising a database is very easy and doesn’t require any skill

It is possible to see previous details that have been changed, such as a customer’s address, as we can look back at an older entry

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is an atomic field?

A field that contains multiple items of data

A field that is repeated

A field that contains only one item of data

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

What is a foreign key?

A unique identifier in a database

A primary key of one table that appears in another table

A field that should not be in a table and needs removing

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A relation is in 1NF if it doesn't contain any ____________?

Determinants

Repeating groups

Null values in primary key fields

Functional dependencies

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?

Remove any functional dependencies from both relations

Assign both relations the same primary key field(s)

Create a primary key(s) for the new relation

Create a free account and access millions of resources

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?