ISYS-307: Final Exam

When asked to create a table you should try to choose the best type possible for the field. For string keep the standard length of 255. You are not graded on choosing string lengths. Each question is 1/10th of your score. Partial credit will be given.

1. Create a database where the filename is the same as your last name (i.e. heatonFinal.acdb).
2. Create a table that holds the products that a company sells. The fields should be model_number, color, price, name, weight, and category. Please use a multi-value field for color.
3. Create a table that holds the categories of the catalog. The fields should be category_name.  These are the categories for your catalog (i.e. Shorts, Pants, Hats, Socks, etc).
4. Update the relationships so that the relation between products and categories is shown. This should be a one (category) to many (products) relationship.
5. Populate your category table with three categories.  Populate your products table with ten products. Use data of your choice. Pick data so that each of your queries below will return at least two rows.
6. Create a report that will display all products.
7. Create a form used to enter new products.
8. Create a switchboard that will take allows you to exit the application, or view the form or report.
9. Create a pivot chart that shows what percentages of each color is represented in the database.
10. Create a pivot pie chart that shows what percentage of products appear in each category.

Extra Credit: Answer in your email. 

What does the following SQL do?

SELECT COUNT(*) FROM PRODUCTS
WHERE PRICE>10.00