Database Systems
An Introduction to the Features of a Relational Database Product
- (e.g. ORACLE) including its data management and application development techniques (e.g. Forms generators and programming tools). Programming environments.
Database Management Systems
- Comparison of a data-centred approach with file-based approach.
- Data integrity and quality control. Transaction processing.
- Logical and physical data independence how it is achieved.
Data Analysis and Data Modeling
- Entity relationship diagrams and conceptual modelling.
- Relationship constraints and translation to relational model.
The Relational Model and Relational Languages
- Functional Dependency theory and Normalisation. Relational modelling.
- Simple relational algebra programs. Features of relational algebra in SQL.
SQL
- Standards and basic structure of SQL for data definition, views, updates, insertion and referential integrity constraints.
Distributed and Muiti-User Database Systems
- Concurrency, recovery and database integrity.
- Client-server model as a distributed database architecture.