Descending order from most expensive to least expensive

Assignment Help Operation Management

Reference no: EM132270888

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. MyLab MIS contains more details about the specifications for the database.

After 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. Within each supplier category, 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 identified items.

Write a brief description of how the database could be enhanced to improve management of the business further. What tables or fields should be added? What additional reports would be useful?

Reference no: EM132270888

Questions Cloud

What kinds of duties do the managers of corporation owe : What kinds of duties do the managers of a corporation owe, and to whom do they owe the duties you have identified?

Describe each of four major challenges that netflix faces : Briefly describe each of the four major challenges that Netflix faces

Most important steps involved with decision making process : Describes the most important steps involved with the decision making process and the process of problem solving.

Study advertising exploitation of environmentalism : This assignment asks you to study advertising’s exploitation of environmentalism in order to sell products.

Descending order from most expensive to least expensive : Prepare a report that identifies the five most expensive bicycles. The report should list bicycles in descending order from most expensive to least expensive.

Which type of leadership power is britney using : Which type of leadership power is Britney using? Does Candace have any other alternatives than the two that she is considering?

Describe the organizational culture at crudeoil : Describe the organizational culture at CrudeOil. How does it contribute to the current situation?

When interpreting the law and analyzing legal situation : IRAC is a form of writing generally used by lawyers when interpreting the law and analyzing a legal situation.

Summarize the organizational strengths and core competencies : Summarize the organizational strengths and core competencies which distinguish KIPP Houston from its competitors.

User Account

All Pages