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;
3 Cards in this Set
- Front
- Back
Steps 3-8 of Database Design
|
3) Translate logical data model for target DBMS
4) Design file organizations and indexes 5) Design user views 6) Design security mechanisms 7) Consider the introduction of controlled redundancy 8) Monitor and tune operational system |
|
3 Substeps of step 3 of database design (Translate logical data model for target DBMS)
|
1) Design base relations
2) Design representation of derived data 3) Design general constraints |
|
4 substeps of step 4 of database design (Design file organizations and indexes)
|
1) Analyze transactions
2) Choose file organizations 3) Choose indexes 4) Estimate disk space requirements |