Project 3 – 100 pts. 1. Design the Acquisition/Payment AIS for a retail establishment of your group’schoosing. Write a narrative describing your purchasing procedures, your store,your supplier credit policies, product, pricing, inventory tracking and costing,REA events, business process rules (cardinalities)--anything that would aid in ourunderstanding of the acquisition/purchasing process of your business. Explain allevents in the narrative (helps the design of tables).2. Design REA model complete with cardinalities and links on paper or in Excel.Then, implement your model completely into Access. The links and model on thepaper should match the ones in Access. (REF. the model in Ch. 9 pg 263) If thelinks on your group’s REA model do not match the Access implementation, theproject receives no credit. You design the model. If you change something inAccess, it is up to you to go back and change it on the REA model.3. Design data in all tables (able to use pictures). Make the database professional.a. Inventory table should be at least 250 records—research into inventoryattributes adds points to the score. The vendor table must be at least 100records. Event tables should have at least 100 records per table, except forpurchase returns—that can be 25 records. Cash table should have at least10 cash accounts. Employee table should have 50 employees. If you rigthe data in the table to make the database work—it is quite easy to see thatin the data structure. Rigging the data structure in this fashion brings thegrade of the project below C. b. Contents, field, and data are up to you. Use the text for guidance as totable attributes.4. Queries (at least 30 for groups of 3, and 40 for groups of 4)a. Simple queries are based on 1 table.b. Complex queries are based on 2 or more tables.c. Include a description as to what question each query is asking in yournarrative. When I grade the project I will compare the query with thedescription in your write up. Ask questions that will help you run the business efficiently. Queries should answeraccounting questions such as A/P, A/P turnover, pro forma profit, budgeting, pro formacost of goods sold, profit per item, etc. Your project must use data to doacquisition/payment accounting calculations, for example total outstanding payable for apurchase, total A/P at a point in time, aging of A/P, calculation of the average number ofdays it takes to pay vendor invoices, purchase return ratio, total inventory on hand bytype, supplier performance ratio, etc. (Look in Ch 9 for ideas.)d. Pivot tables, complex queries, graphs, charts and queries based on other queries improve the grade. Listings are not as useful as totals, percentages, comparisons, and calculations of accounting numbers.5. Reports a. at least 4 for groups of 3 and 5 for groups of 4 studentsb. add pictures, logo, title on each pagec. more points for totals and subtotals d. The report should have title, numbers, and date on every page –professional appearance.e. The information on the report should answer a question that you asbusiness owner would want or need to know about the purchasing process.Well thought out reports get more points than simple listings. Describewhat purpose the report will be used for. Include in the title whether thereport is a detail report or summary report. You do not want to dumpinformation in reports in lists. You want to use the reports to interpret thedata you have. f. Include a description as to what question each report is answering in yournarrative. When I grade the project I will compare the report with thedescription in your write up. 6. Forms a. at least 4 for groups of 3, and 5 for groups of 4 studentsb. at least 2 form should have a subform—more subforms are betterc. creativity is encouraged7. Switchboard should have:a. View Queriesb. View Reportsc. View Formsd. View Tablese. Print8. Remember to copyright your database project. Additional Comments: Dr. Martin is available to help fix links. Bring to office with a flash drive. Make sure theCD or flash drive that you use to store the project opens without any problems.Pictures and graphics make a good impression but don’t compensate for a database that isdesigned incorrectly. A passing grade in this class requires a passing grade on this project. For a good gradeyour project must show creativity with new things. Your project must be correct as tolinks, data structure in tables, and calculations. Your project must use data to doacquisition/payment accounting calculations (remember to look in Ch 9 for ideas.)What is pro forma profit or loss? On what items?Match narrative to REA model. Match REA model to cardinalities in Access (links).Event tables are critical. Resource tables are critical.No redundancy. Watch for redundant data in tables. CD needs wrapper or case.Keep in mind what you would need to know to run a successful business.If it looks like the Homework, it doesn’t look good enough.Creativity pointsTechnical PointsGraphics