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 three suppliers but plans to add new suppliers in the near future. Using the information found in the tables in MyLab MIS, build a simple relational database to manage information about Sylvester’s suppliers and products. Once you have built the database, perform the following activities.
• 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.
• 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.
• 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.
• Write a brief desсrіption 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?
Please research the inventory management topic on the Internet as needed. Based on your research, please create at least one additional table. Please populate table with fictitious data. Also, create relationships between this newly created table and existing ones. Create a simple query that will combine the information from this newly created table and one other existing table (i.e. query should fetch result by joining two or more tables) and show results. Create a report based on this newly created query. Provide detailed explanation about the table, the query and the report in your written project report. Make sure that the report also includes all the tables, queries and reports created in class.
Please create a detailed project report. Please use the “Database Project Report Template.doc” attached with this thread. Your project report will be graded as per the rubric posted at the end of the syllabus.
Please upload following files: MS Access and your report in MS Word.
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)
