Database Theory and Design - 2019 entry
MODULE TITLE | Database Theory and Design | CREDIT VALUE | 15 |
---|---|---|---|
MODULE CODE | ECM2419 | MODULE CONVENER | Unknown |
DURATION: TERM | 1 | 2 | 3 |
---|---|---|---|
DURATION: WEEKS | 12 |
Number of Students Taking Module (anticipated) | 81 |
---|
This module will give you an insight into the theoretical and technical issues underlying current and future database management systems. You will acquire practical and theoretical competence in database modelling and design, as well as gaining familiarity with modern state-of-the-art database technology.
Prerequisite module: ECM1400, ECM1410, ECM1413 or equivalent.
The intention of the module is to equip you with the theoretical and practical knowledge needed to design, develop and manage database systems using modern database management systems. You will get hands-on experience on a selected database management system that is currently in commercial use. By the end of the module you will be competent with the methods for designing, developing and managing database systems and their associated forms-based applications.
On successful completion of this module, you should be able to:
7 interpret an informal requirement specification;
- the relational model and its expression in SQL-92;
- information modelling and mapping to SQL;
- database design theory;
- transactions and their use in integrity and recovery management;
- physical database implementation;
- dynamic modelling and user interaction via forms.
Scheduled Learning & Teaching Activities | 50 | Guided Independent Study | 100 | Placement / Study Abroad | 0 |
---|
Category | Hours of study time | Description |
Scheduled learning and teaching activities | 20 | Lectures |
Scheduled learning and teaching activities | 10 | Workshops |
Scheduled learning and teaching activities | 20 | Individual assessed work |
Guided independent study | 100 | Guided independent study |
Form of Assessment | Size of Assessment (e.g. duration/length) | ILOs Assessed | Feedback Method |
---|---|---|---|
Conceptual level design | 10 hours, open book | 3,7,8,9,10 | Written and oral |
Relational algebra worksheet | 6 hours, open book | 4 | Written and oral |
SQL coding | 6 hours, open book | 2,3,4,6,11,12 | Written and oral |
Coursework | 30 | Written Exams | 70 | Practical Exams | 0 |
---|
Form of Assessment | % of Credit | Size of Assessment (e.g. duration/length) | ILOs Assessed | Feedback Method |
---|---|---|---|---|
Coursework (DB design and implementation) | 30 | 24 hours | 2, 3,4, 6, 7,8,9,10, 11, 12, 13 | Written and oral |
Written exam | 70 | 2 hours - January Exam | 1,2,3,4,5,6,7,8,9,10,11 | Written and oral |
Original Form of Assessment | Form of Re-assessment | ILOs Re-assessed | Time Scale for Re-reassessment |
---|---|---|---|
All above | Written exam | All | August |
Referred students will be re-assessed for a maximum of 40%. For students deferred in the exam only, the uncapped exam mark will be combined with marks from coursework according to the stated percentage weightings. For students deferred in the whole module, the uncapped exam mark will be used.
information that you are expected to consult. Further guidance will be provided by the Module Convener
ELE: http://vle.exeter.ac.uk
Reading list for this module:
Type | Author | Title | Edition | Publisher | Year | ISBN |
---|---|---|---|---|---|---|
Set | Connolly, Thomas and Begg, Carolyn | Database Systems: A Practical Approach to Design, Implementation and Management | 6th | Pearson | 2015 | 1292061189 |
Set | Michael J. Herrnandez | Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design | 3rd | Addison Wesley | 2013 | 0321884493 |
Set | Elmasri, R., Navathe, S. B. | Fundamentals of Database Systems | 7th | Pearson | 2016 | 1292097612 |
Set | Silberschatz, A, Korth, H F, and Sudarshan, S | Database System Concepts | 6th | McGraw-Hill | 2013 | 9332901384 |
CREDIT VALUE | 15 | ECTS VALUE | 7.5 |
---|---|---|---|
PRE-REQUISITE MODULES | ECM1413, ECM1400, ECM2415 |
---|---|
CO-REQUISITE MODULES |
NQF LEVEL (FHEQ) | 5 | AVAILABLE AS DISTANCE LEARNING | No |
---|---|---|---|
ORIGIN DATE | Tuesday 10th July 2018 | LAST REVISION DATE | Tuesday 7th August 2018 |
KEY WORDS SEARCH | Database; design; modelling. |
---|
Please note that all modules are subject to change, please get in touch if you have any questions about this module.