Aims and Fit of Module

The module provides students with a comprehensive understanding of database systems. Student will be equipped with the abilities to design database systems based on real-world specifications or improve an existing database design by re-organising tables in a database. Student will also be trained to properly write and analyse SQL statements that query, insert, delete or modify data in existing database tables. Overall, the contents taught in this module will give students fundamental skills for organising and querying data, which are required in their future courses like data mining, artificial intelligence and software development project. In the process, students will also learn social implications of database systems and potential risks that may happen in a database environment and apply their knowledge to avoid harmful impacts from these risks.

Learning outcomes

A. Design and deploy database systems to meet business goals. 
B. Use a database management system (e.g., MySQL, Microsoft Access) to create, query, and manage data.
C. Write SQL queries to retrieve, filter, and organize data.
D. Explain and evaluate legal, social, ethical and professional implications of creating and maintaining information systems.
E. Identify and mitigate security risks or safety concerns that can arise in the operation of database systems.

Method of teaching and learning

Students will be expected to attend formal lectures as well as to participate in practicals in a computer lab. Lectures will introduce students to the academic content and practical skills which are the subject of the module, while computer practicals will allow students to practice those skills. Case studies are presented illustrating the effective use and design of databases.

In addition, students will be expected to devote seven hours of unsupervised time to complete homework and private study. Private study will provide time for reflection and consideration of lecture material and background reading. Homework is designed to give students further practices on the knowledge learned in the lectures. In the second half the the semester, homework provides important opportunities to let students reflect on the designs of database for a specific application scenario. Student will also need to discuss how a database design impact the final software system. This gives students valuable practical experience on designing database systems.

Two quizzes will take place in the middle of the semester to test to what extent practical skills have been learnt. Students will be given timely feedback on these quizzes.
A written examination at the end of the module will assess the academic achievement of students.