click below
click below
Normal Size Small Size show me how
Module 12 Example
These Flash cards include the definitions of key terms of Database Design
| Term | purpose and the best pracitce |
|---|---|
| Normalization | produces good tables from poor ones |
| First step of the design process | Producing the ERD |
| Second step of the design process | Normalize the tables |
| ERD | provides the macro view of an organizations data requirements and operations |
| Primary Key assignments | Using integers as PK instead of characters or strings |
| Naming Conventions | Associate attributes with entitles using entity prefixes |
| Denormalization | The process of introducing redundancy in tables to improve performance |