Font size
WorksheetsERD (Entity Relationship Diagram)
Total questions: 19
Worksheet time: 28mins
An entity relationship diagram (ERD)_________.
Is a use-case diagram enhanced graphically to show data and process modeling
Is a high-level CASE diagram of data modeling used in business systems
Is an illustration of external data flows to and from a business systems
Is a picture that shows the information that is created, stored, and used by a business system
Is a graphical display of the processes in a business system
Which would NOT likely be an attribute of an entity called “Student”?
Age
Student ID
Classroom number
Home address
Gender
Lines on an ERD diagram indicate____________.
Hierarchies between processes
Relationships among the data
Plurality of data items
Uniqueness of data items
Primary keys
SIM CARD / PHONE NUMBER
For the following two ENTITIES, which is the appropriate relationship:
RECIPE/ INGREDIENT
One to One
One to Many
Many to Many
COUNTRY / CAPITAL CITY
For the following two ENTITIES, which is the appropriate relationship:
STUDENT/SUBJECT
One to One
One to Many
Many to Many
Each entity is described by __________.
entities
relationships
none of these
attributes
This key uniquely identifies each record in an entity.
Primary Key or Key Identifier
Foreign Key
Secondary Key
Composite Key
What is the relationship between Lawyer and Client?
One to Many
Many to Many
Many to One
One to One
This key uniquely identifies each record in an entity.
Primary Key
Foreign Key
Secondary Key
Composite Key
In online shopping like Lazada, the entities which is the CUSTOMER and the PRODUCT is a good example of what cardinality
One to One
One to Many
Many to One
Many to Many
What is the best cadinality based on the table product1 and product2?
One to One
One to Many
Many to One
Many to Many
What is the best cadinality based on the table for CUSTOMER and PRODUCT?
One to One
One to Many
Many to One
Many to Many
Cardinality specifies how many instances of an entity relate to one instance of another entity. Match the following examples with their meaning.
Zero or Many
Zero or One
Many
One or More
One and Only One
Look at the entity relationship diagram below. What attributes are primary and foreign keys?
1
2
5
3
4
Select all the part of an ERD
Entity
Relationship
Attribute
Business Rule
The relationship between Student and Course is (a) .
The relationship between Student and Student_Course is (a) .
