Database Design - I
The relational database model was conceived in 1969 by E.F.Codd.
The model is based on mathematical theory viz. a database consists of a series of unordered tables (or relations) that can be manipulated using non-procedural operations that return tables.
Benefits of a relational database:
- Data entry, updates and deletions are efficient.
- Data retrieval, summarization, and reporting are efficient
- Database behaves predictably.
- Changes to the database schema are easy to make.