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

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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

Question 5

The Unix operating system is an example of a popular open source program.

Question 6

The Premiere Products database includes four tables.

Question 7

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

Question 8

The BOOK table at Henry Books includes the author number.

Question 9

Premiere Products sells software, hardware, and appliances.

Question 10

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

Question 11

At Premiere Products, the three sections of an order are the top, body, and bottom.

Question 12

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 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

The LENGTH column in the MARINA_SLIP table in the Alexamara Marina Group stores the length of the slip in feet.

Question 20

The Premiere Products order form was not created in MySQL.

Question 21

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

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

Question 22

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 23

A category name uniquely identifies each service that Alexamara performs.

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)quantity ordered

Question 25

The part description is stored with the information about parts.

Question 26

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

Question 27

The AUTHOR table is used to relate books and authors.

Question 28

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 29

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

Question 30

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 31

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 a more complicated table

Question 32

How many tables make up the Premiere Products database?

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

Question 33

Each author is uniquely identified by his or her AUTHOR_NUM.

Question 34

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

Question 35

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

Question 36

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 37

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 38

SQL stands for Syntactical Question Language.

Question 39

Premiere Products sells ____.

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

Question 40

When designing tables a ____ structure is preferred.

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

Question 41

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 42

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

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

Question 43

Alexamara stores information about its marinas in the ____ table.

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

Question 44

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

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

Question 45

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

Question 46

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

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

Question 47

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 48

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

Question 49

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

Question 50

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 51

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

Question 52

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

Question 53

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 54

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

Question 55

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 56

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

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

Which of the following tables relates books to authors?

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

Question 59

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

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

Question 60

Alexamara owns ____ marinas.

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

Question 61

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

Question 62

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 63

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

Question 64

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 65

What are some of the advantages of open source software?

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

The ____________________ operating system is an example of a popular open source program.

Question 71

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

Question 72

Ray tracks for Henry Books each author's last and first names and a(n)____________________.

Question 73

A(n)______________________________ is a software program that lets you create a database and then use it to add, change, delete, sort, and view the data in a database.

Question 74

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 75

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