Creating Database Tables

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