Module Details

Module Code: SYST
Module Title: Advanced Database Systems
Title: Advanced Database Systems
Module Level:: 8
Credits:: 5
Module Coordinator: Nigel Whyte
Module Author:: Hisain Elshaafi
Domains:  
Module Description: To advance the student’s theoretical and practical knowledge of the design, operation and administration of modern database systems.
 
Learning Outcomes
On successful completion of this module the learner will be able to:
# Learning Outcome Description
LO1 Evaluate the role and trends of data management within contemporary organizations
LO2 Design, optimize and maintain modern database systems
LO3 Evaluate functions and tools available in modern DBMS software and analyse competing packages
Dependencies
Module Recommendations

This is prior learning (or a practical skill) that is recommended before enrolment in this module.
No recommendations listed
Co-requisite Modules
No Co-requisite modules listed
Additional Requisite Information
No Co Requisites listed
 
Indicative Content
1. Database Concepts
DBMS functions and characteristics, schema, schema objects, data catalog, modelling, classifications, recent developments
2. Oracle, SQL Server, MySQL
Architecture, physical structure, logical structure, interfaces, tools, object oriented features
3. Database Maintenance
Backup and recovery, importing and exporting, log files, security and authorization, database integrity
4. Database Performance
Normalization, indexing, query optimizer, contention, database design, optimizing, monitoring and tuning
5. Database Applications
SQL, ODBC, XML, stored procedures, database connections, database app security
Module Content & Assessment
Assessment Breakdown%
Continuous Assessment60.00%
Practical40.00%

Assessments

Full Time

Continuous Assessment
Assessment Type Other % of Total Mark 30
Timing Week 7 Learning Outcomes 1,2
Non-marked No
Assessment Description
Class Tests; Theory Assignments (e.g. problem sheets, literature surveys, etc)
Assessment Type Other % of Total Mark 30
Timing Week 12 Learning Outcomes 2,3
Non-marked No
Assessment Description
Class Tests; Theory Assignments (e.g. problem sheets, literature surveys, etc)
No Project
Practical
Assessment Type Practical/Skills Evaluation % of Total Mark 40
Timing Every Second Week Learning Outcomes 2,3
Non-marked No
Assessment Description
Laboratory assignments
No End of Module Formal Examination
Reassessment Requirement
Coursework Only
This module is reassessed solely on the basis of re-submitted coursework. There is no repeat written examination.

SETU Carlow Campus reserves the right to alter the nature and timings of assessment

 

Module Workload

Workload: Full Time
Workload Type Workload Category Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Lecture Contact Lecture 12 Weeks per Stage 2.00 24
Laboratory Contact Laboratory 12 Weeks per Stage 2.00 24
Independent Learning Time Non Contact Estimated Learner Hours 15 Weeks per Stage 5.13 77
Total Weekly Contact Hours 4.00
 
Module Resources
Recommended Book Resources
  • Elmasri, Navathe. (2016), Fundamentals of Database System, 7th. Addison Wesley.
Supplementary Book Resources
  • Silberschatz et al. (2019), Database System Concepts, McGraw-Hill.
This module does not have any article/paper resources
This module does not have any other resources
Discussion Note: