Teaching Databases at Southampton University
O'Reilly, Una, James, Anne and Jackson, Mike (eds.)
At Teaching, Learning and Assessment of Databases.
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.
Conference or Workshop Item
||Event Dates: 14/7/2003
|Venue - Dates:
||Teaching, Learning and Assessment of Databases, 2003-07-14
||Electronic & Software Systems
||29 Jul 2003
||17 Apr 2017 22:47
|Further Information:||Google Scholar|
Actions (login required)