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

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?

(Essay)

4.8/5

(36)

Question 41

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

(True/False)

4.9/5

(48)

Question 42

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

(True/False)

4.9/5

(46)

Question 43

How many tables make up the Premiere Products database?

(Multiple Choice)

4.8/5

(42)

Question 44

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.

(Short Answer)

4.8/5

(36)

Question 45

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

(Short Answer)

4.8/5

(42)

Question 46

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

(Short Answer)

4.8/5

(38)

Question 47

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

(Short Answer)

4.8/5

(28)

Question 48

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

(Short Answer)

4.8/5

(36)

Question 49

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

(True/False)

4.9/5

(41)

Question 50

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

(Short Answer)

4.8/5

(35)

Question 51

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

(Short Answer)

4.8/5

(34)

Question 52

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

(Short Answer)

4.8/5

(34)

Question 53

Each author is uniquely identified by his or her AUTHOR_NUM.

(True/False)

4.8/5

(40)

Question 54

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

(Short Answer)

4.9/5

(42)

Question 55

Which of the following tables relates books to authors?

(Multiple Choice)

4.7/5

(29)

Question 56

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

(Multiple Choice)

4.8/5

(40)

Question 57

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.

(True/False)

4.7/5

(38)

Question 58

Premiere Products sells appliances, toys, and kitchen gadgets.

(True/False)

4.8/5

(31)

Question 59

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.

(Multiple Choice)

4.8/5

(37)

Question 60

Showing 41 - 60 of 75

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?

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

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

How many tables make up the Premiere Products database?

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.

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

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

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

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

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.

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

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

Each author is uniquely identified by his or her AUTHOR_NUM.

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

Which of the following tables relates books to authors?

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

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.

Premiere Products sells appliances, toys, and kitchen gadgets.

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.

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters