Search Header Logo

Database Normalization and Dependencies Worksheet

Authored by simar kaur

Computers

Professional Development

Database Normalization and Dependencies Worksheet
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

30 sec • 1 pt

3rd Normal Form (3NF) means that all non-key columns in a table are only associated with the primary key.

True

False

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

We know this is a time anomaly, therefore we decide to:

Add another column in a different table to keep track of the current price

Add a column to a different table to keep track of the current price and remove the column with changing prices.

Create a new table for both a current fee and a past fee

Do nothing it will work itself out ... in time. ;)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

When looking for partial functional dependencies we look in the following tables

Tables with a single field primary key

Tables with a composite primary key

Tables with a foreign key

Tables with both a single field primary key and a foreign key

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

We remove derived dependencies in...

1NF

2NF

3NF

Derived dependencies are never removed

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If a non-key attribute depends on another non-key attribute in the same table this is referred to as a

Partial Functional Dependency

Functional Dependency

Transitive Dependency

Composite Dependency

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If a non-key column can be determined by part of a composite primary in the same table this is referred to as a(n)

Partial Functional Dependency

Functional Dependency

Transitive Dependency

Composite Dependency

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The process of structuring a relational database to reduce data redundancy and improve data integrity is called

DRT (data redundancy technique)

Normalization

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?