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

At Alexamara Marina Group, marina slips are numbered within each section.

The footing of the order at Premiere Products contains the order ____________________.

At Premiere Products, the body of the order contains the order number and date; the customer's number, name, and address; and the sales rep number and name.

Each book at Henry Books is uniquely identified with a(n)____.

Alexamara stores information about its marinas in the ____ table.

____________________ is currently the world's most popular open source database.

The Premiere Products order form was not created in MySQL.

The Alexamara Marina Group database uses two uppercase letters to represent an owner number.

Why would you not combine the two tables ORDERS and ORDER_LINE at Premiere Products?

The BRANCH, PUBLISHER, and ____ tables are part of the Henry Books Database.

Which of the following tables relates books to authors?

The three components of a Premiere Products order are the heading, ____________________, and footing.

The INVENTORY table at Henry Books includes a column that stores the number of books on hand.

The order line in a Premiere Products order form contains a total that is called a(n)____.

The part description is stored with the information about parts.

Each row in the table MARINA_SLIP at Alexamara contains a slip ____ that identifies the particular slip.

The body of the order contains one or more order lines, sometimes called line ____________________.

Each publisher has a ____ that uniquely identifies the publisher at Henry Books.

The REP table consists of the sales representatives' number, last name, first name, address, total commission, and ____.

____________________ is software for which the source code is freely and publicly available