CE153-4-AT-CA:
Introduction to Databases

The details
2018/19
Computer Science and Electronic Engineering (School of)
Colchester Campus & Apprenticeship Location
Autumn Special
Undergraduate: Level 4
Current
Thursday 04 October 2018
Friday 14 December 2018
15
-

 

Requisites for this module
(none)
(none)
(none)
(none)

 

(none)

Key module for

BSC YHG1 Digital and Technology Solutions (Software Engineer)

Module description

Learning Outcomes

The aim of this module is to provide an introduction to data modelling and the design and implementation of relational databases.

After completing this module, students will be expected to be able to:

1. Prepare a relational schema from a conceptual model developed using the entity-relationship model.
2. Employ the notions of relation, key and normal forms in a relational database design.
3. Create a relational database schema in SQL that incorporates key, entity integrity, and referential integrity constraints.
4. Demonstrate data definition in SQL and retrieve information from a database using the SQL SELECT statement.
5. Use a relational database management system to build a database.

Outline Syllabus

Underlying principles
. The relational model of databases

Fundamentals of Relational Database Systems
. entity-relationship modelling
. mapping conceptual schema to a relational model
. relational algebra: operations developed for relational databases

Relational Database Design
. functional dependency
. normal forms and normalisation

Structured Query Language
. data definition
. keys
. entity integrity constraints and referential integrity constraints
. query formulation

Module aims

No information available.

Module learning outcomes

No information available.

Module information

STUDENTS SHOULD NOTE THAT THE MODULE INFORMATION IS SUBJECT TO REVIEW AND CHANGE

Learning and teaching methods

Lectures and Laboratories

Bibliography

This module does not appear to have a published bibliography.

Assessment items, weightings and deadlines

Coursework / exam Description Deadline Weighting
Coursework   Progress Test 1 - Week 7    16.6% 
Coursework   Progress Test 2 - Week 10     16.6% 
Coursework   Hand-in: worksheet of Week 4    6.7% 
Coursework   Hand-in: worksheet of Week 5    6.7% 
Coursework   Hand-in: worksheet of Week 7    6.7% 
Coursework   Hand-in: worksheet of Week 9    6.7% 
Coursework   Hand-in: worksheet of Week 11    6.7% 
Coursework   Assignment    33.3% 
Exam  120 minutes during January (Main) 

Overall assessment

Coursework Exam
60% 40%

Reassessment

Coursework Exam
0% 0%
Module supervisor and teaching staff
Dr Javier Andreu-Perez, email: javier.andreu@essex.ac.uk.
Dr Chris Fox
School Office, email: csee-schooloffice (non-Essex users should add @essex.ac.uk to create full e-mail address), Telephone 01206 872770

 

Availability
No
No
No

External examiner

No external examiner information available for this module.
Resources
Available via Moodle
Of 212 hours, 50 (23.6%) hours available to students:
162 hours not recorded due to service coverage or fault;
0 hours not recorded due to opt-out by lecturer(s).

 

Further information

Disclaimer: The University makes every effort to ensure that this information on its Module Directory is accurate and up-to-date. Exceptionally it can be necessary to make changes, for example to programmes, modules, facilities or fees. Examples of such reasons might include a change of law or regulatory requirements, industrial action, lack of demand, departure of key personnel, change in government policy, or withdrawal/reduction of funding. Changes to modules may for example consist of variations to the content and method of delivery or assessment of modules and other services, to discontinue modules and other services and to merge or combine modules. The University will endeavour to keep such changes to a minimum, and will also keep students informed appropriately by updating our programme specifications and module directory.

The full Procedures, Rules and Regulations of the University governing how it operates are set out in the Charter, Statutes and Ordinances and in the University Regulations, Policy and Procedures.