From an ER-Model to Tables


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.


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


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.


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


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