Database Essentials - Lesson 1

Which of the following consists of multiple tables of information that are related through common fields?

• spreadsheet

• text document

• presentation

• relational database

You are working with a team to compile student and teacher information. This information will be used to connect teachers to students based on classes taken and home addresses. Which software would be the best choice to help with this compilation task?

• spreadsheet

• text document

• presentation

• relational database

You have a large collection of related data. You want to use a relational database but your partner wants to use a spreadsheet. Which of the following would you share with your partner as an advantage of using databases instead of spreadsheets?

• Databases are easier to learn than spreadsheets.

• Databases consist simply of worksheets.

• Only one person can use the same database data at a time.

• Databases remove the need for redundant data.

Data is first collected, then reviewed and revised as needed. Lastly, questions or "queries" are asked about the data to inform decisions or provide insights like "which language classes have more than 30 students" or "how many countries involved in World War I had a population of less than 1 million people at the time of the war". Which tool allows a user to perform all of these tasks - collecting, editing and questioning data?

• Pen and paper

• Calculator

• Text document

• Database

Three people are tracking the results of a single survey. They share their results in different file types via email but the compiled results are inconsistent and questionable. What feature of a database would improve this tracking process?

• Easy to learn and use.

• Good for "crunching" small amounts of data.

• Complex design process.

• Data can be protected against accidental changes.

What kinds of data types can be stored in relational databases?

• Memory

• Processes

• Queries

• Images

You have been tasked with building a database to record and store information for your PTA. The database will contain information about parents, children, teachers, events and fund raising efforts. What attributes of your database define it as a "relational database"?

• Multiple tables in a single query that are used together

• Multiple fields in a single table that are joined to form relationships

• Multiple tables containing related information for a single use

• Multiple tables with common fields that are joined to form relationships

As part of a research project about World War I, you are recording facts and statistics about each country's economy and social structure. Your information may be in a variety of formats: numbers, text, graphics, audio and video. In a relational database, data types can:

• Only consist of text and numbers.

• Consist of text, numbers and some graphic formats.

• Consist of any data types except for sound clips.

• Consist of multiple data types, including text, numbers, graphics, sound clips and video.

Which statement is true about the data types that can be used in relational databases?

• Data types can only consist of text and numbers.

• Data types can consist of text, numbers and some graphic formats.

• Data can consist of any data types except for sound clips.

• Data can consist of multiple data types, including text, numbers, graphics, sound clips and video.

Keisha is a Science Supervisor for all the science teachers in the district. She wants to track all the classes taught by each teacher during school year. What information would be the most helpful for Keisha to have in her database to help her with her tracking?

• Name of Principal, School Address and Name of Teacher.

• Class Title, Room number and Name of Principal.

• School Address, Class title and Teacher's Email.

• Class dates, Class Title and Name of Teacher.