Question: 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

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.

PLEASE READ THE TABLE AND ANSWER A-B-C-D

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.

\begin{tabular}{|l|l|} \hline \multicolumn{1}{|l|}{ SALESPERSON } \\ \hline PK & Salesperson ID \\ \hline & Salesperson Name Salesperson Telephone Salesperson Fax \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related General Management Questions!