Background Info
Edgar F Codd
Relational Database Model: is a model to organized a collection of data using set theory and first-order predicate logic. This model was proposed in 1970 by Edgar F. Codd in his seminal publication "A Relational Model of Data for Large Shared Databanks."
Why is this important?
This model made improvements over the
prevailing models of the time (Hierarchical and Network models) by:
- Reducing data redundancy
- Improving data integrity
- Providing greater freedom on its physical implementation
Database Design
Logical Database Design (LDD): is the process used to organize a collection of data according to a given model. The aim of LDD is to enable users, and organizations to maintain, access, and update accurate information. The design process takes into consideration:
- What data is stored
- The physical, logical, and general elements of the data
- How the data will be stored
- The classification of data
- The grouping of data
- The establishment of relationships between collections of data
- The organizational practices that govern how users store, access, manipulate, and view data.
- The financial considerations of implementing a given LDD model.