Introduction to Databases

What is the use of a Primary Key (PK) in DBMS?

• To define the data type of each column in a table.
• The use of a Primary Key (PK) in DBMS is to uniquely identify each record in a table.
• To group multiple records together in a table.
• To create relationships between different tables.

What is a Foreign Key (FK) in DBMS?

• A Foreign Key is a field that contains only null values.
• A Foreign Key is a type of index used for faster queries.
• A Foreign Key (FK) is a field in one table that links to the primary key of another table, establishing a relationship between the two.
• A Foreign Key is a unique identifier for a table.

A ​ (a)   (FK) is a field in ​ (b)   that​ (c)   to the ​ (d)   key of ​ (e)   , establishing a relationship between the two.

• Foreign Key
• one table
• links
• primary
• another table

A Foreign Key (FK) is a field in one table that links to the primary key of another table, establishing a _______________ (relation...) between the two.

The use of a ​ (a)   Key (PK) in DBMS is to ​ (b)   each ​ (c)   in a ​ (d)   .

• Primary
• uniquely identify
• record
• table

The use of a ____________________ (PK) in DBMS is to uniquely identify each record in a table.

The use of a Primary Key (PK) in DBMS is to ___________________(unique... iden...) each record in a table.

Which field type stores whole numbers in MS Access?

• Currency
• Float
• Integer/Number

• Text

Which field type is best for names and addresses?

• integer
• Short Text or String

• boolean
• date

Which field type would you use to store: "TRUE or FALSE"?

• integer
• string
• date
• boolean or YES/NO