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