Database Design

Database design is the organisation of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model. Database design involves classifying data and identifying interrelationships. This theoretical representation of the data is called an ontology. The ontology is the theory behind the database's design.^[1]

A printable version of Database Design is available. (edit it)

• Preface
  • About the Book
  • About the Authors
  • Acknowledgements
• Before the Advent of Database Systems
• Fundamental Concepts
• Characteristics and Benefits of a Database
• Types of Data Models
• Data Modeling
• Classification of Database Management Systems
• The Relational Data Model
• The Entity Relationship Data Model
• Integrity Rules and Constraints
• ER Modeling
• Functional Dependencies
• Normalization
• Database Development Process
• Database Users
• SQL Structured Query Language
• SQL Data Manipulation Language
• Appendix
  • University Registration Data Model Example
  • Sample ERD Exercises
  • SQL Lab with Solution
  • Orders and Data