Problem

Consider Figure 1-14. Explain the meaning of the line that connects ORDER to INVOICE and...

Consider Figure 1-14. Explain the meaning of the line that connects ORDER to INVOICE and the line that connects INVOICE to PAYMENT. What does this say about how Pine Valley Furniture Company does business with its customers?

FIGURE 1-14 Preliminary data model for Home Office product line marketing support system

Step-by-Step Solution

Solution 1

Preliminary model for home office product line marketing support system:

C:\Users\203528\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\XM6CDYI1\Dilshatbegum_1094-3-1-18PE.jpg

• In the above data model,

o ORDER, INVOICE, and PAYMENT are the three entities.

o Entities are connected through the relationship.

Relationship between the entities such as ORDER to INVOICE and INVOICE to PAYMENT is shown below:

Relationship between ORDER to INVOICE:

Every order is billed through exactly one statement, so the relationship exists between ORDER to INVOICE entity is “one-to-one” relationship.

Relationship between INVOICE to PAYMENT :

Many payments can be made for single order, so the relationship that exists between the INVOICE to PAYMENT entity is “one-to-many” relationship.

Pine Valley Furniture Company does business with its customers:

Consider the data model in Figure 1-14 given in the book.

The data model of the Preliminary model for home office product line marketing support system contains the entities such as CUSTOMER, ORDER, ORDER LINE, PRODUCT LINE, PRODUCT, INVOICE, and PAYMENT.

• In this data model the customer places a number order to the company and equally each order is placed by exactly one customer.

• Each order contains a number of order lines and equally each order line enclosed in exactly one order.

• Each product has a number of order lines and equally each order line is for exactly one product.

• Each order is billed on one invoice and each invoice is the bill for exactly one order.

Therefore, the Pine Valley Furniture Company uses this data model to do business with its customers.

Add your Solution
Textbook Solutions and Answers Search