Achieving Operational Excellence: Building a Relational Database for Inventory M

Question

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. 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 MyMISLab, 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 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

Explanation / Answer

students to file organization terms and concepts. The database management system is comprised of three components: important database terminology, types of databases, and the elements of SQL. If you have access to a relational DBMS during class time.DNA databases provide a centralized, digitized collection of one-of-a-kind data to prove the guilt or innocence of suspected criminals. The database provides a fast, economical method of comparing evidence at crime scenes with DNA profiles to help apprehend those suspected of committing crimes. Law enforcement agencies around the world can access the databases created by the states and linked through the FBI’s CODIS system.The ability to share the data saves money and time.Sharing the data ensures a wider availability of the collected data.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.