Course outline:

The course focuses on database security topics such as Basic concepts;

Database security issues; Discretionary and mandatory access controls; Secure

database design; Data integrity; Secure architectures; Secure transaction

processing; Information flow controls; Inference controls, and auditing; Security

models for relational and object-oriented databases; Security of databases in

distributed environment; Statistical database security; Database encryption; and

survey of commercial systems and research prototypes.

Learning outcomes:

At the end of this course, students should be able to:

Knowledge:

- Define basic concepts commonly used in the area of database security.

- Illustrate the concepts via realistic case studies.

- Identify current developments in database security.

- Understand security issues and countermeasures in database systems.

- Identify problems relevant to database security system design and implementation.

- Demonstrate the knowledge by designing and implementing a simple database security solution for a realistic case study.

Cognitive Skills:

- Apply the existing techniques and technologies to design a Database security system for a Database Management System (DBMS).

- Discuss the crucial importance of security in database systems

Subject Specific Skills:

- Design a solution to secure a database that reflects the organization's security policies

- Identify data integrity and security requirements

- Apply security techniques to implement the security needs for a database system

Transferable Skills:

- Working together to solve weekly group exercises, to assimilate the basic material learned in the lecture, to realize its factual application in the global environment.

- Develop an ability to identify and analyze security requirements of database systems.

- Implement security requirements in a relational database, showing a good understanding of

the material learned in lectures and seminar groups.