Module Descriptors
MANAGMENT OF DATABASE SYSTEMS
COIS60513
Key Facts
Faculty of Computing, Engineering and Sciences
Level 6
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
- EXAMINATION - UNSEEN IN EXAMINATION CONDITIONS weighted at 50%
- COURSEWORK weighted at 50%
Module Details
Module Resources
Students will be provided with a Module Handbook including the descriptor, schedule of delivery and additional reference material to support student-centred study
Additional case study material and practical workbooks will be provided when appropriate to the schedule
Lecture notes will be provided electronically prior to delivery and be available throughout the running of the course
Access to a PC with suitable word processing, diagramming and appropriate tools for use in the producing the coursework and supporting the practical workshops
Additional case study material and practical workbooks will be provided when appropriate to the schedule
Lecture notes will be provided electronically prior to delivery and be available throughout the running of the course
Access to a PC with suitable word processing, diagramming and appropriate tools for use in the producing the coursework and supporting the practical workshops
Module Learning Strategies
Delivery of the module is as follows:
1 x 1 hour lecture per week for the whole group
1 x 1 hour seminar style lecture to encourage discussion and development of issues
1 x 1 hour tutorial per week in groups of no more than 20 students
(1:n)1 (1:20)2
The following learning strategies will be applied:
- Keynote lectures introducing the main points for the topics covered by the core course material
- Student-centred workshops/tutorials to develop and underline the main topics introduced in the lectures
- Discursive sessions drawing on practical examples
Students will also be encouraged to develop their intellectual, communicative and problem solving skills.
1 x 1 hour lecture per week for the whole group
1 x 1 hour seminar style lecture to encourage discussion and development of issues
1 x 1 hour tutorial per week in groups of no more than 20 students
(1:n)1 (1:20)2
The following learning strategies will be applied:
- Keynote lectures introducing the main points for the topics covered by the core course material
- Student-centred workshops/tutorials to develop and underline the main topics introduced in the lectures
- Discursive sessions drawing on practical examples
Students will also be encouraged to develop their intellectual, communicative and problem solving skills.
Module Indicative Content
Database Administration
Organisation of database control. Database software selection and evaluation. Licensing and contractual agreements. Database Metadata and Schema Evolution. Storage and configuration issues.
Database Security
System security and layers of abstraction. Backup and recovery strategies. Handling concurrency, locking protocols. User management.
Database Tuning
Different aspects of database tuning and optimisation including query optimisation, design tuning and memory management. Database internals - controls and parameters.
Organisation of database control. Database software selection and evaluation. Licensing and contractual agreements. Database Metadata and Schema Evolution. Storage and configuration issues.
Database Security
System security and layers of abstraction. Backup and recovery strategies. Handling concurrency, locking protocols. User management.
Database Tuning
Different aspects of database tuning and optimisation including query optimisation, design tuning and memory management. Database internals - controls and parameters.
Module Additional Assessment Details
Examination 2 hours (50%) (Learning Outcomes 1, 2 and 4)
Coursework (50%) (Learning Outcome 3)
Individual essay (3000 words) researching current issues concerning the use of data within organisations, combined with a practical demonstration / prototype
Coursework (50%) (Learning Outcome 3)
Individual essay (3000 words) researching current issues concerning the use of data within organisations, combined with a practical demonstration / prototype
Module Texts
Database Systems: An Application Oriented Approach: Complete Version
Arthur J. Bernstein, Philip M. Lewis, Michael Kifer
Paperback (April 30, 2005)
Publisher: Addison Wesley
ISBN: 0321312562
Arthur J. Bernstein, Philip M. Lewis, Michael Kifer
Paperback (April 30, 2005)
Publisher: Addison Wesley
ISBN: 0321312562
Module Special Admissions Requirements
None