Module Database Search
| MODULE DESCRIPTOR | |||
|---|---|---|---|
| Module Title | |||
| Data Management | |||
| Reference | CMM022 | Version | 7 |
| Created | June 2022 | SCQF Level | SCQF 11 |
| Approved | January 2013 | SCQF Points | 15 |
| Amended | July 2022 | ECTS Points | 7.5 |
| Aims of Module | |||
|---|---|---|---|
| To introduce the key concepts and practical skills in database design and implementation. To explore the main features of a DBMS and key data management concepts and standards. | |||
| Learning Outcomes for Module | |
|---|---|
| On completion of this module, students are expected to be able to: | |
| 1 | Explain the main features of a DBMS and the principles used in database design, including security management. |
| 2 | Explain and apply relational database concepts. |
| 3 | Compare and contrast the main types of modern database. |
| 4 | Design, implement and critically evaluate a database. |
| Indicative Module Content |
|---|
| The relational database model: tables, relationships, keys, constraints and joins. Database design: E-R modelling and logical modelling. Structured Query Language (SQL): table creation, queries, sub-queries, triggers, functions and procedures. Physical database design: designing indexes, user views and security mechanisms. Data management standards in industry: data management challenges for industry; big data and data streams; tools, standards and techniques for the management, storage, querying and transfer of data. Database types: relational, object, noSQL, databases for the internet. |
| Module Delivery |
|---|
| Key concepts are introduced and illustrated through lectures and directed reading. The understanding of students is tested and further enhanced through interactive labs. In particular students will progress through a sequence of exercises to develop sufficient knowledge 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 | 30 | 30 |
| Non-Contact Hours | 120 | 120 |
| Placement/Work-Based Learning Experience [Notional] Hours | N/A | N/A |
| TOTAL | 150 | 150 |
| 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: | Practical Exam | Weighting: | 100% | Outcomes Assessed: | 1, 2, 3, 4 |
| Description: | Practical assessment 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 | CONNOLLY,T and BEGG,C., 2015. Database Systems: A Practical Approach to Design, Implementation and Management. Pearsons. |
| 2 | ELMASRI, R and NAVATHE, S.,2015. Fundamentals of Database Systems. 7th Ed. Addison Wesley |
| 3 | GORDON, K., 2013. Principles of Data Management: Facilitating Information Sharing. 2nd ed. British Computer Society. |
| 4 | VAISH, G.,2013 Getting started with NoSQL. Packt Publishing LTD, ISBN:978-1-84969-4-988 |
| 5 | HARRISON, G., 2015. Next Generation Databases: NoSQL, NewSQL, and Big Data. Apress. |