PLEASE ONLY ANSWER NUMBER 3 PLEASE!!!!
Each year Fillmore school system students sell Granny Joan's Cookies to the community. The cookie proceeds fund a variety of activities for the students. To facilitate the cookie sales tracking process, design a Cookie database for Fillmore's superintendent, Dr. White. The Cookie database stores information about the students,cookie packages, cookie checkouts, and cookie sales. The data to populate the tables is included in the GrannyJoan4 excel file. Use the file to guide you in creating the tables. Activities due: 1. The Fillmore school systems wants to develop a program using access database software. Create a requirements document that lists tables and data in each table. Use access to create the new database. You will have to create 5 tables. In the seller table input the individual group members along with the imported data. Create Seller, Cookie, Checkout, and Sales forms. Add 15 additional cookies sales using the form. Add 5 more cookie packages using the cookie form. Create relationships between the tables. Create two reports. One team decided report. Describe why you are creating the report. The other report will be a Price List report. The Price list report alphabetically lists each cookie package. For each cookie package, the report should show the cookie package's name, identification number, cost, selling price, and gross income. When you submit the database it should have the queries created in step 2). Only turn in one database.The database will have the tables, forms, report, and queries. 2. From the "Business Intelligence and Analytic Tools" section of the Stair text, choose an analytic concept. Describe how the Fillmore school system can use this BI concept in the cookie business. Create at least one query to demonstrate this usage (use the database created in step 1). Explain how this is helpful to the Fillmore cookie business. Turn in the explanation of how BI can help the Fillmore school system and the explanation of the query here. Along with your custom team chosen query, also create queries to answer these questions. The answers should also be in the BI document along with a screen shot of the created query data. 1. Based on gross sales, which grade has sold the most cookies? Identify the grade level and the collected income. 2. Based on gross sales, which student sold the most cookies? 3. Based on gross income, what is the most popular cookie? 4. What are the gross sales by category? 5. The team created query. 3. The Fillmore school system is also looking for a way to answer student and parent questions about cookie sales.. Explain to the superintendent how a knowledge management system could help with this task. Create some type of knowledge management system for the Fillmore school system. This KMS does not have to coded or created using software. The system can be described in the document created to explain the importance of a knowledge management system. 4. Looking over the artificial intelligence section in chapter 9. How can Al assist the Fillmore school system cookie sales either now or in the future? What could a system like ChatGPT do to help
