Do Hands-On MIS Project: 6-10

Building a Relational Database for Inventory Management

Build a simple relational DB, then perform the following activities.

Prepare a report that identifies the five most expensive bicycles.

Prepare a report that lists each supplier, its products, the quantities on hand, and associated reorder levels.

Prepare a report listing only the bicycles that are low in stock and need to be reordered.

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?