Suppose Super Skateboard, Inc. hired you to create an Inventory database containing relevant entities (tables). They received following quotation from their client and want to check the item availability and price in the database before replying back.

1. What entities do you need in the Inventory database (mention at least two)? What are the relevant attributes and their data types? Mention the primary and foreign keys.

2. Create the Inventory database in MS Access with appropriate attributes and data types. The database should have at least two entities which can answer the information asked in the quotation. Populate the tables with data, Item and material number are provided in the quotation. You can assume values for other attributes. Make sure to add at least one extra item in your database.

3. Design a query to display the available and requested quantities and the price.

World Wide Skateboard Distributors 1229 Westwinde Street Ann Arbor, MI, 48109 Phone 734.555.5638 Fax 734.555.5648 Date: 6/2/08 To Whom It May Concern: My name is Patrick Wilson, and I am a purchasing agent for World Wide Skateboard Distributors in Ann Arbor, MI. I was looking through your catalog, and I would like to receive a quote for the following items: A quote by email or fax would be ideal. Thank you Patrick Wilson Purchasing Agent Fax: (734) 555-5648 World Wide Skateboard Distributors 1229 Westwinde Street Ann Arbor, MI, 48109 Phone 734.555.5638 Fax 734.555.5648 Date: 6/2/08 To Whom It May Concern: My name is Patrick Wilson, and I am a purchasing agent for World Wide Skateboard Distributors in Ann Arbor, MI. I was looking through your catalog, and I would like to receive a quote for the following items: A quote by email or fax would be ideal. Thank you Patrick Wilson Purchasing Agent Fax: (734) 555-5648