Module Details
Module Code: |
DBMS C7007 |
Full Title:
|
Database Development
|
Valid From:: |
Semester 1 - 2019/20 ( June 2019 ) |
Language of Instruction: | English |
Module Owner:: |
Stephen Larkin
|
Module Description: |
Students completing this module will understand and be able to apply database design techniques. They will have designed and implemented a database system and carried out data manipulation and data definition statements.
|
Module Learning Outcome |
On successful completion of this module the learner will be able to: |
# |
Module Learning Outcome Description |
MLO1 |
Apply database design techniques. |
MLO2 |
Explain the Relational Model and apply Relational Integrity Rules. |
MLO3 |
Construct Data Manipulation Statements. |
MLO4 |
Construct Data Definition Statements. |
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 |
The Relational Data Model
History, Mathematical Relations, Relational Algebra; ANSI-SPARC Database Schema
|
Database Analysis and Design
Database Development Process (Conceptual, Logical, Physical); Data Redundancy and Update Anomalies; Functional Dependencies, Identification of Primary Key; Normalisation Process (up to Third Normal Form)
|
Integrity Constraints - Definition and Application
Nulls, Entity, Referential, Domain, General/Business
|
SQL: Data Manipulation
Simple Queries, Sorting, Aggregate Functions; Grouping, Subqueries; Simple Joins; Update, Insert, Delete
|
SQL: Data Definition
Creating and Managing Tables; Required Data, Domain Constraints, General Constraints; Entity Integrity, Referential Integrity Application; Creating and using Sequences; Views and Access Control
|
SQL: Functions
Using Character and Number functions; Data and conversion functions
|
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 |
Practical |
Contact |
|
Every Week |
4.00 |
4 |
Directed Reading |
Non Contact |
|
Every Week |
2.00 |
2 |
Independent Study |
Non Contact |
No Description |
Every Week |
2.00 |
2 |
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 |
Practical |
Contact |
No Description |
Every Week |
4.00 |
4 |
Directed Reading |
Non Contact |
No Description |
Every Week |
2.00 |
2 |
Independent Study |
Non Contact |
No Description |
Every Week |
2.00 |
2 |
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. Pearson, [ISBN: 1292061189].
-
Stephen Morris, Peter Rob, Carlos Coronel, Keeley Crocket. (2013), Database Principles: Fundamentals of Design, Implementations and Management, 2nd. Cengage Learning, Inc, [ISBN: 140806636X].
-
Tim Gorman. (2014), Beginning Oracle SQL, 3rd. Apress, [ISBN: 9781430265566].
| This module does not have any article/paper resources |
---|
Other Resources |
---|
-
Website, w3schools,
-
website, SQL Course,
-
website, sql.org,
-
website, sql zoo,
-
website, Oracle Tutorial,
-
website, Firebird,
-
website, Berkley DB,
| |