Module Descriptors
DATABASE SECURITY
COIS50756
Key Facts
School of Digital, Technologies and Arts
Level 5
15 credits
Contact
Leader: Clare Stanier
Email: C.Stanier@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 36
Independent Study Hours: 114
Total Learning Hours: 150
Assessment
- COURSEWORK weighted at 100%
Module Details
Module Learning Strategies
2 lectures per week plus 1 practical per week (1: n)2; (1:20)1.
Students will have participated in an award induction workshop where they will learn how to use the Virtual Learning Environment (VLE) employed for the study of this module. Subsequently students will work through the module material provided on the VLE at a pace suggested within the VLE for the module. The material will include activities and review questions that allow students to assimilate the concepts and skills required by the module. Students will be encouraged to discuss relevant aspects within discussion forums that are part of the VLE. The forums will allow discussion with a student's peer group as well as the module tutor.
Students will have participated in an award induction workshop where they will learn how to use the Virtual Learning Environment (VLE) employed for the study of this module. Subsequently students will work through the module material provided on the VLE at a pace suggested within the VLE for the module. The material will include activities and review questions that allow students to assimilate the concepts and skills required by the module. Students will be encouraged to discuss relevant aspects within discussion forums that are part of the VLE. The forums will allow discussion with a student's peer group as well as the module tutor.
Module Indicative Content
Strategic role of database management, enterprise issues and users. Current issues and future developments. High level security issues.
Distributed Databases
Centralisation versus decentralisation. Client/Server versus distributed database applications. Locking and transaction control (parallelism and serialisability).
Database administration and database management in a complex environment.
Logical and physical structure of databases. Database optimisation and database partioning. Recovery and archiving.
Physical and logical security including roles and privileges.
Data tracking including row history. Security technologies including transparent encryption.
Overview of forensic issues concerned with database security i.e. use of flashback, SQL Injection prevention etc.
Distributed Databases
Centralisation versus decentralisation. Client/Server versus distributed database applications. Locking and transaction control (parallelism and serialisability).
Database administration and database management in a complex environment.
Logical and physical structure of databases. Database optimisation and database partioning. Recovery and archiving.
Physical and logical security including roles and privileges.
Data tracking including row history. Security technologies including transparent encryption.
Overview of forensic issues concerned with database security i.e. use of flashback, SQL Injection prevention etc.
Module Additional Assessment Details
A coursework weighted at 100% made up of :
1) seminar presentation and paper (1000 words), duration up to 15 minutes, weighted at 30%, assessing learning outcome 2
2) Practical assignment weighted at 70% assessing learning outcomes 1 & 3.
The assignment will require students to demonstrate practical skills in database security and management and to demonstrate that these skills can be applied in a complex environment.
1) seminar presentation and paper (1000 words), duration up to 15 minutes, weighted at 30%, assessing learning outcome 2
2) Practical assignment weighted at 70% assessing learning outcomes 1 & 3.
The assignment will require students to demonstrate practical skills in database security and management and to demonstrate that these skills can be applied in a complex environment.
Module Texts
Connolly, T.M., Begg, C.E. (2005) Database Systems: A Practical Approach to Design, Implementation and Management, 4th Edition, Addison Wesley ISBN: 0321210255
Module Resources
Material on Blackboard
Oracle
Staffordshire University has subscriptions to electronic book services such as Safari Tech Books, Ebrary and Netlibrary. There are titles in each of the collections that will support students studying Database Technology. Staffordshire University has subscriptions to IEEExplore, ACM Digital Library, Elsevier Science Direct and Infotrac Computer Database all offering full text electronic access to journals and conference proceedings.
Standalone versions of Oracle 10g or higher and Oracle Enterprise Manager. Students will need to create and destroy databases and this cannot be done on the university network for security reasons.
Oracle
Staffordshire University has subscriptions to electronic book services such as Safari Tech Books, Ebrary and Netlibrary. There are titles in each of the collections that will support students studying Database Technology. Staffordshire University has subscriptions to IEEExplore, ACM Digital Library, Elsevier Science Direct and Infotrac Computer Database all offering full text electronic access to journals and conference proceedings.
Standalone versions of Oracle 10g or higher and Oracle Enterprise Manager. Students will need to create and destroy databases and this cannot be done on the university network for security reasons.
Module Special Admissions Requirements
Study of CE00856-2 Database Systems or equivalent where SQL skills can be shown to be comparable with Database Systems.