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
2003
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.
.
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.
More information
Published date: 2003
Additional Information:
Event Dates: 14/7/2003
Venue - Dates:
Teaching, Learning and Assessment of Databases, Coventry Technocentre, 2003-07-14
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: 14 Mar 2024 06:05
Export record
Contributors
Author:
Ken Thomas
Editor:
Una O'Reilly
Editor:
Anne James
Editor:
Mike Jackson
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