IT Unit 2 Normalisation

Flat file databases (such as an excel spreadsheet) need to be organised into categories in order to create linkable tables of atomic data. Put the following options into appropriately named tables.

Groups:

(a) tbl_Customer

,

(b) tbl_Event

• EventDescription

• Surname

• EventDate

• CustomerID

• EventID

• FirstName

Flat file databases (such as an excel spreadsheet) need to be organised into categories in order to create linkable tables of atomic data. Put the following options into appropriately named tables.

Groups:

(a) tbl_Products

,

(b) tbl_customer

• ProductPrice

• ProductID

• Postcode

• ProductDescription

• FirstName

• Surname

Organize these options into the right categories

Groups:

(a) tbl_TicketType

,

(b) tbl_ticket

• TicketCost

• TicketNumber

• CustomerID

• TicketType

• TicketTypeID

Flat file databases (such as an excel spreadsheet) need to be organised into categories in order to create linkable tables of atomic data. Put the following options into appropriately named tables.

Groups:

(a) tbl_CustomerType

,

(b) tbl_Customer

• CustomerID

• Surname

• FirstName

• CustomerTypeID

• CustomerType

Normalisation is:

• Organising a database to remove duplication of data, and maintain the accuracy / integrity of the data

• Filling in empty fields so that all rows / tuples contain data.

• Putting fields from different tables into one big database.

An advantage of normalisation is:

• 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

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

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

What is the primary goal of the first normal form (1NF) in database normalisation?

• To remove duplicate columns from the same table.

• To ensure each table cell contains unique and atomic data.

• To separate different relations into different tables.

What is an atomic field?

• A field that contains only one item of data

• A field that contains multiple items of data

• A field that is repeated

When a user cannot find a suitable field to become a primary key, they use a ________ Key ​ (a)  

• composite
• foreign
• secondary
• house

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

• Assign both relations the same primary key

• Ensure that both smaller relations have primary keys

• Remove any functional dependencies from both relations