Relational database concepts: entities, keys, relationships, data types, anomalies, ACID and ODBC

What this note covers

1. Entities, attributes and relationships
2. Tables, fields, records and data types
3. Primary, foreign and composite keys
4. Insert, update and delete anomalies
5. ACID transactions
6. How databases interact with other systems: ODBC
7. Exam technique for core database concepts

7 sections · 12 key terms & formulas · 6 common mistakes