Normalisation

1.Which of the following is TRUE about normalisation?

• It is the process of dividing larger tables into smaller interlinked tables.

• Increases data redundancy.

• It is the process of dividing larger tables into smaller independent tables.

• It is the process of removing duplicate entries in a table.

In which stage of normalisation are the grouped attributes converted to individual attributes?

• 1st

• 2nd

• 3rd

A table in 1NF and with ……………….. is automatically in second Normal Form.

• Composite primary key

• Single primary key

• Multiple foreign keys

Which of the following is the main motive of normalisation?

• Join many smaller tables

• Reduce data redundancy while merging smaller tables

• Creating a larger table with all entities

• None of the above

What doe NF stand for?

• Normalisation Form

• Normal Forms

• Normal Files

• Normalisation Files

Tables in a normalised database should be organised in such a way that:

• no data is unnecessarily duplicated

• data is consistent throughout the database

• the structure of the database is flexible

• complex queries can be ran on the database

• all of the above

Tables may be linked through the use of a common attribute, this attribute is called what?

• Entity

• Composite Key

• Primary Key

• Foreign Key

I have a table in a database called Product and it has the following attributes Product (ProductID, ProductName, CostPrice, SellingPrice). Which one is the primary key

What does non key dependencies mean?

• The value of an attribute is determined by the value of another attribute which is not part of the key.

• The value of an attribute is determined by the value of another attribute which is part of the key.

How many Normal Forms are there?

• 3

• 2

• 1

• 4