Module Database Search
| MODULE DESCRIPTOR | |||
|---|---|---|---|
| Module Title | |||
| Databases | |||
| Reference | CMM501 | Version | 5 |
| Created | September 2017 | SCQF Level | SCQF 11 |
| Approved | April 2005 | SCQF Points | 15 |
| Amended | October 2017 | ECTS Points | 7.5 |
| Aims of Module | |||
|---|---|---|---|
| To provide the student with the ability to evaluate and apply the methodologies and techniques used in the development and administration of modern databases. | |||
| Learning Outcomes for Module | |
|---|---|
| On completion of this module, students are expected to be able to: | |
| 1 | Identify, explain and apply the main principles and techniques for, the development of object and relational databases. |
| 2 | Explain, analyse and apply techniques for database administration. |
| 3 | Explain, analyse and apply techniques for database tuning and optimisation. |
| 4 | Describe, analyse and apply the methods used in the development of databases for the Internet. |
| Indicative Module Content |
|---|
| Database analysis and design: Entity-Relationship modelling, Object-Oriented and Object-Relational databases. Fundamentals of database administration: creating a database, storage management, managing users, backup and recovery. Database performance and tuning: query processing and optimisation, SQL tuning. Databases and the internet; modelling and design of data intensive web sites; web interfaces for DB systems; the XML language. |
| 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 students will progress through a sequence of exercises to develop sufficient knowledge of database security applications. |
| Indicative Student Workload | Full Time | Part Time |
|---|---|---|
| Contact Hours | 44 | 44 |
| Non-Contact Hours | 106 | 106 |
| 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: | Examination | Weighting: | 50% | Outcomes Assessed: | 1, 3, 4 |
| Description: | This is a closed book examination. | ||||
| Component 2 | |||||
| Type: | Practical Exam | Weighting: | 50% | Outcomes Assessed: | 2 |
| Description: | This is an assessed lab. | ||||
| MODULE PERFORMANCE DESCRIPTOR | ||||||||
|---|---|---|---|---|---|---|---|---|
| Explanatory Text | ||||||||
| The calculation of the overall grade for this module is based on equal weighting of C1 and C2 components. | ||||||||
| Examination: | ||||||||
| Practical Exam: | A | B | C | D | E | F | NS | |
| A | A | A | B | B | C | E | ||
| B | A | B | B | C | C | E | ||
| C | B | B | C | C | D | E | ||
| D | B | C | C | D | D | E | ||
| E | C | C | D | D | E | E | ||
| F | E | E | E | E | E | F | ||
| 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., 2011. Fundamentals of Database Systems, Addison Wesley. |
| 3 | DIETRICH, S.W., 2011. Fundamentals of object databases object-oriented and object-relational design. Morgan & Claypool. |
| 4 | FEUERSTEIN, S., 2014. Oracle PL/SQL Programming. O'Reilly . |