PART 1 Flashcards
1
Q
Diagram that depicts the entities and relationship between entities in a given domain
A type of model most commonly used to create a visual image of a database
A
ERD
2
Q
Standardizes definitions and ensures consistent use
Standardizes the description of all the elements in the database
A
Data Dictionary
3
Q
What is Flat File Database?
A
Microsoft Excel
4
Q
What are disadvantages of Flat File Database?
A
- Multiple users can’t access simultaneously
- Hard to keep track of versions and flat files
- Flat files do not support large files of data
- Hard to pull data out of a flat file
5
Q
Nouns about what is used to store data
A
Entities
6
Q
Adjectives that describe the entities
Symbolized by an oval
A
Attributes
7
Q
What is the oval symbol?
A
Attribute
8
Q
What is the square symbol?
A
Entity
9
Q
What is the diamond symbol?
A
Relations
10
Q
How the birds and the entities are related
A
Relations
