Week6-ERD-2

This symbol indicates _____ relationship.

• one or many
• zero or many
• zero or one
• many to many

_________is a person, place, object, event or concept in the user environment about which company wishes to maintain the data

• attribute
• entity
• relationship
• none of these

Each entity is described by __________.

• entity

• relationship

• none of these

• attribute

This key uniquely identifies each record in an entity.

• Primary Key or Key Identifier

• Foreign Key

• Secondary Key

• Composite Key

For ERD this shape describe for ?

• Cardinality

• Relationship

• Attribute

• Entity

Based on the given ERD, select the appropriate business rules that reflect the relationship. [select all that apply]

• A lawyer can have many clients.

• Each client is served by one lawyer.

• Each court has only one judge.

• Each court may have many cases.

What is the relationship between Lawyer and Client?

• One to Many

• Many to Many

• Many to One

• One to One

Is it possible to have a composite primary key in Table Case?

• Yes

• No

List out the optional participation in the figure. [select all that apply]

• From COURT to CASE

• From CASE to COURT

• From JUDGE to COURT

• From COURT to JUDGE

Select the CORRECT relationship degree. [select all that apply]

• Unary relationship in table Lawyer

• Tertiary relationship among table Lawyer, Case, Client, and Court.

• Binary relationship between table Case and Client.

• Binary relationship between table Judge and Client.