NEW
Font size
WorksheetsCreating Database Tables
Total questions: 10
Worksheet time: 5mins
The image shows a database table design. What is the primary key for this table.
Name
TeacherNo
Degree
Phone
The image shows a database table design. What is the primary key for this table.
SubID
SubName
TeacherNo
Subject
Which of the two fields can be linked to create the best relationship between the tables
SubID and TeacherNo
SubName and Name
TeacherNo and Phone
TeacherNo and TeacherNo
In the diagram there are two TeacherNo fields. The one in the Teacher table is the primary key. What is the name given to the one in the Subjects table
Teacher Key
Primary Key
Foreign Key
Composite Key
The diagram shows a relationship between the two tables with the fields hidden. What kind of relationship is it?
one to one
two to two
one to many
What data type should be used for Phone.
Data/Time
Short Text
Number
Currency
What is a suitable data type for TeacherNo
Currency
Yes/No
Number
Hyperlink
How many fields does this table have?
2
3
4
8
When should table relationships be created?
Before creating tables
After entering data
Before entering data
Which view of the database is being displayed?
design view
datasheet view
print preview
normal view
