Part 1
Problem Description

Alex Events Inc., a local event planner, has several longtime clients that are becoming an issue. Historically, Alex has been able to keep business records in a notebook. There were only a few clients; they had some recurring events; only a few caterers were involved. Things have changed. Alex has decided to focus on this business full‐time, and has recently picked up some new clients. Additionally, Alex has developed more favorable contracts with new caterers, but only for certain types of events.
Furthermore, Alex would like to charge clients different rates based on the length of their contracts with Alex Events Inc. Frankly, this has all gotten out of hand! Alex has approached you to develop a database that can be useful for the firm’s issues.

Ideally, Alex would like the database to include information about the clients, the caterers and the events. Since some clients are new, not all will have events. Alex typically plans three types of events: Product Rollout, Press Conference, and Celebratory Function. Some of the caterers will work only some types of events, while others will work all types of events. Additionally, the different caterers charge different rates for different events… Alex has supplied you with an excel file with all the information currently available.

Requirements

ERD: Import the Access 1 Spreadsheet Excel file. Use the Wizard to create tables and relationships.

Please take a “screen shot” of your tables and relationships from the relationship view from Access (this is a form of your ERD – Entity Relationship Diagram) and paste it into a ppt file.

QUERIES: Create queries that provide the following information using Access 2010. Also, generate the SQL statements using Access 2010 (Please try to understand what the SQL statements are doing).

Which clients hold Product Rollouts?

Which