to this website for details about the different field sizes for the Number Data Type: ); o Currency – Change the format to a type more appropriate if you deem this necessary. o NOTE: The following fields must be Number with field size Double: Members table – Phone field Transactions table – Discount field • Use the “Description” area to indicate to the users of the database which fields are primary keys (“Primary Key”) and which fields are foreign keys (“Foreign Key”) in each table. [NOTE: typing “Primary Key” in the description field does not indicate to Access that the field is a primary key] • After importing the data from Excel into Access, you should have the following number of records in each table: o Members table – 1,713 records o Transactions table – 9,330 records o Service table – 6 records o Location table – 20 records Part B: Relationships (10 points) In this section, you must specify how data in one table is related to data in another table. For example, • How are transactions associated with members? • How are members associated with services? Each table in the database should have a relationship (i.e. be connected to) at least one other table in the database, but may be connected to more than one table. Use the field names and your intuition to figure out how the tables should be related to one another. • For each relationship, be sure to Enforce Referential Integrity Part C: Queries (40 points) Next you will create four queries to select a subset of records and/or fields, and also to calculate new information, such as revenue, cost, and profit that will be useful for Prestige Hotel employees as they evaluate member purchasing patterns. When creating each new query, • First, THINK about the information needed – where does it reside (other tables/queries)? • Second, think about how to include it in your query before you start clicking query buttons. • Third, start by adding one field at a time to your query so that you can view the records/fields being included, and run your query each time you add a new field to see what happens. It will be MUCH easier to identify and fix problems with your query if you include fields incrementally than if you added all fields immediately. NOTE: You MUST specify ALL aspects of your query in the Query Design View. For example, if you are asked to sort by a particular field, you MUST use the Sort functionality in Query Design View to get full credit (e.g. do not run your query, and then sort by the field in Datasheet View).