WorksheetsThe Normalisation Process
Total questions: 8
Worksheet time: 5mins
Which of the 2 following steps must be performed to move data into the first normal form?
Ensure all attributes contain only atomic values.
Any attribute in our entities that is not functionally dependent on all parts of the primary key is moved into a new entity.
All repeated groups of data are removed and put into new entities so that each record within the primary entity is the same length.
Any attribute that is not entirely functionally dependent on the primary key is moved into a new entity.
What does atomic data mean?
Related data must be grouped together.
Data on scientific readings.
Related data must be split into its smallest form.
Repeated groups of data are removed and put into new entities.
To move this data into the first normal form, what 2 actions must we do?
Split Student_Name into separate First_Name & Last_Name fields
Move Student_Name into its own table.
Move Course_Name & Course_Room into its own table and create a copy of the Course_Name in the original table to create a relationship
Delete Course_Room from the table
The second normal form only concerns the tables in our database that have a composite key.
True
False
To move this data into the second normal form, what must we do?
Move Qty into a new table.
Move Item_Price into a new table and a copy of Item
Move Item into a new table
Move Qty & Item_Price into a new table.
When a user cannot find a suitable field to become a primary key, they use a ________ Key
House
Database
Foreign
Composite
What does functional dependency mean?
Data is split into its smallest form.
One attribute uniquely determines another attribute.
Related data is grouped together.
All attributes are free from anomalies.
Third normal form requires, any attribute that is not entirely functionally dependent on the primary key, is moved into a new entity.
True
False
