Consider the two sets of business rules shown in the table below. SET OF BUSINESS RULES...

 

Transcribed Image Text:

Consider the two sets of business rules shown in the table below. SET OF BUSINESS RULES #1 Cardinality A CLIENT owns many ACCOUNTS. An ACCOUNT is owned by many CLIENTS. Participation Every CLIENT owns an ACCOUNT. Every ACCOUNT is owned by a CLIENT. SET OF BUSINESS RULES #2 Cardinality A CLIENT owns exactly one ACCOUNT. An ACCOUNT is owned by many CLIENTS. Participation Not every CLIENT owns an ACCOUNT. Not every ACCOUNT is owned by a CLIENT. a) Draw an E-R schema diagram that complies with the first set of business rules using Chen's notation. You must use proper E-R constructs including entity types and relationship types (you do not need to add attributes). b) Draw an E-R schema diagram that complies with the second set of business rules using Chen's notation. You must use proper E-R constructs including entity types and relationship types (you do not need to add attributes). Consider the two sets of business rules shown in the table below. SET OF BUSINESS RULES #1 Cardinality A CLIENT owns many ACCOUNTS. An ACCOUNT is owned by many CLIENTS. Participation Every CLIENT owns an ACCOUNT. Every ACCOUNT is owned by a CLIENT. SET OF BUSINESS RULES #2 Cardinality A CLIENT owns exactly one ACCOUNT. An ACCOUNT is owned by many CLIENTS. Participation Not every CLIENT owns an ACCOUNT. Not every ACCOUNT is owned by a CLIENT. a) Draw an E-R schema diagram that complies with the first set of business rules using Chen's notation. You must use proper E-R constructs including entity types and relationship types (you do not need to add attributes). b) Draw an E-R schema diagram that complies with the second set of business rules using Chen's notation. You must use proper E-R constructs including entity types and relationship types (you do not need to add attributes).

Answer rating: 100% (QA)

According to the instruction given Ill explain how to create an EntityRelationship ER schema diagram based on Chens notation for both sets of business ... View the full answer