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.

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
Get step-by-step solutions from verified subject matter experts
