Relational Model: Summary
A tabular representation of data.
Simple and intuitive, currently the most widely used.
Integrity constraints can be specified by the DBA, based on application semantics. DBMS checks for violations.
- Two important ICs: primary and foreign keys
- In addition, we always have domain constraints.
Guidelines to translate ER to relational model
Powerful and natural query languages exist.