(solution) I need you to fix the cardinalities in this one also. I gave you

I need you to fix the cardinalities in this one also.  I gave you an example in the header of the document just to remind you. But i only need the cardinalities of minimum and maximum for the diagram attached as examhelpnew1

Same format as you did in this one. For this one. The fixed one would be the ones you just did that is perfect. The other document is the one where I need the diagram for the dogs. I need the cardinalities for this one to be just like the one you just fixed. 

ANSWER A.

 

Minimum Cardinalities in the diagram

 

?

 

?

 

?

 

?

 

?

 

?

 

?

 

? SERVICE is not required for SERVICE_TYPE

 

SERVICE must have a SERVICE_TYPE.

 

SERVICE must have an EMPLOYEE.

 

SERVICE is not required for EMPLOYEE.

 

CUSTOMER must have a SERVICE.

 

SERVICE must have a CUSTOMER.

 

CUST_ALIAS is not required CUSTOMER

 

CUST_ALIAS must have a CUSTOMER ANSWER B.

 

Referential Integrity Constraint of Recursive Relationship

 

Referred By column of Customer table has a referential integrity constraint with

 

CustomerID of the same table. It is the Foreign Key which is related to the Primary Key of

 

the same table. In other words, the constraint would restrict the value of Referred By

 

column to only those values which already exists in the table as CustomerID. ANSWER C.

 

Maximum Cardinalities in the diagram

 

?

 

?

 

?

 

?

 

?

 

?

 

?

 

? SERVICE_TYPE can be used by many SERVICE

 

SERVICE can have one SERVICE_TYPE

 

SERVICE can have one EMPLOYEE

 

EMPLOYEE can have many SERVICE

 

CUSTOMER can have many SERVICE

 

SERVICE can be of one CUSTOMER

 

CUSTOMER can have many CUST_ALIAS

 

CUST_ALIAS can have one CUSTOMER

 

---

Solution details:

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 13, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

• As a reference for in-depth understanding of the subject.
• As a source of ideas / reasoning for your own research (if properly referenced)
• For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).

This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.