a) True
b) False
2) Matrix Diagrams are developed BEFORE the ERD. True or False?
a) True
b) False
3) One Relationship can be both mandatory and optional at different ends. True or False?
a) True
b) False
4) Relationship Names are optional. True or False?
a) True
b) False
5) To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False?
a) True
b) False
6) As a database designer you do not need to worry about where in the datamodel you store a particular attribute, as long as you get it onto the ERD your job is done. True or False?
a) True
b) False
7) People are not born with "numbers", but a lot of
systems assign student numbers, customer IDs, etc.
A shoe has a color, a size, a style, but may not have
a descriptive "number". So, to be able to uniquely and efficiently identify
one instance of the entity SHOE, a/an ______________ UID can be created.
a) Artificial
b) Unrealistic
c) Structured
d) Identification
8) All entities must be given a new artificial UID. True or False?
a) True
b) False
9) Any Non-UID must be dependant on the entire UID. True or False?
a) True
b) False
10) When is an entity in 2nd Normal Form?
a) When all bon-UID attributes are dependent upon the
entire UID. (*)
b) When no attritibutes are mutually independant and
fully independent on the primary key.
c) When no attritibutes are mutually independent and
all are fully dependent on the primary key.
d) None of the Above.
11) An entity without repeated values is said to be on 1st Normal Form. True or False?
a) True
b) False
12) When data is only stored in one place in a database, the database conforms to the rules of ___________.
a) Normality
b) Reduction
c) Normalization
d) Multiplication
---
Suggested Answers
1) b
2) b
3) a
4) b
5) a
6) b
7) a
8) b
9) a
10) a
11) a
12) c
