Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
15 Cards in this Set
- Front
- Back
A data model is a:
|
A formal way of representing the data that are used and created by a business system
|
|
ERD is an acronym for:
|
Entity Relationship Diagramming
|
|
An entity relationship diagram (ERD):
|
Is a picture that shows the information that is created, stored and used by a business system
|
|
Information in the data dictionary is called: _______________
|
Metadata
|
|
When normalizing data models, if you take attributes that have multiple values for a single instance of an entity and create separate entities for those attributes you are moving from:
|
O normal form to 1st normal form (1NF)
|
|
During the analysis phase, analysts create programming models to represent how the business system will operate.
|
True
|
|
ERD's are drawn in several levels: Context ERD diagrams; Level 0 ERD diarams; Level 1 ERD diagrams.
|
False
|
|
Relationships are associations between entities.
|
True
|
|
ERD's can be quite complex and might have hundreds or thousands of entities.
|
True
|
|
Normalizing data models is a five step process: not-normalized; create first normal form (1NF); create second normal form (2NF); create third normal form (3NF); create fourth normal form (4NF) and finally create the fully normalized form (5NF).
|
False
|
|
What are the three primary components of an ERD diagram?
|
Entity, attributes, and relationships
|
|
In creating ERD's, which would most likely NOT be a source for entities?
|
Cost / Benefit Reports
|
|
Relationships are best documented as a verb in an ERD
|
True
|
|
Entities are best documented as a noun in an ERD
|
True
|
|
You should create an ERD without consulting the DFD's
|
False
|