CE153-4-AU-CO:
Introduction to Databases
2015/16
Computer Science and Electronic Engineering (School of)
Colchester Campus
Autumn
Undergraduate: Level 4
Current
15
02 March 2010
Requisites for this module
(none)
(none)
(none)
(none)
(none)
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 I1G3 Data Science and Analytics,
BSC I1GB 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)
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. Use examples to explain the basic terminology of, and perform the operation associated with, sets, relations and functions.
2. Prepare a relational schema from a conceptual model developed using the entity-relationship model.
3. Demonstrate queries in the relational algebra.
4. Employ the notion of normal forms in a relational database design.
5. Create a relational database schema in SQL that incorporates key, entity integrity, and referential integrity constraints.
6. Demonstrate data definition in SQL and retrieve information from a database using the SQL SELECT statement.
7. Use a relational database management system to build a database.
Outline Syllabus
Underlying principles
. types
. Basic, products and finite set
. operations on set
. relations
. The relational model of databases
. Function: surjections, injections
Fundamentals of Relational Database Systems
. entity-relationship modelling
. mapping conceptual schema to a relational calculus
. relational algebra: operations developed for relational databases
Relational Database Design
. functional dependency
. normal forms: 1NF, 2NF and 3NF
Structured Query Language
. data definition
. keys
. entity integrity constraints and referential integrity constraints
. query formulation
No information available.
No information available.
STUDENTS SHOULD NOTE THAT THE MODULE INFORMATION IS SUBJECT TO REVIEW AND CHANGE
Lectures and Laboratories
Assessment items, weightings and deadlines
| Coursework / exam |
Description |
Deadline |
Coursework weighting |
| Coursework |
Practical Implementation & Report |
|
50% |
| Written Exam |
Progress Test 1 |
|
25% |
| Written Exam |
Progress Test 2 |
|
25% |
| Exam |
Main exam: 120 minutes during January
|
Exam format definitions
- Remote, open book: Your exam will take place remotely via an online learning platform. You may refer to any physical or electronic materials during the exam.
- In-person, open book: Your exam will take place on campus under invigilation. You may refer to any physical materials such as paper study notes or a textbook during the exam. Electronic devices may not be used in the exam.
- In-person, open book (restricted): The exam will take place on campus under invigilation. You may refer only to specific physical materials such as a named textbook during the exam. Permitted materials will be specified by your department. Electronic devices may not be used in the exam.
- In-person, closed book: The exam will take place on campus under invigilation. You may not refer to any physical materials or electronic devices during the exam. There may be times when a paper dictionary,
for example, may be permitted in an otherwise closed book exam. Any exceptions will be specified by your department.
Your department will provide further guidance before your exams.
Overall assessment
Reassessment
Module supervisor and teaching staff
Dr Jon Chamberlain
School Office, email: csee-schooloffice (non-Essex users should add @essex.ac.uk to create full e-mail address), Telephone 01206 872770
Yes
No
No
No external examiner information available for this module.
Available via Moodle
No lecture recording information available for this module.
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.