NEW
Font size
S
M
L
XL
Worksheets12CSC Database Normalisation
Total questions: 17
Worksheet time: 9mins
Name
Class
Date
1.
What characteristic does NOT mean that data is in 1NF?
a)
It is all in one table.
b)
There is redundancy.
c)
There is an assigned primary key.
d)
There are duplicate names.
2.
What does Normalisation allow a database designer to do?
a)
Design their database efficiently, removing the chance of redundancy and inaccuracies.
b)
Remove additional records from the tables.
c)
Add as much data as they like.
d)
Draw an ERD.
3.
To be in 1NF:
a)
Each field contains the smallest meaningful value
b)
There are multiple values in the single field
c)
There are no duplicate records
d)
A primary key is assigned
4.
To be in 2NF:
a)
Each non-key field relates to the primary key
b)
There are multiple entries in the same field
c)
There are no foreign keys
d)
All numbers are in decimal form
5.
To be in 2NF:
a)
Any field not relating to the PK is placed in a separate table
b)
The records all relate easily
c)
Each table has a foreign key
d)
There are no redundancies
6.
To be in 3NF:
a)
Records do not depend on anything other than the table's PK
b)
The PK is not added
c)
The FKs are limited to one only
d)
The tables all relate to one another
7.
Tables in 2NF but not 3NF contain...
a)
Insert, update and delete anomalies
b)
No extra FKs
c)
No redundancy
d)
Access to more data
8.
Advantage of 3NF?
a)
It eliminates redundant data which in turn saves space and reduces manipulation anomalies.
b)
It gives the data status.
c)
It allows the tables to be queried in SQL.
d)
It prevents any new updates.
9.
Which one of these do you want to avoid in good database design?
a)
Redundancy!
b)
Giant squid!
c)
Third normal form!
d)
Data!
10.
A foreign key
a)
Links to a primary key in another table.
b)
Links to another foreign key.
c)
Links to another database system.
d)
Should always reference a unique value in the same table.
11.
A primary key
a)
Is a unique identifier for the table. It cannot be null.
b)
Is a unique identifier for the table. It can be null.
c)
Is an identifier that always connects to a foreign key.
d)
Is used in flat file databases.
12.
An ER diagram shows relationships between:
a)
Tables in a relational database.
b)
Rows in a relational database.
c)
Records with foreign keys.
d)
Two items about which there is data kept.
13.
The following ER diagram has how many attributes?
a)
Three
b)
Two
c)
Six
d)
None
14.
One shopper buys many items. How is this expressed as a relationship on an ER diagram?
a)
1:M
b)
M:1
c)
M:N
d)
1:1
15.
Many users access many servers. Why is this statement not a good inclusion in an ER diagram?
a)
It creates duplicates and therefore redundancy.
b)
It is not a good idea to access too many servers.
c)
It is syntactically incorrect.
d)
It involves a bridging entity.
16.
M:N means...
a)
Many to many.
b)
Many to none.
c)
Mandarins to Nigel.
d)
One to one.
17.
Entities (tables) have attributes (fields).
a)
True
b)
False
Reset
