NEW
Font size
WorksheetsER Diagram (ERD)
Total questions: 10
Worksheet time: 5mins
ERD stands for _________.
enhance relation diagram
entity responsive diagram
entity relationship diagram
enable relationship diagram
A data model is a ______________.
The mathematical model of formulas and logic used in a system
The abstract creating of an ideal system transformation
The expanded, thoroughly balanced and normalized use case for a system
A formal way of representing the data that are used and created by a business system
On an ERD _________________:
Processes are listed alphabetically with relationship connections drawn between processes
Data elements are listed alphabetically with a cross listing to the processes that manipulate them
Data elements are grouped in a hierarchical structure that is uniquely identified by number
Data elements are listed together and place inside boxes called entities
An entity ____________.
Has cardinality (1:1, 1:N, or M:N)
Shows if it can be null or no null
Is a person, place or thing
Is described with a verb phrase
Which would NOT likely be an attribute of an entity called “Student”?
Age
Student identification number
Class room number
Home phone
Gender
Lines on an ERD diagram indicate____________.
Hierarchies between processes
Relationships among the data
Plurality of data items
Uniqueness of data items
Primary keys
Data manipulation includes ________.
remove all tables in SQL.
Add, delete, modify, and retrieve using SQL
perform quality check on SQL
HOUSE/POSTCODE
For the following two ENTITIES, which is the appropriate relationship:
STUDENT/SUBJECT
One to One
One to Many
Many to Many
