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

The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.

(Multiple Choice)

4.8/5

(37)

Question 21

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

(Multiple Choice)

5.0/5

(35)

Question 22

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

(Multiple Choice)

4.8/5

(35)

Question 23

The BOOK table at Henry Books includes the author number.

(True/False)

4.7/5

(48)

Question 24

The author number appears in the AUTHOR table and the ____________________ table in the Henry Books database.

(Short Answer)

4.9/5

(33)

Question 25

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

(Short Answer)

4.8/5

(39)

Question 26

The INVENTORY table in the Henry Books database includes data on books and branches.

(True/False)

4.8/5

(34)

Question 27

Each line in the Premiere Products order form contains a part number, the number of units of the ordered part, the quoted price, and ____.

(Multiple Choice)

4.7/5

(44)

Question 28

The Premiere Products database contains information that relates sales reps to the customers they represent and customers to the ____________________ they have placed.

(Short Answer)

5.0/5

(39)

Question 29

Each row in the ORDER_LINE table has an order number, part number, number ordered, quoted price, and total amount.

(True/False)

4.9/5

(36)

Question 30

The ORDERS table consists of the order number, order date, and ____.

(Multiple Choice)

4.8/5

(43)

Question 31

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

(Short Answer)

4.8/5

(36)

Question 32

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

(Short Answer)

4.8/5

(32)

Question 33

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

(True/False)

4.7/5

(30)

Question 34

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.

(True/False)

4.9/5

(38)

Question 35

At Premiere Products, the three sections of an order are the heading, body, and footing.

(True/False)

4.8/5

(44)

Question 36

The Alexamara Marina Group database uses a combination of letters and numbers to represent an owner number.

(True/False)

4.7/5

(30)

Question 37

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

(True/False)

4.8/5

(36)

Question 38

Alexamara provides a variety of boat repair and maintenance services to the boat owners.

(True/False)

4.9/5

(42)

Question 39

Alexamara stores information about the boat owners to whom it rents slips in the ____________________ table.

(Short Answer)

4.9/5

(35)

Question 40

Showing 21 - 40 of 75

The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.

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

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

The BOOK table at Henry Books includes the author number.

The author number appears in the AUTHOR table and the ____________________ table in the Henry Books database.

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

The INVENTORY table in the Henry Books database includes data on books and branches.

Each line in the Premiere Products order form contains a part number, the number of units of the ordered part, the quoted price, and ____.

The Premiere Products database contains information that relates sales reps to the customers they represent and customers to the ____________________ they have placed.

Each row in the ORDER_LINE table has an order number, part number, number ordered, quoted price, and total amount.

The ORDERS table consists of the order number, order date, and ____.

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

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

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

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.

At Premiere Products, the three sections of an order are the heading, body, and footing.

The Alexamara Marina Group database uses a combination of letters and numbers to represent an owner number.

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

Alexamara provides a variety of boat repair and maintenance services to the boat owners.

Alexamara stores information about the boat owners to whom it rents slips in the ____________________ table.

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters