Introduction to Persistent Data: From an ER-Model to Tables

Location A4-106
Time October 26, 14.30-16.15
Subject In this lecture we will look at how ER-diagrams can be mapped to tables. In particular, we look at SQL's create table statement. These statements can be executed on a DBMS and it is then ready to store information according to the format specified by the create table statement. From the JDBC perspective we will look at how to create a statement and use the executeUpdate method to actually execute the create table statement on the DBMS. Further, we will look into how to get data into the newly created tables using SQL's insert, update, and delete statements.
Reading "Database System Concepts" Chapter 2.9 Reducing of an ER Schema to Tables. You may skip Sections 2.9.6 and 2.9.7. This section is on how to map ER diagrams to tables. Chapter 4.9 Modification of the Database + Chapter 4.11 Data-Definition Language. These chapters provides an introduction how to create tables and insert, update, and delete information from tables. "JDBC and Java" pages 39-46. Here basic access from Java to a database using JDBC is described.
Exercises Exercise
Slides PDF