Normalisation

Which one is not an advantage of a normalised database over a un-normalised database

• Faster sorting and searching

• Deleting Records

• Maintaining and modifying the database

• Having foreign keys in the database tables

What doe NF stand for?

• Normalisation Form

• Normal Forms

• Normal Files

• Normalisation Files

What is normalisation?

• The process used to come up with the best possible design for a relational database

• The process used to break down tables

• The process used to define primary keys

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.

Look at this example and indicate the name of the entity

Book (Bookid, DeweyCode, Title, Author, DatePublished)

Look at this example and indicate the name of the primary key

Book (Bookid, DeweyCode, Title, Author, DatePublished)

How many Normal Forms are there?

• 3

• 2

• 1

• 4