Font size
WorksheetsWeek6-ERD-2
Total questions: 13
Worksheet time: 7mins
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.
Which of the following attributes can use to form composite attributes? [select all that apply]
Name
Address
Total
Age
The Primary key must be
Not Null
Unique
either a or b
both a and b
An entity that inherits its primary key from more than one other entity
Parent entity
⦁ Entity occurrence
Child entity
Associative entity
