Creating a Database Answers

21 verified answers
1
Free Preview

Which of the following is the most compelling reason to use a database?

A
to compare data
B
to organize data into columns and rows
C
to perform complex calculations
D
to store large amounts of information
2
Free Preview

Suppose you switched from using a single spreadsheet to multiple data tables in a database. Which of the following advantages are you most likely going to experience by making the switch?

A
You can group information by category.
B
You can organize data into fields and records.
C
You can avoid updating records in multiple places.
D
You can search for specific data.
3

Read the scenarios below, then use the drop-down menus to decide if you should use a database.

Answers:
Selection 1:Product ID
Selection 2:Store ID
Selection 3:Store ID
Selection 4:Store ID
Selection 5:Employee ID
4

Read the scenarios below, then use the drop-down menus to decide if you should use a database.

Answers:
Read the scenarios below, then use the drop-down menus to decide if you should use a database.:Use a database.
Read the scenarios below, then use the drop-down menus to decide if you should use a database.:Do not use a database.
Read the scenarios below, then use the drop-down menus to decide if you should use a database.:Use a database.
7

Read the scenarios below, then use the drop-down menus to decide if you should use a database.

Answers:
Read the scenarios below, then use the drop-down menus to decide if you should use a database.:Do not use a database.
Read the scenarios below, then use the drop-down menus to decide if you should use a database.:Use a database.
Read the scenarios below, then use the drop-down menus to decide if you should use a database.:Use a database.
Read the scenarios below, then use the drop-down menus to decide if you should use a database.:Do not use a database.
11

Why is a database the best tool for managing the social media website’s data? Choose all that apply.

A
The website needs to process credit card payments.
B
The website has a large amount of information that needs to be stored.
C
There are many relationships between different types of information.
D
There is an increasing number of users.
12

Which of the following describes the first step to creating a database?

A
Organize data into logical tables and fields.
B
Create relationships within tables.
C
Determine data to be stored.
D
Create relationships between tables.
13

In which of the following steps do you assign a primary key to each table?

A
Create relationships within tables.
B
Create relationships between tables.
C
Organize data into logical tables and fields.
D
Determine data to be stored.
14

How should you set up the database?

A
Use one large table containing all information.
B
Use several interrelated tables.
C
Use one table for each city and each state.
15

Which of the following should you choose for the tables?

A
one table called Populations and another table called Cities
B
one table called Primary Industry, a second table called States, and a third table called Cities
C
one table called States and another table called Cities
17

What is the primary key in the Products table? ✔ Product IDStore IDName

Answers:
Selection 1:Product ID
Selection 2:Store ID
Selection 3:Store ID
Selection 4:Store ID
Selection 5:Employee ID

Did you find these answers helpful?