NEW
Font size
S
M
L
XL
WorksheetsRelationships
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
What should a primary key contain?
a)
A lot of different values
b)
A null value
c)
An unique value
2.
Is it possible to have dublicated foreign keys in a helping table?
a)
YES
b)
NO
3.
A relationship is?
a)
a list of keys or keywords which identify a unique record and can be used to search and sort records more quickly
b)
a field in a table that refers to the primary key in another table
c)
the extent to which a database has been normalised
d)
the way in which two entities in two different tables are connected
4.
What relationship is does this ERD show?
a)
Many-to-many relationship.
b)
Many-to-one relationship.
c)
One-to-one relationship.
d)
One-to-many relationship.
5.
What relationship is does this ERD show?
a)
Many-to-many relationship.
b)
Many-to-one relationship.
c)
One-to-one relationship.
d)
One-to-many relationship.
6.
A field of one table which is also a primary key of another table. It is used to establish links between entities in the database.
a)
Primary key
b)
Foreign key
c)
Attribute
d)
Relationships
7.
A relationship between two entities in which one instance in the first entity can be related to many instances in the second entity, and an instance in the second entity can be related to at most one instance in the first entity.
a)
1:m relationship
b)
m:n relationship
c)
1:1 relationship
d)
recursive relationship
8.
Normally, foreign key is found in child table which serves the purpose of connecting to the parent table.
a)
False
b)
True
9.
For the top or order table, which is the primary key?
a)
order date
b)
customer id
c)
order number
d)
order table
10.
For the top or order table, which is the foreign key which connects to the bottom customer table?
a)
customer key
b)
customer id
c)
order number
d)
order date
Reset
