Basic SQL database build from given ER-diagram -- 2

I am developing a proof of concept SQL database from a ER-diagram using “create table” statements. There will be several types of attribute: integer, timestamp and varchar (up to 100 chars). The task involves inserting 4 records into 2 tables and 10 records into 1 table. The next step is to query the database in SQL, showing the SQL statement and corresponding output from the DBMS for 3 different queries. The deliverables include printouts of the interaction with the DBMS.