Overview and aims
This unit develops knowledge and skills in the design, implementation and management of relational database systems. Learners move from basic database concepts to practical schema design, SQL and basic optimisation.
Aims:
- Provide understanding of database concepts and architectures.
- Enable learners to design relational schemas using data‑modelling techniques.
- Develop competence in SQL for data definition, manipulation and querying.
Indicative content
- Data, information, databases and DBMS types.
- Conceptual, logical and physical data modelling (ER diagrams, normalisation).
- SQL: DDL, DML, joins, subqueries, constraints.
- Basic security, backup and recovery considerations.
Outcomes
Learners will be able to:
- Explain database principles and architectures.
- Design relational schemas from business requirements.
- Implement and query databases using SQL to meet specified needs.
Assessment
- Assignment: design an ERD, implement the schema in a DBMS, populate data and provide a set of queries and reports with commentary.
