Hamish Burke | 2025-03-12
Related to: #databases
Designing a database
Phases
1. Requirements specification and analysis
- A description of the data to be used or generated
- Any additional requirements for the database system
2. Conceptual design
- Often with graphical representation
- High level abstraction
- To show to client (to validate requirements)
3. Logical design (eg foreign/primary keys)
- Based on Relational Data Model
- Includes description of all keys, attributes etc
4. Physical design
- Implementing the logical data model in a DBMS