User Account

All Pages

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

  Assume that a student table in a university

Assume that a student table in a university database has an index on StudentID (the primary key). and additional indexes on Major, Age, Marital status, and HomeZipCode.

  Advantages and inconveniences of new relational scheme

Compare activity (quite theoretical) of the disk (in number of bytes) required for each of both relational. Write down the advantages and inconveniences of new relational scheme.

  Create a database for a home-budgeting application

The first part is to create a database and some tables which will be appropriate for a home-budgeting application. That portion of the assignment should be completed from the MySQL console command line.

  Prepare a set of non-functional requirements

Need a system that networks its 3 campuses in the US and one campus in Singapore. Transaction data for all campuses should be available to all locations. In addition, students should be able to use the Internet to view classes, enroll, register, and ..

  Develop view for sum of number ordered multiplied by price

Develop a view named OrdTot. It comprises the order number and order total for each order presently on file. (Order total is sum of the number ordered multiplied by quoted price.

  When would creating an index reduce overall database perform

Indexing can affect the performance of a general-purpose database that has roughly equal numbers of fetches and changes. The decision to add an index can improve the performance of a system but can also degrade it.

  Data modeling and normalization

Data Modeling and Normalization

  List different entities-objects-logical processes-data flows

List the different entities or objects, logical processes, data flows, and data stores that are involved, starting from the time you submitted your time sheet.

  Changes require to make-premiere products database

Point out the changes you require to make to Premiere Products database to support following situation: A customer is not necessarily represented by a single sales rep but can be represented by several reps.

  Create an oracle database

Populate your database with at least 3 rows of data and import your IDEF1X diagram into Oracle and create the appropriate tables and relationships.

  Draw object-oriented model for private airport database

Draw an object-oriented model for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots.

  Describe entity-relationship model

Describe the entity-relationship model. How are entities, relationships, and attributes represented in this model? What is a composite entity? Describe the approach to diagrams that uses a crow's foot.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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