PLEASE READ THE TABLE AND ANSWER A-B-C-D questions according to table. For the clear and true answers UPVOTE will be given !

Consider the E-R diagram below and answer the following questions. For the ‘how many’ questions, answer in terms of cardinality (e.g. exactly 1, zero-or-one, zero-or-many, etc.) Note that this notation is different from what we have seen in Oracle Data Modeler – a dotted line representing a relationship does not mean optional.

A-) Based on the flowchart how many orders a customer can have?

B-) A product can appear on how many order lines?

C-)Does an employee need to have a corresponding “Works in” to be stored in the database? Briefly (2 sentences approx.) explain your answer.

D-) Does a salesperson need to have a corresponding territory? Briefly (2 sentences approx.) explain your answer.
 

Transcribed Image Text:

SALESPERSON PK Salesperson ID Salesperson Name Salesperson Telephone Salesperson Fax VENDOR PK Vendor ID Vendor Name Vendor Address SUPPLIES Supply Unit Price SKILL PK Skill Serves Is Supervised By TERRITORY PK Territory ID Territory Name PRODUCT LINE PK Product Line ID Product Line Name Includes PRODUCT PK Product ID Product Description Product Finish Product Standard Price USES Goes Into Quantity RAW MATERIAL PK Material ID SupervisesHPK HAS SKILL >ett Material Name Material Standard Cost Unit Of Measure EMPLOYEE Employee ID Employee Name Employee Address || DOES BUSINESS IN CUSTOMER PK Customer ID Customer Name Customer Address Customer Postal Code Submits ORDER PK Order ID Order Date ORDER LINE Ordered Quantity PRODUCED IN WORK CENTER PK Work Center ID Work Center Location WORKS IN SALESPERSON PK Salesperson ID Salesperson Name Salesperson Telephone Salesperson Fax VENDOR PK Vendor ID Vendor Name Vendor Address SUPPLIES Supply Unit Price SKILL PK Skill Serves Is Supervised By TERRITORY PK Territory ID Territory Name PRODUCT LINE PK Product Line ID Product Line Name Includes PRODUCT PK Product ID Product Description Product Finish Product Standard Price USES Goes Into Quantity RAW MATERIAL PK Material ID SupervisesHPK HAS SKILL >ett Material Name Material Standard Cost Unit Of Measure EMPLOYEE Employee ID Employee Name Employee Address || DOES BUSINESS IN CUSTOMER PK Customer ID Customer Name Customer Address Customer Postal Code Submits ORDER PK Order ID Order Date ORDER LINE Ordered Quantity PRODUCED IN WORK CENTER PK Work Center ID Work Center Location WORKS IN

Answer rating: 100% (QA)

A A customer can have zero or many orders B A product can appear on zero ... View the full answer