Appendix 4a - CDG
MODULE DESCRIPTOR
MODULE Advanced Database Management Systems
TITLE
MODULE COxxx1 (L6) CREDIT 20 credits
CODE (NCC689) VALUE
DATE OF 03/09/2012 VERSION 1.1
APPROVAL NUMBER
SCHOOL CEPS PARTNER NCC Education Ltd
INSTITUTION
RELATIONSHIP WITH OTHER MODULES
Co-requisites NONE Pre- NONE Excluded NONE
requisites Combinations
MODULE AIMS
This module aims to build upon the student's general understanding of database systems, ensuring
that the student develops significant knowledge of the major topics (both theoretical and practical)
pertinent to the development and management of modern database systems. The module also
introduces current perspectives in database management systems, thereby increasing the students’
understanding of future trends and the latest developments in the field.
MODULE CONTENT
Relational Algebra and Relational Calculus
- Unary Operations
- Set Operations
- Join Operations
- Division Operation
- Aggregation and Grouping Operations
- Tuple Relational Calculus
- Domain Relational Calculus
Advanced Data Modelling and Normalisation
- Superclasses and Subclasses
- Specialisation Process
- Generalisation Process
- Multi-Valued Dependency (4NF)
- Lossless-Join Dependency (5NF)
Database Security
- Threats
- Countermeasures
- Computer-Based Controls
Transaction Management
- Transaction Support
- Concurrency Control
- Database Recovery
Advanced SQL and Query Optimisation
- Views
- Sub-Selects
- Discretionary Access Control
Distributed Databases
- Functions, Architectures and Design
- Transparencies
- Transaction Management
- Deadlock Management
- Recovery
Perspectives of Database Management Systems
- Object Database Management Systems
C:\Users\matthew.baldwin\Dropbox\UCLan documentation\3) Module Descriptors\NEWMODDESC_ADMS.DOC
Appendix 4a - CDG
- Web Technology and database Management systems
- Data Warehousing and data Mining
LEARNING OUTCOMES
On successful completion of this module a student will be able to:
1. Compare and contrast various perspectives of database management systems.
2. Design and implement a database system for a given business scenario using advanced data
modelling techniques.
3. Demonstrate a practical understanding of relational calculus and relational algebra.
4. Discuss and evaluate the issues related to the concurrency, security and query optimization of
database management systems.
5. Demonstrate a practical understanding of advanced SQL.
6. Demonstrate a practical understanding of the Fourth and Fifth normal forms.
ASSESSMENT METHODS
Number of Form of % Size of Category of Learning
Assessments Assessment weighting Assessment/Duration/ assessment Outcomes
Wordcount (indicative (1 of written being
only) exam/practical assessed
assessment/coursework
–see guidance notes)
1 Examination 60% 2 hours Written exam 1,3,4,5
1 Coursework 40% 2000 words (+/- 200 Coursework 2,5,6
Assignment words)
MODULE PASS REQUIREMENTS
To pass the module, the student must achieve an overall weighted average of at least 40%.
C:\Users\matthew.baldwin\Dropbox\UCLan documentation\3) Module Descriptors\NEWMODDESC_ADMS.DOC
Appendix 4a - CDG
APPENDIX
MODULE CODE: MODULE TITLE: ADVANCED DATABASE
MANAGEMENT SYSTEMS
LOCATION OF STUDY: NCC EDUCATION
MODULE Gary Budgen (Contracted by NCC Education)
TUTOR(S)
MODULE Semester Long Semester 1 Semester 2 Semester 3
DELIVERY Year long Semester 1 & 2 Semester 2 & 3
Other (please indicate pattern WILL RUN IN MARCH SEMESTER (SEMESTER 1
of delivery) FOR MARCH STARTERS, SEMESTER 2 FOR
SEPTEMBER STARTERS)
MODULE LEARNING PLAN
LEARNING, TEACHING AND ASSESSMENT STRATEGY
The video lectures will be used to introduce general concepts and theory and link theory to practice.
The online tutorials will be used to develop those concepts through the use of case studies and by
analysing existing websites. Discussion forums will be used for students and the lecturer to explore
links between theory and practice. Online chat sessions will be used to discuss issues that arise.
No of
Direct Contact Hours hours
Watching Video Lectures (one hour per week over a 12 week teaching semester) 12
Participating in text-based live chat sessions (one hour per week over a 12 week teaching 12
semester)
Participating in discussion forums (one hour per week over a 12 week teaching semester) 12
Email/Skype/Telephone support (one hour per week over a 12 week teaching semester) 12
Total Contact Hours 48
Independent Learning Hours
Library work for weekly on-line tutorials 24
Directed reading for weekly on-line tutorials 36
Reflection on discussion forums, chat sessions and other feedback 36
Preparation for assessments 56
Total Independent Learning hours 152
Total Student Learning Hours 200
C:\Users\matthew.baldwin\Dropbox\UCLan documentation\3) Module Descriptors\NEWMODDESC_ADMS.DOC
Appendix 4a - CDG
BIBLIOGRAPHY AND LEARNING SUPPORT MATERIAL
Connolly and Begg (2004), Database Systems: A Practical Approach to Design, Implementation and
Management (International Computer Science Series) 4th edition, Addison Wesley, ISBN- 13: 978-
0321210258
rd
Ramakrishnan and Gehrke (2002), Database Management Systems 3 edition, McGraw-Hill Higher
Education, ISBN- 13: 978-0071230575
C:\Users\matthew.baldwin\Dropbox\UCLan documentation\3) Module Descriptors\NEWMODDESC_ADMS.DOC
