Tech+ Objective 5 - Database

What is a relational database?

• A database that is built from a set of unique tables containing data about one entity
•  A database with one single large table
•  A set of many databases about numerous, related topics

What is a foreign key?

•  A foreign key is a primary key that appears in another table to create a relationship between the two tables
•  A foreign key is a field that does not belong in that table
•  A foreign key is a field that is a unique identifier in that entity

What would you use a query for?

• To export and present information from a database
•  To enter data into a database
•  To search and filter a database

Why would you create a report?

•  To store data in the database
•  To present data in a user-friendly way
•  To search the database

A database is:

• An organised collection of data or information
• A collection of software
• A collection of drivers

Which of the following is a tool to store, edit and organise a database?

• A database management system (DBMS)
• A database
• SQL

What is SQL?

• A programming language used to search and query databases
• A programming language used to build databases
• A programming language used to debug databases

What is a foreign key?

• A foreign key is a primary key that appears in another table to create a relationship between the two tables
• A foreign key is a field that is a unique identifier in that entity
• A foreign key is a field that does not belong in that table

A tool used to organize, store, retrieve, and communicate groups of related information. 

• Spreadsheet
• Word
• Presentations
• Database

Which of the following is a common database program?

• Access
• Excel
• InDesign
• Badata