Database design and concepts

Full notes coming soon — here's what the syllabus covers for now:

• Explain and motivate relational database design
• Relational database overview
• Normalisation (overview and purpose) to reduce data redundancy and limit data anomalies
• Where does un-normalised data come from? ◊ Analyse general documents, e.g. a till slip to identify possible data entities
• Design/entities, keys, record organisation
• What is transaction processing system with regard to various database transactions?
• Reinforce the characteristics of a good database in terms of the design
• Data integrity, data independence, data redundancy, data security, data maintenance