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

A category name uniquely identifies each service that Alexamara performs.

How many tables make up the Premiere Products database?

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.

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

When designing tables a ____ structure is preferred.

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

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

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

Alexamara owns ____ marinas.

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.

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

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

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

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