| Module Titles | |
| Actual: | Relational Databases Theory and Practice (BSc) |
| Administrative: | Relational Databases Theory and Practice (BSc) |
|
Module Information |
| It is of Level 1 ,Size 2 and is worth 20
Credit Points. This Module is not a Year Long Taught Module and was not evolved. It is not currently obsolete. |
|
Module Ownership |
| The Module Tutor is Neil Eliot In the Division of Information Systems Engineering In the School of Informatics |
| Module External Information |
| The Cost Centre is Computer Software
Engineering and the price group is B The HESA Subject is COMPUTING SCIENCE |
Synopsis of Module:
A
brief overview of aims, contents, methods and assessment
The unit
teaches the fundamental theory of relational databases and a physical
implementation of one such database management system. The main focus of the
unit will be the constructs of SQL and how it can be used to implement
relational theories.
The unit is assessed through an open book
examination.
Prerequisite(s):
Any
Module which must already have been taken at a lower level, or any stipulated
level of prior knowledge required.
None
Corequisite(s):
Module at
the same level which must taken with this Module.
Discrete Maths
Unit
CM149 Software and Data Modelling
Implications for Choice:
Possible follow-on Modules, or exclusions, or Modules which require this
one as a prerequisite.
CM036 Advanced Database
Aims of Module:
Specified
in terms of general aim of the teaching in its relation to the
subject.
- To understand the relational concept
- To
understand an implementation of Relational Theory in a DBMS
- To be able to
create a set of relations and populate them using SQL
- To be able to
understand data integrity
Learning Outcomes:
Specified in terms of performance capability to be shown on completion
of the Module.
On completion of the unit the student should be able
to:
Understand the Relational Model
Appreciate the implementaiton
of this logical model.
Define and create a relational Schema complete
with integrity constraints.
Carry out logical updates and queries on
relations within the DBMS using the SQL syntax specific to Oracle, and from that
be able to transfer the knowledge to other environments.
Outline Syllabus:
The content
of the Module, identified in a component listing.
- Principles of
Relational Databases (50%)
- The need of databases - an introduction
-
Relational data model
- Relational Query Languages
- DDL/DML/DCL
-
Relational Algebra
- Relational Calculus
- SQL - introduction
- Data
Modelling
- SQL the Relational Language (30%)
- Projection and
Restriction
- Ordering the result
- Single Row Functions
- Set
operations
- Displaying Data from several Tables
- inner, outer, full
(NULLS)
- Aggregating Data
- Updating a Database
- Transaction Control
and Concurrency (5%)
- COMMIT/ROLLBACK
- Locking
- Establishing a
database (15%)
- Creating and Managing Tables
- Constraints
- Views
Learning, Teaching And Assessment Strategy:
Teaching and learning will take the form of a series of lectures
supported by practical seminar sessions and discussions. Students will be
expected to undertake a programme of directed and independent study to support
the taught sessions. The seminar sessions will draw upon the students' studies
and directed learning. Small case studies will be used where appropriate to
reinforce the theories being taught.
Distance Learning Delivery:
None
Indicative Reading List or Other Learning
Resources:
(Note: all references to be given as per Harvard
System)
Elmasri/Navathe, ‘Fundamentals of Database Systems’,
Addison-Wesley, 3rd Edition
Date C J, ‘An Introduction to Database
Systems’, Addison-Wesley, 6th Edition, 1995
| Mode and Location | Lectures | Seminars | Tutorials | Lab Work | Directed Learning | Independent Learning | Formal Assessment | Other | Total |
| Full Time at City Campus (The duration is 15 weeks) |
24 | 0 | 0 | 24 | 100 | 50 | 2 | 0 | 200 |
| Part Time at City Campus (The duration is 15 weeks) |
24 | 0 | 0 | 24 | 100 | 50 | 2 | 0 | 200 |
|
Assessment A |
This assessment is Open Book Examination ( 2 hours) The weighting of this assessment is 100% It does have an examination The week(s) due are 14 |
| Programme Code and Title | Stage | Semester | C = Core O = Option |
| CGB04EC - BSC(HONS) INTERNET COMPUTING | 1 | 2 |
C |
| CGB04MC - BSC(HONS) MOBILE COMPUTING | 1 | 2 |
C |
| CGE04EC - BSC(H) INTERNET COMPUTING | 2 | 1 |
O |
| CGE04MB - BSC(HONS) MOBILE COMPUTING | 2 | 1 |
C |
| CGE04MC - BSC(HONS) MULTIMEDIA COMPUTING | 2 | 1 |
O |
| CMB04MC - BSC(HONS) MULTIMEDIA COMPUTING | 1 | 2 |
C |
| CMB06CB - BSC (HONS) COMPUTING FOR BUSINESS (SW) | 1 | 2 |
C |
| CMB06CI - BSC AND BSC (HONS) COMPUTING FOR INDUSTRY | 1 | 2 |
C |
| CMB06CP - BSC & BSC (HONS) COMPUTING STUDIES | 1 | 2 |
C |
| CMD06CB - BSC (HONS) COMPUTING FOR BUSINESS (PT) | 2 | 1 |
O |
| CMD06CI - BSC (HONS) COMPUTING FOR INDUSTRY (PT) | 2 | 2 |
O |
| CME06CP - BSC (HONS) COMPUTING | 2 | 1 |
O |