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.
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
This question was answered on: Sep 13, 2020Buy this answer for only: $15
This attachment is locked
Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
About this QuestionSTATUS
Sep 13, 2020EXPERT
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).
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.