Module Details
Module Code: |
DBMS C7008 |
Full Title:
|
Database Management
|
Valid From:: |
Semester 1 - 2019/20 ( June 2019 ) |
Language of Instruction: | English |
Module Owner:: |
Stephen Larkin
|
Module Description: |
A student completing this module will have the ability to design, implement and test database transaction code, stored procedures and triggers. The student will also have gained a fundamental knowledge of Distributed Databases and non-relational databases.
|
Module Learning Outcome |
On successful completion of this module the learner will be able to: |
# |
Module Learning Outcome Description |
MLO1 |
Construct advanced Data Manipulation statements. |
MLO2 |
Encapsulate procedural database operations using stored procedures, stored functions and triggers. |
MLO3 |
Explain and apply Transaction Management theory. |
MLO4 |
Discuss current database development technologies and issues. |
Pre-requisite learning |
Module Recommendations
This is prior learning (or a practical skill) that is strongly recommended before enrolment in this module. You may enrol in this module if you have not acquired the recommended learning but you will have considerable difficulty in passing (i.e. achieving the learning outcomes of) the module. While the prior learning is expressed as named DkIT module(s) it also allows for learning (in another module or modules) which is equivalent to the learning specified in the named module(s).
|
No recommendations listed |
Module Indicative Content |
Database Procedural Programming
Stored Procedures, Functions,Triggers, DB Objects, Cursors, Collection Objects, Packages.
|
Fundamentals of Transaction Management
Transaction Concepts: ACID Properties, COMMIT & ROLLBACK; Concurrency Control: interference, locking, deadlock.
|
Database Recovery
Recovery Management: transaction log, recovery process; Checkpoints.
|
SQL: Advanced Joins & Functions
Outer Joins; Single-row Functions.
|
Database Application Development
DDL and DML; Advanced SQL; Set Operators.
|
Contemporary Database Development
Non-Relational Databases, Distributed Databases
|
Module Assessment
|
Assessment Breakdown | % |
Course Work | 100.00% |
Module Special Regulation |
|
AssessmentsFull Time On Campus
Part Time On Campus
Reassessment Requirement |
No repeat examination
Reassessment of this module will be offered solely on the basis of coursework and a repeat examination will not be offered.
|
DKIT reserves the right to alter the nature and timings of assessment
Module Workload
Workload: Full Time On Campus |
Workload Type |
Contact Type |
Workload Description |
Frequency |
Average Weekly Learner Workload |
Hours |
Lecture |
Contact |
No Description |
Every Week |
1.00 |
1 |
Practical |
Contact |
No Description |
Every Week |
3.00 |
3 |
Directed Reading |
Non Contact |
No Description |
Every Week |
3.00 |
3 |
Independent Study |
Non Contact |
No Description |
Every Week |
1.00 |
1 |
Total Weekly Learner Workload |
8.00 |
Total Weekly Contact Hours |
4.00 |
Workload: Part Time On Campus |
Workload Type |
Contact Type |
Workload Description |
Frequency |
Average Weekly Learner Workload |
Hours |
Lecture |
Contact |
No Description |
Every Week |
1.00 |
1 |
Practical |
Contact |
No Description |
Every Week |
3.00 |
3 |
Directed Reading |
Non Contact |
No Description |
Every Week |
3.00 |
3 |
Independent Study |
Non Contact |
No Description |
Every Week |
1.00 |
1 |
Total Weekly Learner Workload |
8.00 |
Total Weekly Contact Hours |
4.00 |
Module Resources
|
Supplementary Book Resources |
---|
-
Connolly, Thomas, Begg, Carolyn. (2015), Database Systems, 6th. Addison-Wesley, [ISBN: 1292061189].
-
Michael Mannino. (2014), Database Design Application Development and Administration, 6th ed.. Chicago Business Press, [ISBN: 0983332428].
-
Feuerstein, S & Pribyl, B. (2014), Oracle PL/SQL Programming, 6th. O'Reilly, [ISBN: 9781449324452].
-
Stephen Morris, Peter Rob, Carlos Coronel, Keeley Crocket. (2013), Database Priniciples: Fundamentals of Design, Implementations and Management, 2nd Ed.. Cengage Learning, Inc., [ISBN: 140806636X].
-
Peter Lake, Paul Crowther. (2013), Concise Guide to Databases: A Practical Introduction (Undergraduate Topics in Computer Science),, Springer.
| This module does not have any article/paper resources |
---|
Other Resources |
---|
-
website, MySQL Tutorial,
-
website, PostgreSQL,
-
website, Oracle Inc.. Home Page,
-
Website, MongoDB,
| |