| 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 | |