Think of the some kind of information that one might find in a database. Now think of the type of questions you might want to know about this data. For this project, you will create an Access 2007 database containing some data and then make queries to the database.
Create a database with at least 4 tables. In a file called database.txt, write a description (few sentences) of what kind of information your database is supposed to store. Does it store student information and the courses they have taken? Does it store a list of sailors, boats, and reservation times?
NOTE: In terms of what your database can encompass, you may not do anything that has to do with reserving equipment/vehicles, student grades, courses taken, or performances and events. In short, we want you to think of something new. The world collects heaps of data, so there's no shortage of options.
The database should not store redundant information. You achieve that by making sure the tables are compact and not redundant. Do not create super large tables unless all the columns are relevant. For example, in Lab #10, you could theoretically have made a table with performer information and event information all in one table, but that would have a lot of repeated information about the performer for each event they participate in.
After creating and linking the tables, write at least 3 questions that you might want to ask about this data. What performers are performing at the Paramount? When is the Showbox booked? Write these questions in the database.txt file. In this same file, for each question, write the SQL query that you would need to get you the answer to those questions. The SQL query should select only the relevant columns needed to answer the query. Do not show irrelevant columns. For example, do not show the address of the Showbox if the question is "When is the Showbox booked?"
At least 2 of the queries must involve a join.
When submitting, make sure you have the right section. Some TAs have two sections, so make sure you know which of the two sections is the right one. Turn in both files here. As with the last two labs, you will see a screen of garbage on successful submission. That's OK.