Business today depend on databases to provide reliable information about items in inventory, items in inventory, items that need restocking, and inventory costs. In this exercise, you will use database software to design a database for managing inventory for a small business. Fictional Sylvester`s Bike Shop, located in Hamilton, Ontario, sells road, mountain, hybrid, leisure, and children bicycles. Currently, Sylvester`s purchases bikes from three suppliers but plans to add new suppliers in the near future. This rapid growing business needs a database system to manage this information. Initially, the database should house information about suppliers and products. The database should contains two tables: a supplier table and a product table. The reorder table refers to the number of items in inventory that triggers a decision to order more items to prevent a stock out (in other words, if the number of units of a particular inventory falls below the reorder level, the item should be reordered). The user should be able to perform several queries and produce several management reports based on the data contained in the two tables. Using the information found in the tables on the attachment file, build simple relational database for Sylvester`s.
Once you have build the data base, perform the following questions:
1) Prepare a report that identifies the five most expensive bicycles. The report should list the bicycles in descending order from most expensive to lsit expensive, the quantity on hand for each, and the mark up percentage for each.
2) Prepare a report that list each suppliers, the suppliers products, the quantities on hand, and associated reorder levels. The report should be shorted alphabetically by supplier. Within each supplier category, the product should be shorted 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. ***The database file should include, at a minimum, the following components: true relational table(s) relationships report queries reports an Access database with reports and queries as described above (the number of queries and reports will be up to you)
Attachment:- Assignment.rar