Question 1

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at Premiere Products were combined?

Accepted Answer

The answer of List the three practical issues that would...

Question 2

Each branch of Henry Books has a number that uniquely identifies the branch.

Accepted Answer

A) True 
 B)False

Question 3

The Henry Books database uses a two-digit number to represent the publisher code.

Accepted Answer

A) True 
 B)False

Question 4

How many tables make up the Premiere Products database?

Accepted Answer

A)  4 
B)  5 
C)  6 
D)  7

Question 5

The table named ____________________ is used to indicate the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.

Accepted Answer

The answer of The table named ____________________ is used to...

Question 6

The part number appears in the PART table and the ____________________ table in the Premiere Products database.

Accepted Answer

The answer of The part number appears in the PART...

Question 7

The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the Alexamara Marina Group database.

Accepted Answer

The answer of The category number appears in the SERVICE_CATEGORY...

Question 8

The owner number appears in the OWNER table and the ____________________ table in the Alexamara Marina Group database.

Accepted Answer

The answer of The owner number appears in the OWNER...

Question 9

Each order line at Premiere Products contains a total, usually called a(n) ____________________.

Accepted Answer

The answer of Each order line at Premiere Products contains...

Question 10

The ORDER_LINE table in the Premiere Products database contains information about the date an order was placed.

Accepted Answer

A) True 
 B)False

Question 11

The computer calculates the ____________________ for Premiere Products whenever an order is printed or displayed on the screen.

Accepted Answer

The answer of The computer calculates the ____________________ for Premiere...

Question 12

A marina ____________________ uniquely identifies each marina in the MARINA table for Alexamara.

Accepted Answer

The answer of A marina ____________________ uniquely identifies each marina...

Question 13

The customer number appears in the CUSTOMER table and the ____________________ table in the Premiere Products database..

Accepted Answer

The answer of The customer number appears in the CUSTOMER...

Question 14

Each author is uniquely identified by his or her AUTHOR_NUM.

Accepted Answer

A) True 
 B)False

Question 15

Alexamara Marina Group offers in-water storage to boat owners by providing boat ____________________ that boat owners can rent on an annual basis.

Accepted Answer

The answer of Alexamara Marina Group offers in-water storage to...

Question 16

Which of the following tables relates books to authors?

Accepted Answer

A)  BOOK 
B)  AUTHOR 
C)  WROTE 
D)  INVENTORY

Question 17

Information about the services requested by Alexamara owners is stored in the ____ table.

Accepted Answer

A)  MARINA 
B)  MARINA_SLIP 
C)  SERVICE_REQUEST 
D)  OWNER

Question 18

Because Premiere Products wants the flexibility to quote and charge different prices to different customers, the QUOTED_PRICE column is included in the ORDER_LINE table.

Accepted Answer

A) True 
 B)False

Question 19

Premiere Products sells appliances, toys, and kitchen gadgets.

Accepted Answer

A) True 
 B)False

Question 20

The ____ field of the WROTE table of Henry Books indicates the order in which the authors of a particular book are listed on the cover.

Accepted Answer

A)  ORDER 
B)  SEQUENCE 
C)  ORDERS 
D)  NUMBER

Exam 1: Introduction to Premiere Products, Henry Books, and Alexamara Marina Group

List the three practical issues that would need to be dealt with if the ORDERS table and the ORDER_LINE table at Premiere Products were combined?

Each branch of Henry Books has a number that uniquely identifies the branch.

The Henry Books database uses a two-digit number to represent the publisher code.

How many tables make up the Premiere Products database?

The table named ____________________ is used to indicate the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.

The part number appears in the PART table and the ____________________ table in the Premiere Products database.

The category number appears in the SERVICE_CATEGORY table and the ____________________ table in the Alexamara Marina Group database.

The owner number appears in the OWNER table and the ____________________ table in the Alexamara Marina Group database.

Each order line at Premiere Products contains a total, usually called a(n) ____________________.

The ORDER_LINE table in the Premiere Products database contains information about the date an order was placed.

The computer calculates the ____________________ for Premiere Products whenever an order is printed or displayed on the screen.

A marina ____________________ uniquely identifies each marina in the MARINA table for Alexamara.

The customer number appears in the CUSTOMER table and the ____________________ table in the Premiere Products database..

Each author is uniquely identified by his or her AUTHOR_NUM.

Alexamara Marina Group offers in-water storage to boat owners by providing boat ____________________ that boat owners can rent on an annual basis.

Which of the following tables relates books to authors?

Information about the services requested by Alexamara owners is stored in the ____ table.

Because Premiere Products wants the flexibility to quote and charge different prices to different customers, the QUOTED_PRICE column is included in the ORDER_LINE table.

Premiere Products sells appliances, toys, and kitchen gadgets.

The ____ field of the WROTE table of Henry Books indicates the order in which the authors of a particular book are listed on the cover.