Creating a Database

Question 1

In which of the following situations should you use a database? Check all that apply.

Revolt · Accepted Answer

Situation 1; Situation 3; Situation 4

Question 2

What is the primary key in the Rooms table?

Revolt · Accepted Answer

Room Number

Question 3

What is the primary key in the Courses table?

Revolt · Accepted Answer

Course ID Number

Question 4

What is the primary key in the Professors table?

Revolt · Accepted Answer

Professor ID Number; Room Number; Course ID Number

Question 5

What is the foreign key in the Courses table that creates a link to the Professors table?

Revolt · Accepted Answer

Professor ID Number; Course ID Number

Question 6

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

Revolt · Accepted Answer

to store large amounts of information

Question 7

Which option is the best way to organize your data?

Revolt · Accepted Answer

Option B

Question 8

What is the foreign key in the Rooms table that creates a link to the Courses table?

Revolt · Accepted Answer

Course ID Number

Question 9

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?

Revolt · Accepted Answer

You can avoid updating records in multiple places.

Question 10

What is the foreign key in the Professors table that creates a link to the Rooms table?

Revolt · Accepted Answer

Professor ID Number

Creating a Database Answers

More from this Course

TRY EDGENUITY HACKS