Subject: Advanced SQL Programming

Question #1: You are a consultant for a Photography Studio business. You are helping them develop an application to support their business. Therefore, you need to create a database to support it. The business will take individual, family, pet and special occasion photos in the studio. Private off-sight bookings are available for graduation, prom, special events and weddings. Price packages are available based on # of printed vs digital images desired. Off-site bookings have a reservation deposit that is non-refundable. Prices in the studio vary based on the number of people/pets in the photo.

A:

What information needs to be stored?

What tables need created?

What columns are needed on each table?

What data types would be best for each type of data in the columns?

Which columns contain required data?

B:

Tables with the columns and data types identified above

Primary Keys

Foreign Keys

Insert data into the parent tables

Insert data into the child tables

Write basic SELECT statements to retrieve information