Create database management system for bike shop

Assignment Help Database Management System
Reference no: EM1370535

Your job is to develop a database management system for a bike shop who ‘buys' and ‘sells' new and second-hand bikes, and also parts of bike. A bike is constructed with parts while a part can be fitted to different bikes. The shop sales a list of selected brands of bikes, and each brand has a few models. There are a few staff members working in the shop. Some staff members are in charge of pricing, while some are to sell the products (including bike and parts). Both new and used bikes are bought with a price (known as ‘buying price'), and the shop sells it with an appropriate price (known as ‘selling price'). The prices (buying price, selling price) of a second-hand bike must be approved individually by a qualified member of staff who is in charge of pricing.

Each product (bike or part) is uniquely identified by an item code. A description about the bike such the brand, model, and condition needs to be provided. In addition it is necessary to take a recorder who approved the prices. For parts, the item code, the name of part, the mode and brand it fits and so on need to be recorded.

The database system to be developed must be able to facilitate the member staff who sales the products quickly search the parts that fit a specific model of bike, and give the correct price. One the other hand, the database system is hoped to assist the pricing staff to give appropriate price to a bike according to the model and the price of parts and so on.

Requirements to the report:

Write a report (no more than 5 pages) to present your work including the following sections:

(1) Introduction: including a review of the aims, approaches, procedures of database design, and so on.
(2) Presenting an Entity Relationship (ER) diagram, which must include all the necessary entities and their relationships.
(3) Based the ER diagram produced, producing a list of tables (the resulting tables should have been normalized up to 3NF) and the associated attributes. The primary keys and foreign keys (if any) of the tables must be stated clearly.
(4) Evaluation of your design - check if the tables are on 3NF and explain why you think they are on 3NF.
(5) The conclusion and discussion: what knowledge you have gained, the possible further improvement of the design, and any other reflection.
(6) References (any reference used in your course work need to be listed and cited appropriately

Reference no: EM1370535

Prepare a systems analysis report detailing ace''s problem

Additionally, the firm cannot tell whether its customers are more interested in no-frills cars or ones with luxury options. Prepare a systems analysis report detailing Ace's

Display the results in descending order by the gross sales

Display all the columns from the Orders table that were paid with a Visa Card and have been shipped to the customer (hint: not a null). Order results by the Item Price in de

Write a script that includes two sql statements code

Write a script that includes two SQL statements coded as a transaction to delete the row with a customer ID of 8 from the Customers table. To do this, you must first delete

Describe three unique features of pubmed database

Describe three unique features of PubMed database that sets this database apart from other evidence-based search engines. How you applied the three key questions when deciding

How an organization would allow programmatic access

A few years have passed, and the restaurant has grown to become a national restaurant chain. Now, they are concerned that remote and branch offices and restaurants in all fi

Describe the importance of using sub queries in a database

1. Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system. Provide at least two business c

Use of data definition language-data manipulation language

Pick one of the different types of SQL statements (data definition language, data manipulation language, or data control language). Describe how that type of statement is

Show the records of depositor tables

Create 2 tables customer with fields customer_id, customer_name, customer_street, customer_city and depositor customer_id, account_number, balance Set relation between the two

Reviews

Write a Review

 
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