The following learning strategies will occupy your time:
Students will have received award induction material which will facilitate their learning how to use the Virtual Learning Environment (VLE) employed for the study of this module. The study time is divided into independent study and contact time.
Independent study will involve the following types of learning. It is difficult to be prescriptive about how much time a student should spend on each activity but some guidance will be given through the VLE.
Working 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 and to gain formative feedback. It will also include problem-based learning scenarios/case studies to encourage independent research.
Discussion Forums: Students are 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.
Hands-on practical learning: Students are encouraged to seek re-enforcement of academic learning through practical experience. To this end, a module workbook is available on the VLE which includes a series of practical exercises to be carried out. This will include the investigation of how aspects of the taught material can be applied.
Stated contact time will be used for e-support of the learning and formative reviews of the material with the module tutor. Reviews may be conducted either in person or virtually using conferencing software. There will be three reviews each lasting 20 minutes.

Connolly T, Begg C, Database Systems, 4th Edition, Addison Wesley, 2005, ISBN: 0201342871

Prior study of CE00856-2 Database systems or equivalent.

Material on VLE including
The Module Handbook
The Module Workbook containing the case studies and worksheets to guide hands-on learning activities

Access to the world-wide web
Word Processing and presentation graphics software for use in coursework production
Access to necessary communications hardware/software eg. skype
ORACLE relational database management system, students will require access to the SQL*PLUS and Developer 2000 products.
-sql server, MySQL

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 this module.. 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.

Exam Learning outcomes: (1,2,4).
Coursework assignment including an implementation and supporting documentation, Learning outcomes: (2,3)
Following the assessments, students are required to participate in a viva either in person or using Skype video (or other approved system).

Critically assess the main DBMS systems in commercial use (sql-server, oracle, MySql, DB2)
Database administration and the position of the database administrator
Data Dictionaries and their role in operational systems
Client/Server systems and distributed database technologies
Web and mobile database interfaces
XML and related technologies
Server side programming
Advanced Sql
Security and validation techniques, including site security, backups, data recovery, system recovery, Concurrency control
Performance issues, Database tuning and query optimisation techniques and facilities, clustering, indexing diagnostic tools
Decision support systems ?olap, data-warehousing, data mining