CIS-390: Design of Large Software Systems
Due: Friday, April 19
For each exercise, write an SQL select statement to:
Find the ssn, first name, and last name of each person in the database.
Find the ssn, first name, and last name of people living in Boston, MA. The results should
be sorted by ssn.
Find the vin number, accident date, and damages for each accident that did not involve a driver.
Find, for each accident involving a driver, the vin number, accident date, damages, and driver's name.
Find, for each person in the database, their ssn, name, and number of vehicles they own. For full credit,
the results should include people who own zero vehicles.
You can practice writing SQL queries and test your answers online at
Alternatively, you can download a copy of MySQL Workbench from
To access my sample database using MySQL Workbench you will need the following information:
The cis390 account has read only access to the database, so you can execute queries, but you cannot do updates, etc.
- Server: scraggley.cis.umassd.edu
- Database: autos
- Username: cis390
- Password: cis390
Turn in your answers by email (either inline or as an attachment) to
email@example.com. Please use the subject
line: CIS-390 HW#4.