Databases

Create SQL statements (In SQL Fiddle this will be on the left hand input panel) that will create all tables in the given schema. Save the statements in a file named (yourname_create_hw.sql) Choose appropriate data types. Implement all the needed constraints. Use ON DELETE,
PRIMARY KEY, FOREIGN KEY, NOT NULL, etc. where they are required. PK and FK constraints must be named. All the
attribute names should be same as the shown schema. For date, use Timestamp data type. For min constraints see
Homework 2 ER/EER diagram.
yourname_drop_hw.sql This file will include drop statements to drop all tables in the appropriate order
yourname_delete_hw.sql This file will include delete statements to delete all the tuples from the database in the
appropriate order.
yourname_insert_hw.sql This file will include insert statements to populate the database with made up values. Make
sure to have 5 or more tuples in each table and the correct order.
yourname_select_hw.sql This file will include select statements to display all the tuples using “select * from table
name” format for each table.
yourname_select_screenshot_hw.pdf This file should contain the output of select script above to demonstrate that
all your above SQL scripts work.

Last Completed Projects