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

Question 1

The Premiere Products database includes four tables.

Answer 1

False

Question 2

The part description is stored with the information about parts.

Answer 2

True

Question 3

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

Answer 3

False

Question 4

In the Henry Books database, the AUTHOR table contains the author's number, name, and address.

Question 5

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.

Question 6

Each author is uniquely identified by his or her AUTHOR_NUM.

Question 7

All the sales representatives at Premiere Products get the same commission rate.

Question 8

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

Question 9

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

Question 10

In some database systems, the word "order" has a special purpose.

Question 11

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

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.

Question 13

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

Question 14

Premiere Products sells appliances, toys, and kitchen gadgets.

Question 15

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.

Question 16

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

Question 17

The WROTE table in the Henry Books database relates publishers and books.

Question 18

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

Question 19

The BOOK table at Henry Books includes the author number.

Question 20

An example of a relationship between categories is the relationship that exists in the Premiere Products database between sales reps and customers.

Question 21

In the Henry Books database, the table named BOOK contains information about whether or not a book is available at a particular branch.

Question 22

Premiere Products sells ____.

A) books
B) residential and commercial property
C) appliances, housewares, and sporting goods
D) electronic products

Question 23

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

A) footing
B) extension
C) trailer
D) sum

Question 24

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

A) wholesale price
B) part description
C) part weight
D) part color

Question 25

How many tables make up the Premiere Products database?

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

Question 26

The LENGTH column in the MARINA_SLIP table in the Alexamara Marina Group stores the length of the boat in meters.

Question 27

A category name uniquely identifies each service that Alexamara performs.

Question 28

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

A) title
B) code
C) publisher
D) author

Question 29

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

A) city
B) number
C) name
D) code

Question 30

In the WROTE table of the Henry Books database, the SEQUENCE field indicates the order in which the authors of a particular book are listed on the cover.

Question 31

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

A) part number
B) number ordered
C) customer number
D) unit price

Question 32

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

Question 33

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

A) total sales
B) commission rate
C) customers
D) order number

Question 34

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

Question 35

When designing tables a ____ structure is preferred.

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

Question 36

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

Question 37

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.

Question 38

The AUTHOR table is used to relate books and authors.

Question 39

Combining the ORDER_LINE and ORDERS tables will ____.

A) save space in the table
B) make the table more effective
C) increase space in the table
D) make the table more complicated

Question 40

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

Question 41

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

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

Question 42

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

A) SALES
B) LOCATION
C) AUTHOR
D) PART

Question 43

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

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

Question 44

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

Question 45

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

Question 46

Alexamara owns ____ marinas.

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

Question 47

An owner number in the OWNER table at Alexamara Marina consists of ____ uppercase letters followed by a two-digit number.

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

Question 48

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

Question 49

The ____________________ of the order form at Premiere Products contains the order number and date; the customer's number, name, and address; and the sales rep's number and name.

Question 50

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.

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

Question 51

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

Question 52

Alexamara stores information about its marinas in the ____ table.

A) SERVICE
B) MARINAS
C) MARINA
D) ALEXAMARA

Question 53

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

Question 54

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

A) sequence
B) owner
C) name
D) ID

Question 55

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

Question 56

Which of the following tables relates books to authors?

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

Question 57

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

A) BOOKS
B) BRANCH
C) INVENTORY
D) WROTE

Question 58

The order number appears in the ORDERS table and the ____________________ table in the Premiere Products database.

Question 59

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

Question 60

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

Question 61

Why does the Premiere Products database use the table ORDERS instead of ORDER?

Question 62

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.

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

If another appointment is required to complete additional service, the appointment date appears in the NEXT_SERVICE_DATE column of the ____________________ table of Alexamara.

Question 69

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

Question 70

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?

Question 71

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

Question 72

Ray tracks the branch's name, location, and number of ____________________ for Henry Books.

Question 73

In the AUTHOR table, Ray tracks for Henry Books each author's last and first names and a(n) ____________________.

Question 74

The branch number appears in the BRANCH table and the ____________________ table in the Hnery Books database.

Question 75

For each book, Ray at Henry Books tracks the book code, ____________________, publisher code, type of book, price and whether the book is paperback.