Database Software Basics

Question 1

An author keeps track of income and expenses in a table: ✔ flat filerelational database

Revolt · Accepted Answer

A: flat file

Question 2

What is an advantage of using a relational database instead of a flat file to store, organize, and analyze data?

Revolt · Accepted Answer

C: It is easier to minimize duplicate data in a relational database.

Question 3

What does each row represent? ✔ a recorda fielda foreign keya primary key

Revolt · Accepted Answer

A: a record

Question 4

Refer to the illustration below to answer the following questions. Use the drop-down menus to make your selections.What is the primary key in Table 1? ✔ Student ID NumberNameGrade

Revolt · Accepted Answer

A: Student ID Number

Question 5

What is the foreign key in the Players Table? ✔ TeamRankingPositionName

Revolt · Accepted Answer

A: Team

Question 6

What links the Football Teams table to the Players table?

Revolt · Accepted Answer

B: Team

Question 7

Use the drop-down menus to answer the following questions. What is the primary key in Table 1? What is the primary key in Table 2? Which table is the cross-referencing table?

Revolt · Accepted Answer

B: Store ID Number

Question 8

Use the drop-down menus to answer the following questions.Which table contains foreign keys? Which type of relationship is represented by the letter A? Which type of relationship is represented by the letter B? Which type of relationship is represented by the letter C?

Revolt · Accepted Answer

C: Table 3

Question 9

A college admissions department stores detailed information about each applicant, including his or her full name, address, high school, GPA, standardized test scores, intended major, and entrance exam scores: flat file✔ relational database

Revolt · Accepted Answer

B: relational database

Question 10

What is a disadvantage of using a relational database instead of a flat file to store, organize, and analyze data?

Revolt · Accepted Answer

D: It is difficult to use a relational database without prior knowledge.

Database Software Basics Answers

More from this Course

TRY EDGENUITY HACKS