6-10 In this exercise, you will use database software to design a database for managing inventory for a small business. Sylvester’s Bike Shop, located in San Francisco, California, sells road, mountain, hybrid, leisure, and children’s bicycles. Currently, Sylvester’s purchases bikes from five suppliers but plans to add new suppliers in the near future. Using the information found in the tables in MyLab MIS (copy of MS Access file attached here), create queries and perform the following activities. 1.Prepare a report that identifies the five most expensive bicycles. The report should list the bicycles in descending order from most expensive to least expensive, the quantity on hand for each, and the markup percentage for each.  2.Prepare a report that lists each supplier, its products, the quantities on hand, and associated reorder levels. The report should be sorted alphabetically by supplier. For each supplier, the products should be sorted alphabetically.  3.Prepare a report listing only the bicycles that are low in stock and need to be reordered. The report should provide supplier information for the items identified. 4.  Write a brief description of how the database could be enhanced to further improve management of the business. What tables or fields should be added? What additional reports would be useful?  Hint: Use the query wizard to create queries first. You can then prepare the various reports. MIS16ch06_questionfile.accdb

Instructions:Articulate which punishment, from oral reprimand to termination, would be most appropriate for a female officer involved in posing for nude photographs.Explore the potential implications of a police officer's error in judgment.Determine what you, in a leadership capacity, would have done to prevent this potential problem.Extra Instructions:You must decide if the officer should be disciplined, and if so, what the appropriate punishment would be. The punishment ranges from oral reprimand to removal from her position as a police officer. You will also have to justify your decision and articulate your responses to the city manager, the city council, and the media.Special Instructions:Create a 1 page essay in APA format following the instructions above. Use 2 sources as references. Be sure to include in-text citations.

Question 1- Define what is meant by consumer privacy in our society today? How can you obtain a copy of your credit report? How often should you monitor your report? Question 2- What are signs of telemarketer fraud and how do you steer clear of these scams?