Module Database Search
| MODULE DESCRIPTOR | |||
|---|---|---|---|
| Module Title | |||
| Database Systems | |||
| Reference | CM1603 | Version | 2 |
| Created | February 2024 | SCQF Level | SCQF 7 |
| Approved | July 2020 | SCQF Points | 15 |
| Amended | April 2024 | ECTS Points | 7.5 |
| Aims of Module | |||
|---|---|---|---|
| To provide the fundamental principles, theory and methods underpinning relational database management system (RDBMS) technologies. | |||
| Learning Outcomes for Module | |
|---|---|
| On completion of this module, students are expected to be able to: | |
| 1 | Describe underlying theory and principles of relational database management system (RDBMS). |
| 2 | Apply database design and modelling methods for a given business case study. |
| 3 | Employ SQL as a data definition and data manipulation language and to query a relational database. |
| 4 | Implement a relational database using a query language with a suitable interface. |
| Indicative Module Content |
|---|
| Introduction to RDBMS (traditional file systems vs RDBMS, characteristics of RDBMS, evolution and future of database systems). The relational model: entities, relations, attributes, multiplicities and key constraints. Conceptual and logical modelling using normalisation techniques with different types of integrity constraints. SQL: data definition, data manipulation and data control language. New trends in data storage. |
| Module Delivery |
|---|
| Key concepts are introduced and illustrated through lectures using case studies. The understanding of the student is tested, evaluated and further enhanced through a series of interactive exercises. In the laboratories, students will gain progressive hands-on experience of a relational DBMS environment to enable them to complete the practical implementation of a relational database application. |
| Indicative Student Workload | Full Time | Part Time |
|---|---|---|
| Contact Hours | 48 | N/A |
| Non-Contact Hours | 102 | 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: | Coursework | Weighting: | 100% | Outcomes Assessed: | 1, 2, 3, 4 |
| Description: | Individual coursework covering all learning outcomes. | ||||
| MODULE PERFORMANCE DESCRIPTOR | |
|---|---|
| Explanatory Text | |
| The calculation of the overall grade for this module is based on 100% weighting of C1. An overall minimum grade of D is required to pass this module. | |
| Module Grade | Minimum Requirements to achieve Module Grade: |
| A | The student needs to achieve an A in C1. |
| B | The student needs to achieve a B in C1. |
| C | The student needs to achieve a C in C1. |
| D | The student needs to achieve a D in C1. |
| E | The student needs to achieve an E in C1. |
| F | The student needs to achieve an F in C1. |
| NS | Non-submission of work by published deadline or non-attendance for examination |
| Module Requirements | |
|---|---|
| Prerequisites for Module | None. |
| 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 ed. Addison-Wesley. |
| 2 | Elmasri, R. and Navathe, S. 2015. Fundamentals of Database Systems. 7th ed. Addison-Wesley. |
| 3 | Feuerstein, S. 2014. Oracle PL/SQL Programming. O'Reilly. |
| 4 | Kleppmann, M., 2017. Database Principles and Design. Cengage Learning Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems. |
| 5 | Meier, A. and Kaufmann, M., 2019. SQL and NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management. |