Teaching Databases at Southampton University
Ken Thomas · ePrints Soton (University of Southampton) · 2003
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.