Make a report that identifies the most expensive bicycles

Assignment Help Database Management System
Reference no: EM13308304

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

Reference no: EM13308304

Questions Cloud

What is the percentage change in the specific weight : At a depth of 4 miles in the ocean the ppressure is 9520 psia. Assume that the specific weight at the surface is 64.0 lb/ft^3 and that the average volume modulus is 320000psi for the pressure range.
How to determine maximum positive factored design moments : How to determine maximum positive and maximum negative factored design moments at a certain point
What that means for your decision to do : Based on the above data, and on your preliminary SWOT analysis from Applied Topic 1, write a 3-4 page essay on the overall health of the economy and what that means for your decision to do
Determine what is the percentage yield of the reaction : The combustion of 52.8g of butane produces 104.0g of CO2. what is the percentage yield of the reaction
Make a report that identifies the most expensive bicycles : 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.
What software must be considered to provide adequate : Based on the Vosevich (2012) article, what software must be considered to provide adequate security and risk management across the enterprise?
Potential conflicts that could naturally occur : Most people have a blend of leadership styles they use. Some leaders are more flexible in applying a wide range of leadership styles while others are more consistent and generally use just one or two preferred behaviors. If two strong individuals beg..
At most how high can the probability of a major security : At most how high can the probability of a major security breach be with the IDS in place for a risk-neutral rational decision maker to purchase the IDS?
How far does a horizontal plane depart from a level surface : The width of a lake is 16 km (it is a flat plane tangent to the radius of the sphere). How far does a horizontal plane depart from a level surface if the earth is a sphere with r=6371km

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd