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