undefined

Microsoft Access Lab Your friend, the owner of Cupcakes 'N' Coffee has been doing quite well thanks to you! In a moment of generosity, you even waived your fee for helping them. You are always a phone call away day or night and have become their sole confidant(e) in regards to the management of their shop. It is a little mentally and emotionally exhausting but you are glad for their success. They are doing so well in fact that they will now need professional assistance to manage their business intelligence activities including the design and implementation of a business database system. Your friend has a meeting setup with Ora AWMicro a company that specializes in the design and implementation of business intelligence systems for growing small businesses. You have a lot going on and are not sure if you will be able to make this meeting but you do not want anyone taking advantage of your friend. Therefore, you will need to put together an executive report for your friend demonstrating a mock database you have put together in Microsoft Access. You will send this to your friend before the meeting and they will have this to send before the meeting and to have in hand during this meeting. The executive report will be sent to the Ora AWMicro representative that will be meeting with your friend. You want your friend to be able to communicate what their needs are and be "in charge of the narrative, since this is a sales meeting. Your friend has told you that they maintain a very large spreadsheet with the following fields: CustomerID, CustomerName, Dateof Birth, Address, SalesID, ProductID, ProductName, AmountSpent, BusinessID, BusinessName, BusinessAddress, SalesDateTime, Product Price You know that these will be broken up into separate tables which include "Customer", "Products","Business Customers", and "Sales" tables. The relationships between the tables can be described by a single sale can have many products associated with it, many sales can belong to one customer, many sales can belong to one business customer. Complete the following: A. Create the Database-Name the Database "Cupcakes N' Coffee" B. Create Tables for the Database (25) a. Customer Table i. Primary key is CustomerID b. Products Table i. Primary key is ProductID c. Business Customers Table i. Primary key is BusCustomerlD d. Sales Table i. Primary key is SalesID ii. Foreign Key is ProductID iii. Foreign Key is CustomerID iv. Foreign Key is BusCustomerlD