Font size
WorksheetsERDs and DFDs
Total questions: 15
Worksheet time: 8mins
What is the main purpose of and ERD?
To represent flow of data
To model and design relational databases
To represent the structure of a website
To represent flow of electricity
What is a link entity in an ERD?
An entity that represents a website
An entity that represents a system
An entity to resolve many-to-many relationships
An entity to resolve 1-to-many relationships
What is the main purpose of a data flow diagram?
To represent the flow of data in a system
To model and design relational databases
To show the flow of electricity
To show the structure of a website
An ERD is used in primarily which field? (Choose all that apply)
Software engineering
Database deisgn
Business modelling
Circuit design
A DFD is primarily used in which field?
Software engineering
Database design
Business modelling
All of the above
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
ZOO / ANIMAL
field in a file.
record in a file.
record in a file.
field in a file.
table that is foreign key in
another table.
table that is record key in
another table.
table that is primary key in
another table.
table that is column key in
another table.
In the data flow diagram (DFD), arrows represent which way the data goes (in or out); these are called...
External entitles
Processes
Data stores
Data flows
This is the symbol for
External entitles
Processes
Data stores
Data flows
This is the symbol for
External entitles
Processes
Data stores
Data flows
This is the symbol for
External entitles
Processes
Data stores
Data flows
In a data flow diagram, which symbol is a place where data is stored temporarily or permanently?
A process
A data flow
A data store
An external entity
