INFS $3390$ Assignment $2($SQL P$1)$

$1$

Structured Query Language $($SQL$)$

Instructions

In this project, we are going to practice using Microsoft Access to run SQL queries. From a larger perspective, running

queries is a method to turn data into information and use the information to support decision$-$making. In Module $1$ we

learned that $$data$$ is different from $$information$$ in the definition.

We use a fictitious MS Access database called $$DBP$-$e$14-$Cape$-$Codd$.$ It contains data collected in an outdoor sports retail

store. Following is the structure of the data base including the relationships between tables.