I need help drawing an ERD for a Bicycle shop assignment. It contains
inventory, parts and clients with invoicing, billing and statements. .
Here are the details.. This is NOT A HOMEWORK.
Entity Relationship Diagram Problem
“The Bike Shop”
Design a database for a bike bicycle repair and parts store. The store
fixes bikes and also sells repair parts to other bike shops. The
database is needed to keep track of customers, bike models, bike and
part manufacturers and bike parts the manufacturers sell.
I need to draw an entity relationship diagram that graphically models
the data requirements.
The definition should include the entity, data items in the entity
(also design the names to data item), identifying candidate keys and
foreign keys, and how the entities relate to each other. Show the
cardinality of the relationship (one-to-one, one-to-many,
many-to-many).
These are the further details;
Bike Shop Business Requirements
1. Record customer names, addresses, telephone numbers, and current
balance.
2. Record bike and part manufacturer names, addresses, telephone
numbers and bike models that each manufacturer builds.
3. Record part names and numbers, the model numbers of bikes that the
parts apply to, and the source of the part (manufacturer). A part may
fit on several models of bicycle, built by more than one manufacturer.
4. Record your parts orders to the manufacturer, identifying the parts
you order, the price per item and the extended price (price * quantity
ordered).
5. Record when the order was filled.
6. Record parts manufacturer invoices (ensuring they match the order)
and when the invoice was paid.
7. Record customer orders for parts, identifying the items ordered,
the price per item and the extended price (price * quantity ordered),
and the shipping address if different from the customer address.
8. Record parts deliveries to customers.
9. Issue invoices to customers for parts shipped. Each invoice matches
one order.
10. Record customer payments, relating the payment to an invoice.
11. Send statements to customer every month, showing invoices and
payments since the previous statement.
12. Maintain an inventory of parts, showing current stock levels,
reorder levels, and quantity on order.
Draw the data models using Visio or other graphics tool that can
convert to JPEG or GIF (please specify) SmartDraw is also acceptable.
All entities and their attributes must be clearly displayed, and
relationships between the entities described.
Please provide information and justification to anything you may
assume if information is not enough.
A final ERD must be provided by SUNDAY 13th of April 2003 or earlier. |
