Module Database Search
| MODULE DESCRIPTOR | |||
|---|---|---|---|
| Module Title | |||
| Database Systems | |||
| Reference | CM3017 | Version | 7 |
| Created | October 2017 | SCQF Level | SCQF 9 |
| Approved | April 2005 | SCQF Points | 15 |
| Amended | November 2017 | ECTS Points | 7.5 |
| Aims of Module | |||
|---|---|---|---|
| To provide the student with the ability to evaluate modern database architectures, and design and implement databases for large scale applications, taking into account transaction and security management issues in Database Management Systems. | |||
| Learning Outcomes for Module | |
|---|---|
| On completion of this module, students are expected to be able to: | |
| 1 | Describe and evaluate the architectures used in modern database systems. |
| 2 | Describe, analyse and apply transaction and security management issues in Database Management Systems. |
| 3 | Describe, analyse and apply database design requirements for advanced retrieval systems. |
| 4 | Describe and evaluate the physical database methodology for relational databases. |
| 5 | Implement and test a database application using relational DBMS. |
| Indicative Module Content |
|---|
| Database architectures: distributed and big-data architectures. DMBS issues: Transaction Management, Concurrency control, Recovery. Physical database implementations, use of DBMS techniques to create advanced retrieval systems with constraints, views, stored procedures, triggers and cursors.Application: information retrieval and recommender systems |
| Module Delivery |
|---|
| Key concepts are introduced and illustrated through lectures and directed reading. The understanding of students is tested and further enhanced through interactive tutorials. In the laboratories the student will progress through a sequence of exercises to develop sufficient knowledge of a relational DBMS to enable them to implement a relational DB application. |
| Indicative Student Workload | Full Time | Part Time |
|---|---|---|
| Contact Hours | 58 | N/A |
| Non-Contact Hours | 92 | N/A |
| Placement/Work-Based Learning Experience [Notional] Hours | N/A | N/A |
| TOTAL | 150 | N/A |
| Actual Placement hours for professional, statutory or regulatory body |
| ASSESSMENT PLAN | |||||
|---|---|---|---|---|---|
| If a major/minor model is used and box is ticked, % weightings below are indicative only. | |||||
| Component 1 | |||||
| Type: | Examination | Weighting: | 70% | Outcomes Assessed: | 5 |
| Description: | A closed book examination. | ||||
| Component 2 | |||||
| Type: | Coursework | Weighting: | 30% | Outcomes Assessed: | 1, 2, 3, 4 |
| Description: | A piece of coursework. | ||||
| MODULE PERFORMANCE DESCRIPTOR | ||||||||
|---|---|---|---|---|---|---|---|---|
| Explanatory Text | ||||||||
| The calculation of the overall grade for this module is based on 70% weighting of C1 and 30% weighting of C2. An overall minimum grade D is required to pass the module. | ||||||||
| Coursework: | ||||||||
| Examination: | A | B | C | D | E | F | NS | |
| A | A | A | B | B | C | E | ||
| B | B | B | B | C | D | E | ||
| C | B | C | C | C | D | E | ||
| D | C | C | D | D | D | E | ||
| E | D | D | D | E | E | E | ||
| F | E | E | E | E | F | F | ||
| NS | Non-submission of work by published deadline or non-attendance for examination | |||||||
| Module Requirements | |
|---|---|
| Prerequisites for Module | CM2020 Introduction to Database Systems or CMM003 Relational Database Systems |
| Corequisites for module | None. |
| Precluded Modules | None. |
| INDICATIVE BIBLIOGRAPHY | |
|---|---|
| 1 | CONNOLY, T. and BEGG, C. 2014 Database Systems - A Practical Approach to Design, Implementation and Management. 6th edition. Addison Wesley. |
| 2 | ELMASRI, R. and NAVATHE, S., 2015. Fundamentals of Database Systems. 7th Ed. Addison Wesley. |
| 3 | Introduction to Information Retrieval (online book) by Christopher D Manning, Prabhakar Raghavan and Hinrich Schutze. Cambridge University Press. 2008. |
| 4 | MISHRA,S.2004. Mastering Oracle SQL. O'Reilly. |
| 5 | McDonald, C., Beck, C., Kallman, J., Knox, D., 2004. Mastering Oracle PL/SQL : Practical Solutions. OakPress |