- 1Introduction
- 2Database history
- 3Relational database characteristics
- 4Customer contact system
- 5Tables and the primary key
- 6Linking tables
- 7The one-to-many relationship
- 8The many-to-many relationship
- 9The one-to-one relationship
- 10Database normalization
- 11The first normal form (1NF)
- 12The second normal form (2NF)
- 13The third normal form (3NF)
- 14The final database design
- 15Another example: webshop database
- 16Conclusion
Database design tutorial
Relational database characteristics
Besides the fast retrieval of data, relational databases offer a number of other characteristics.
- The relational model allows for the linking of different data tables using 'keys'. Using the Structured Qeury Language (SQL) linked data from multiple tables can be selected at once.
- Efficient storage of data. In a database design that adheres to the rules of the relational model, each data item is stored only once, that is, in one location. Consequently, each data item (for example a username) can be changed, insterted or removed in only one location in the database.
-
Using a relational database you can specify what sort of data a database column is allowed to contain. You can set data fields, numeric fields, text fields, etc. This gives you some control over data integrity. For example, users won't be able to insert text into a 'date_of_birth' field that is set to contain a date.
- Data integrity. By setting field properties, by linking tables and by applying data integrity rules you can increase the reliability of your data.
- Most relational database systems offer a right structure with which rights can be assigned to different users. Some of the operations that can be allowed or disallowed to a user are SELECT, INSERT, DELETE, ALTER, CREATE, etc. These rights correspond to the operations that can be performed using the Structured Query Language (SQL).
-
In order to actually perform operations on the database, like storing new data, selecting present data and altering present data, SQL queries are used. The Structured Query Language is relatively easy to understand and it allows advanced database operation, such as the selection of linked data from multiple tables.
- The relational model is a standard. By adhering to the rules of the relational model you ensure that your data can be transfered to other relational database systems relatively easily.