15 Credits SPRING



Aims/Description: Effective data management is key to any organisation, particularly with the increasing availability of large and heterogeneous datasets (e.g. transactional, multimedia and geo-spatial data). A database is an organised collection of data, typically describing the activities of one or more organisations and a core component of modern information systems. A Database Management System (DBMS) is software designed to assist in maintaining and utilising large collections of data and becoming a necessity for all organisations. This module provides an introduction to the area of databases and database management, relational database design and a flavour of some advanced topics in current database research that deal with different kinds of data often found within an organisational context. Lectures are structured into three main areas: ¿ An introduction to databases ¿ The process of designing relational databases ¿ Advanced topics (e.g. data warehouses and non-relational databases) The course includes a series of online tasks with supporting `drop in¿ laboratories aimed at providing you with the skills required to implement a database in Oracle and extract information using the Structured Query Language (SQL).

Staff Contact: Dr Peter Stordy
Teaching Methods: Lectures, Seminars, Laboratory work, Independent Study
Assessment: Course work, Lab work, Weekly tasks
WebCT resources are available for this module

Information on the department responsible for this unit (Information School):

Departmental Home Page
Teaching timetable

|

NOTE
Every effort has been made to ensure the accuracy of the presented information, but the University can accept no responsibility for any errors or omissions. University courses are continually reviewed and revised. The University reserves the right to discontinue courses of study and to amend Ordinances and Regulations governing courses of study whenever it sees fit. Students and others should enquire as to the up-to-date position when they need to know this.

URLs used in these pages are subject to year-on-year change. For this reason we recommend that you do not bookmark these pages or set them as favourites.

Western Bank, Sheffield, S10 2TN, UK