Module Title: | Advanced Database Systems |
Language of Instruction: | English |
Teaching & Learning Strategies: |
The course is taught by means of lectures and supervised practicals. The practical work consists of laboratory assignments. All assignments will focus on modern DBMSs. The laboratory exercise topics (installation, configuration, maintenance, applications, etc) are designed to explore the features of each package in depth and to compare packages. |
Module Aim: |
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 should be able to: |
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 |
Pre-requisite learning |
Module Recommendations
This is prior learning (or a practical skill) that is recommended before enrolment in this module.
|
No recommendations listed |
Incompatible Modules
These are modules which have learning outcomes that are too similar to the learning outcomes of this module. |
No incompatible modules listed |
Co-requisite Modules
|
No Co-requisite modules listed |
Requirements
This is prior learning (or a practical skill) that is mandatory before enrolment in this module is allowed. |
No requirements listed |
Module Content & Assessment
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
|
Assessment Breakdown | % |
Continuous Assessment | 60.00% |
Practical | 40.00% |
Continuous Assessment |
Assessment Type |
Assessment Description |
Outcome addressed |
% of total |
Assessment Date |
Other |
Class Tests; Theory Assignments (e.g. problem sheets, literature surveys, etc) |
1,2 |
30.00 |
Week 7 |
Other |
Class Tests; Theory Assignments (e.g. problem sheets, literature surveys, etc) |
2,3 |
30.00 |
Week 12 |
Practical |
Assessment Type |
Assessment Description |
Outcome addressed |
% of total |
Assessment Date |
Practical/Skills Evaluation |
Laboratory assignments |
2,3 |
40.00 |
Every Second Week |
No End of Module Formal Examination |
SETU Carlow Campus reserves the right to alter the nature and timings of assessment
Module Workload
Workload: Full Time |
Workload Type |
Frequency |
Average Weekly Learner Workload |
Lecture |
12 Weeks per Stage |
2.00 |
Laboratory |
12 Weeks per Stage |
2.00 |
Independent Learning Time |
15 Weeks per Stage |
5.13 |
Total Hours |
125.00 |
Module Delivered In
|