Question: Figure 3-13 shows the development of entity clusters for the Pine Valley Furniture E-R diagram. In Figure 3-13b, explain the following: a. Why is the

Figure 3-13 shows the development of entity clusters for the Pine Valley Furniture E-R diagram. In Figure 3-13b, explain the following:

a. Why is the minimum cardinality next to the DOES BUSINESS IN associative entity coming from CUSTOMER zero?

b. What would be the attributes of ITEM (refer to Figure 2-22)?

c. What would be the attributes of MATERIAL (refer to Figure 2-22)?

CUSTOMER CUSTOMER SELUNG UNIT SALESPERSON Customer Type National? Regular? Submits Customer Type Serves DOES BUSINESS IN

CUSTOMER CUSTOMER SELUNG UNIT SALESPERSON Customer Type National? Regular? Submits Customer Type

CUSTOMER CUSTOMER SELUNG UNIT SALESPERSON Customer Type National? Regular? Submits Customer Type Serves DOES BUSINESS IN NATIONAL CUSTOMER REGULAR CUSTOMER SALES TERRITORY Account Manager PRODUCT INE ORDER ITEM SALE Includes VENDOR PRODUCT ORDER LINE SUPPLIER USES PRODUCED IN Contract Number MATERIAL SUPPLIES RAW MATERIAL WORK CENTER 23 EMPLOYEE WORKS IN SKILL HAS SKILL Employee Type d) Employee Type "M" "U" MANAGEMENT EMPLOYEE UNION EMPLOYEE MANUFACTURING Supervises

Step by Step Solution

3.44 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Explanation of Figure 313b questions a Because only regular customers as opposed to n... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

613-CS-DB (1640).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!