Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Achieving Operational Excellence: Building a Relational Database for Inventory Management In this exercise, you will use database software to design a database for managing inventory

image text in transcribed

image text in transcribed

Achieving Operational Excellence: Building a Relational Database for Inventory Management

In this exercise, you will use database software to design a database for managing inventory for a small business. Sylvesters Bike Shop, located in San Francisco, California, sells road, mountain, hybrid, leisure, and childrens bicycles. Currently, Sylvesters purchases bikes from three suppliers, but plans to add new suppliers in the near future. Using the information found in the tables in MyMISLab, build a simple relational database to manage information about Sylvesters 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 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?

Microsoft Access:

https://www.dropbox.com/s/5s2l40afmxnyv41/Data.accdb?dl=0

Cortar Reem plaza' Ascendente Seleccin. Descendent Avanzadas- Calibri pogt Ver Pegar GuardarRevisin ortogrfica Xeliminar,mMs . SeleccionarAjustar al Cambiar formulario ventanas .copiar formato FiltrD rformato ride A. Quitar orden Alternar filtro todo . uscar Farmato de texto Product Numb Product Catego Product Nam T Purchase Cos Selling Pric, Supplier Numt , Quantity on Hai Reorder Le Haga clic para agregar T Product Table supplier Table Bluff Breaker 2252225225252555555224320 '7785210935134086455045310 1132223243414341433455550 9 am, >and 7 2 5 5 4 4 8 5 9 8 1 5 5 5 5 69 5 3 4 4 8 1 3 4 $ eeBB GRRTBBB Hy Hy Hy Lei Lei Lei Le Ch h h h R R R Lei Lei Mt 12345678901 -2345678901

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 31st International Conference Dexa 2020 Bratislava Slovakia September 14 17 2020 Proceedings Part 1 Lncs 12391

Authors: Sven Hartmann ,Josef Kung ,Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil

1st Edition

303059002X, 978-3030590024

More Books

Students also viewed these Databases questions

Question

Explain the strength of acid and alkali solutions with examples

Answered: 1 week ago

Question

Introduce and define metals and nonmetals and explain with examples

Answered: 1 week ago

Question

2. How will the team select a leader?

Answered: 1 week ago