The University of Southampton
University of Southampton Institutional Repository

Teaching Databases at Southampton University

Teaching Databases at Southampton University
Teaching Databases at Southampton University
In this paper, we describe some of the issues faced when designing a database systems course that will be a compulsory component for second year undergraduates in computer science. The main goal is to give an overview of database systems starting from Codd’s classical paper through to practical implementation using a SQL server (MySQL) For conceptual modelling, we chose UML because of the prior knowledge of the target class. The logical model is derived from the conceptual model and we place great importance those features that preserve the integrity of the database. SQL is used to define the tables that MySQL can implement. We show how simple application programs are produced using JDBC.
0-9541927-3-7
123-126
Thomas, Ken
b107015f-c7d9-42cc-b87b-207c49e5369a
O'Reilly, Una
88e9ce0e-7760-48db-9dfb-38e227641bed
James, Anne
57efa9ae-7c1e-4968-9e81-9769313ae2e7
Jackson, Mike
fad789c4-2c6a-416c-8680-59af79a0a3b3
Thomas, Ken
b107015f-c7d9-42cc-b87b-207c49e5369a
O'Reilly, Una
88e9ce0e-7760-48db-9dfb-38e227641bed
James, Anne
57efa9ae-7c1e-4968-9e81-9769313ae2e7
Jackson, Mike
fad789c4-2c6a-416c-8680-59af79a0a3b3

Thomas, Ken (2003) Teaching Databases at Southampton University. O'Reilly, Una, James, Anne and Jackson, Mike (eds.) Teaching, Learning and Assessment of Databases, Coventry Technocentre. pp. 123-126 .

Record type: Conference or Workshop Item (Other)

Abstract

In this paper, we describe some of the issues faced when designing a database systems course that will be a compulsory component for second year undergraduates in computer science. The main goal is to give an overview of database systems starting from Codd’s classical paper through to practical implementation using a SQL server (MySQL) For conceptual modelling, we chose UML because of the prior knowledge of the target class. The logical model is derived from the conceptual model and we place great importance those features that preserve the integrity of the database. SQL is used to define the tables that MySQL can implement. We show how simple application programs are produced using JDBC.

Text
paper4.doc - Other
Download (81kB)

More information

Published date: 2003
Additional Information: Event Dates: 14/7/2003
Venue - Dates: Teaching, Learning and Assessment of Databases, Coventry Technocentre, 2003-07-13
Organisations: Electronic & Software Systems

Identifiers

Local EPrints ID: 258039
URI: http://eprints.soton.ac.uk/id/eprint/258039
ISBN: 0-9541927-3-7
PURE UUID: 63983e6f-25a2-45fd-9da7-b400b00dd861

Catalogue record

Date deposited: 29 Jul 2003
Last modified: 29 Jan 2020 15:30

Export record

Contributors

Author: Ken Thomas
Editor: Una O'Reilly
Editor: Anne James
Editor: Mike Jackson

University divisions

Download statistics

Downloads from ePrints over the past year. Other digital versions may also be available to download e.g. from the publisher's website.

View more statistics

Atom RSS 1.0 RSS 2.0

Contact ePrints Soton: eprints@soton.ac.uk

ePrints Soton supports OAI 2.0 with a base URL of http://eprints.soton.ac.uk/cgi/oai2

This repository has been built using EPrints software, developed at the University of Southampton, but available to everyone to use.

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we will assume that you are happy to receive cookies on the University of Southampton website.

×