Database Management Systems - 2014
Topics in the course include:
- Introduction to databases
- Conceptual modelling
- Extended ER modelling
- Normalisation
- Logical database design
- Physical design
- Data definition language to create and edit tables
- Data manipulation language
- Advanced SQL
- Client/server and distributed databases
Assignments include:
- Model a relational database
- Create a working Microsoft Access database application with data and queries from a given scenario
- A report on design and implementation issues
- SQL scripts to create a working database with security consideration planned and implemented
- Maintain a journal throughout the course