production
Skip to Content

CS2015: DATA MANAGEMENT (2017-2018)

Last modified: 06 Jul 2017 09:30


Course Overview

This course will be of interest to anyone who wishes to learn to design and query databases using MSAccess, MySQL and MongoDB. The course aims to teach the material using case studies from real-world applications both in lectures and lab classes. You will develop a broad knowledge about database connectivity using JDBC, PHP and Ruby. You will also learn core theoretical concepts such as relational algebra, file organisation and indexing. At the end of this course you will be able to design and build Web and cloud-based databases and have a broad awareness and understanding of how database-driven applications operate.



Course Details

Study Type Undergraduate Level 2
Session First Sub Session Credit Points 15 credits (7.5 ECTS credits)
Campus None. Sustained Study Yes
Co-ordinators
  • Dr Nigel Beacham
  • Dr Yaji Sripada

Qualification Prerequisites

  • Either Programme Level 1 or Programme Level 2

What courses & programmes must have been taken before this course?

  • Any Undergraduate Programme (Studied)

What other courses must be taken with this course?

None.

What courses cannot be taken with this course?

  • CS2008 Data Management (Studied)

Are there a limited number of places available?

No

Course Description

Course Aims

The course aims at providing students with both an in-width and an in-depth understanding of disciplined approaches to the database design process. Students will develop a broad knowledge about database connectivity using PHP and Ruby. They will also learn core theoretical concepts such as relational algebra, file organisation and indexing. At the end of this course students will be able to design and build Web and cloud-based databases and have a broad awareness and understanding of how database-driven applications operate.

Main Learning Outcomes

The basic organisation and functionality of a variety of types of database system.
Able to analyse and describe some aspect of the real world in terms of a conceptual model.
Able to design and implement a complete database application.
Able to perform basic data administration tasks.
Able to build server-side support for Web-based persistent database applications.
The outcome of the course is, by its nature, widely applicable. In its broadest terms, students will learn to apply a rigorous approach to design methodology.

Course Content

The concepts of a database and database management. Database development. Illustrations. Entity-Relationship model. Database design: logical design and the relational model. Normalisation; different normal forms. Physical design; file organisation and access; indexing. Database administration. Query by Example and SQL. Query optimisation. Practical examples using MS Access.

Client-server model. Database servers. Database access from client applications. Web-based database access through server-side scripting. Practical examples using MS Access, My SQL, Php and JDBC.

A brief overview of key concepts in distributed, object -oriented, multimedia, spatial and geo-referenced database systems.

Further Information & Notes

(i) Assistive technologies may be required for any student who is unable to use a standard keyboard/mouse/computer monitor. Any students wishing to discuss this further should contact the School Disability Co-ordinator.

Degree Programmes for which this Course is Prescribed

  • BSc Computing Science
  • BSc Computing Science and Philosophy
  • BSc Computing Science and Physics
  • BSc Computing Science-Mathematics
  • Bachelor Of Engineering In Engineering Electronic & Software
  • Bachelor Of Science In Business Mngmt & Information Systems
  • Computing Science Joint
  • Computing Science Minor
  • MA Computing
  • MA Computing and Music
  • MA Information Systems and Management
  • MSci Computing Science (AI) with Ind Pl'n
  • MSci Computing Science w Ind'l Placement
  • MSci Computing with Industrial Placement
  • Master Of Engineering In Electronic & Software Engineering
  • Master of Engineering in Computing Science

Contact Teaching Time

72 hours

This is the total time spent in lectures, tutorials and other class teaching.

Teaching Breakdown


Assessment

1st Attempt: 1 two-hour written examination (75%); continuous assessment (25%). In order to pass this course, candidates must obtain a pass mark in the examination and in the overal combination of examination and continuous assessment.

Resit: Where a student fails the course overall they will be afforded the opportunity to resit those parts of the course that they failed. 1 two-hour written examination (75%) and continuous assessment mark (25%) where the mark for the passed part is carried forward.

Formative Assessment

During lectures, student interaction will be used for formative assessment. Additionally, practical sessions will provide students with practice opportunities and formative assessment.

Feedback

Formative feedback for in-course assessments will be provided in written form. Additionally, formative feedback on performance will be provided informally during practical sessions.

Compatibility Mode

We have detected that you are have compatibility mode enabled or are using an old version of Internet Explorer. You either need to switch off compatibility mode for this site or upgrade your browser.