3.7 Relational Database Systems

What is the correct way to begin your SQL query if you want to displays data that is stored in a specific table?

• COLLECT
• COMBINE
• SELECT
• CHOOSE

What is a relational database?

• A relational database organizes data into tables, and links them together, based on key-fields. These relationships enable you to retrieve and combine data from one or more tables with a single query
• A relational database arranges data into a tree structure, which is similar to folders and files on a computer. 

Which SQL reserved keyword do you use to combine data from two or more tables, based on a common field between them?

• using SELECT
• using JOIN
• using WHERE
• using GET

What is a relational database?

• Contains a single table

• Two or more linked tables

• Used to create formula's

What is this?

• A flat file database

• A source file

• The relationships between tables

• A query

Looking at the Order Info table, which fields are foreign keys?

• Order ID

• Customer ID

• Book ID

• Order Date

Looking at the Order Info table, which fields are primary keys?

• Order ID

• Customer ID

• Book ID

• Order Date

A row in a database.

• Record
• Field
• Entity
• Table

A column in a database.

• Field
• Record
• Entity
• Validation

A group of related records.

• Entity
• Validation
• Field
• Filter