The student will gain comprehensive knowledge of databases and database systems, to enable him/her to design and implement semi-complex databases and applications.
Overview of database systems
- Application areas, models and concepts
- Hierarchical databases
- Network database systems
- Relational database systems
- Object oriented systems
Relational database systems
- Relational model / theory
- Data structures / Tables
- The SQL-language
- Integrity / Consistency
- Relational algebra
- Retrieval and simultaneity
RDBM systems
- installation, configuration, administration, security
- n-tier / transactions / recovery
- tools / software for server and application development
- web access / web front
Lectures, practical lab sessions and project work.
Accepted project - completed progress reports
Familiarity with current software products : Microsoft SQL Server, E-R tools, MS Access, Visual Basic, MS InterDev.
Project – individual or in groups of two. Graded.
