Could someone help me with this please. I dont know anything about it :( I suck at things like that.
For maintaining its product and sales information Computer Wzadsloc contains the following three tables: Products, Sales and Customers. You have just begun working for Computer Wizards and your first assignment is to get this datebase working correctly. Some of the been correctly setup with missing or wrong field types and properties. This will impact your ability to setup appropriate relationships create forms and extract dats using queries. A description of what each table should contain is listed below The Product table contains product information for the electronic devices sold by Computer Wizards. Each product should be uniquely identified by its Rem number. Each record inchudes a description of the item, a date that it was added to the product ist and whether or not it has been refurbished. The description field shouid contain space for 50 characters. Date calculations may be required in later queries. . The Customers table contains a list of customer names and customer profies. Each record should be uniquely identified by the Customer ID. Number Field sizes for names and cities should not exceed 25 characters each. The state field requires only two characters. The zip code field should allow for leading zeros . The Sales table contains a list of company sales transactions. Each transaction should be uniquely identified by a transaction number. This transaction number is not automatically generated. Transaction records should contain the Customer ID corresponding to the customers listed on the Customers table, an item# comesponding to the items listed on the Products table, a quantity and cost in dollar format 1. Review esch table design to modify field types and properties (sizes) for each field as needed to an appropriate format For example, you may find that some fields do not have the correct data type (text vs. number etc.) or the wrong field size 2. Set up the primary keys for each table: Products. Sales, Customers. If a duplicate value appears in field you wish to use as the primary key field, you will have to first modify the table and change the primary key value for the 2d entry. (e: if there are two CustaomedD. 4's, then change the 2 one to the next sequential number availsble in thst field bssed on the last record entry 3. In the relathip window, set up the foreign keys and appropriate relationships between the tables 4. Design a form to input data for new customers. it should contain all fields from the Customer table and be in a column type format. Name the form Customers 5. Create the following queries and save them as Queryl, Query 2 etc . Query 1: Write a query to list all customers whose zip codes start with "43. List the customer ID and their full names. Sort the list alphabetically by customers last name and then by ages (oldest first) Query 2: Write a query to list the item# and description of all refurbished products that have inventory dates prior to January 5. 2011 ' Query 3: Write a query to cslculate the sales value for each transaction. The calculated result should also include the tax paid for each transaction, the tax rate is 5%. Your query should list the transaction#, item, quantity and the sales value. . Query4: Write a query to summarize transactions in Sales by item#. Use the result of Query3 to complete the problem, your query should list the item#, total quantities, total and average sales value
