CE153-4-AU-CO:
Introduction to Databases

The details
2019/20
Computer Science and Electronic Engineering (School of)
Colchester Campus
Autumn
Undergraduate: Level 4
Current
Thursday 03 October 2019
Saturday 14 December 2019
15
28 August 2019

 

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

 

(none)

Key module for

BSC G610 Computer Games,
BSC G612 Computer Games (Including Year Abroad),
BSC I610 Computer Games (Including Placement Year),
BENGG420 Computer Networks,
BENGG421 Computer Networks (Including Year Abroad),
BENGI120 Computer Networks (Including Placement Year),
BSC G400 Computer Science,
BSC G401 Computer Science (Including Year Abroad),
BSC G403 Computer Science (Including Foundation Year),
BSC I101 Computer Science (Including Placement Year),
MSCIG402 Computer Science,
MSCII100 Computer Science (Integrated Masters, Including Placement Year),
BENGH650 Computer Systems Engineering,
BENGH651 Computer Systems Engineering (Including Year Abroad),
BENGHP50 Computer Systems Engineering (Including Placement Year),
BENGGH46 Computers with Electronics (Including Foundation Year),
BENGGH4P Computers with Electronics,
BENGGH4Q Computers with Electronics (Including Year Abroad),
BENGI1H6 Computers with Electronics (Including Placement Year),
BSC GH56 Information and Communication Technology,
BSC GH5P Information and Communication Technology (Including Year Abroad),
BSC I102 Information and Communication Technology (Including Placement Year),
BSC I1G3 Data Science and Analytics,
BSC I1G3CE Data Science and Analytics,
BSC I1GB Data Science and Analytics (Including Placement Year),
BSC I1GBCE Data Science and Analytics (Including Placement Year),
BSC I1GC Data Science and Analytics (Including Year Abroad),
BSC I1GF Data Science and Analytics (Including Foundation Year),
BSC G111 Computing,
BSC G112 Computing (Including Year Abroad),
BSC G113 Computing (Including Placement Year),
BSC GH01 Computing and Electronics,
BSC GH02 Computing and Electronics (Including Year Abroad),
BSC GH03 Computing and Electronics (Including Placement Year)

Module description

The module will provide an introduction to data modelling and the design and implementation of relational databases, exemplified using SQL. Students will prepare a relational schema from a conceptual model using the entity-relationship model. They will understand the notions of relation, key and normal forms in database design. Students will demonstrate data definition in SQL and retrieve information using SQL SELECT, leading to a relational database management system to build a database.

Module aims

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

Module learning outcomes

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.

Module information

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

Learning and teaching methods

Lectures and Laboratories

Bibliography

This module does not appear to have any essential texts. To see non-essential items, please refer to the module's reading list.

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 Completion certificate of lab exercise - Week 4 25/10/2019 16.6%
Coursework Completion certificate of lab exercise - Week 5 01/11/2019 16.6%
Coursework Completion certificate of lab exercise - Week 7 15/11/2019 33.3%
Coursework Completion certificate of lab exercise - Week 9 29/11/2019 6.7%
Coursework Completion certificate of lab exercise - Week 11 13/12/2019 6.7%
Coursework Assignment 18/12/2019 33.3%
Exam 120 minutes during January (Main)

Overall assessment

Coursework Exam
60% 40%

Reassessment

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

 

Availability
Yes
No
No

External examiner

No external examiner information available for this module.
Resources
Available via Moodle
Of 184 hours, 60 (32.6%) hours available to students:
92 hours not recorded due to service coverage or fault;
32 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.