1. What is normalisation?
|
a)
A database
b)
The method to allow complex queries to be carried out
c) The method to transform a 'flat file' into a linked structure that can be implemented in
a relational database
d) A way of finding out about your current system
e)
A method to create menu structures
|
|
|
2. What is meant by an asterisk * placed after an attribute name e.g. HIRE NO* ?
|
a)
The attribute is a Foreign Key
b)
The attribute is a Primary Key
c)
The attribute is a Field
d)
The attribute is a Type
|
|
|
3. What are Normal Forms?
|
a)
The forms or screens used to enter data
b) A generic (or nonspecific) database
c) A collection of data on a spreadsheet
d) The series of logical steps applied to database data and tables
|
|
|
4. What are the three main levels of Normal Form?
|
a)
First Normal Form - Second Normal Form - Third Normal Form
b)
Second Normal Form - Third Normal Form - Fourth Normal Form
c)
Third Normal Form - Fourth Normal Form - Fifth Normal Form
d)
Fourth Normal Form - Fifth Normal Form - Sixth Normal Form
e)
Fifth Normal Form - Sixth Normal Form - Seventh Normal Form
|
|
|
5. What is meant by a double asterisk ** placed after an attribute name e.g. CUST NO**?
|
a)
The attribute is a Primary Key
b)
The attribute is a Field
c)
An error has been highlighted
d)
The attribute is a Foreign Key
|
|
|
6. What is the conventional way of showing a Many to One relationship?
|
a)
1:M
b)
M:1
c)
 :1
d)
1:1
e)
M:N
|
|
|
|
First
Normal Form Exercise >>>>
|
