From an ER-Model to Tables

A

In groups and on the black board, make SQL create table statements for Exercise D (University registrar's office) from last week. Make sure that primary keys, unique keys, and foreign keys are included in the create table statements.

B

In groups and on the black board, construct SQL insert statements for populating all the tables from Exercise A.

C

In pairs, create the tables from Exercise A in a Derby database using either JDBC or the Derby ij command-line tool. Use JDBC for executing the insert statements from Exercise B.

D

In pairs, construct SQL update statements that can modifies both a students name and SSN number. Implement the update statements using JDBC.

E

In pairs, construct SQL delete statements that can delete all rows from all tables in the database. Implement the delete statements using JDBC.