Question 1

A category name uniquely identifies each service that Alexamara performs.

Accepted Answer

A) True 
 B)False

Question 2

How many tables make up the Premiere Products database?

Accepted Answer

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

Question 3

The BRANCH table 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

A) True 
 B)False

Question 4

The overall order total is stored in the Premiere Products database.

Accepted Answer

A) True 
 B)False

Question 5

When designing tables a ____ structure is preferred.

Accepted Answer

A) complex 
B) simple 
C) detailed 
D) complete

Question 6

To work with a database in a computer, you must use a database management system.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

Alexamara owns ____ marinas.

Accepted Answer

A) 2 
B) 3 
C) 4 
D) 5

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

The customer's name and address and the number of the sales rep who represents the customer are stored with sales rep information.

Accepted Answer

A) True 
 B)False

Question 13

A(n)____________________ is a structure that contains different categories of information and the relationships between these categories.

Accepted Answer

The answer of A(n)____________________ is a structure that contains different...

Question 14

Alexamara provides boat maintenance service for owners at its two marinas. The SERVICE_CATEGORY table contains a ____.

Accepted Answer

A) slip ID 
B) marina number 
C) description of the category 
D) marina name

Question 15

The body of a Premiere Products order contains a number of order lines, sometimes called ____________________.

Accepted Answer

The answer of The body of a Premiere Products order...

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

A category name uniquely identifies each service that Alexamara performs.