To build a database repository to store key data of all HBCUs in the country. It is our hope that the data in the repository can be updated as needed and would enable users to access information easily and quickly. Build or write a system design to accomplish the objective.
Database Design - SDLC
Define Problem
1. Define Database design Objectives
2. Database designers collect the user database requirements by elicitation
Requirements Specifications
3. Database designers produce a conceptual data model, then expand it to a Logical data model, and then expand it to a physical data model.
Data Requirements
Conceptual Design
DBMS
INDEPENDENT Results - Conceptual Model
4. Database designers construct the logical design of the database with tables, defining relations and DB constraints.
Logical Design
Results - Logical Model
5. Database designers then refine and normalize the database to minimize data redundancy.
Physical Schema
DBMS DEPENDENT
Results - Physical Model
6. The physical implementation of the database is managed by the DBMS.