Mikes Bike Management System

1
Mikes Bike Management System

• IS 315 Analysis and Design Techniques
• DePaul University - CTI

2
Context Diagram
Order Request
Mike
Customers
Reports
0
MB Mgmt System
Invoice
Pick List
Authorization Request
Available Bike
Credit Card Bureau
Bike Warehouse
CC Status
Bikes/Warehouse can be handled inside the system
or as an external entity. CC Bureau may or may
not be necessary. Mike is also optional,
receiving an inventory report
3
DFD Level 0
Bike Inventory
Customers
Order Info
Available Bikes
CC Bureau
Customer Info
CC Auth Req
Customer Info
OK
Inventory Info
Customer Info
Inventory Info
Order Info
Category Info
Reports
Bike Info
Update Category
Mike
Last Order Info
Invoice
Update Order info
Updated Bike Info
Order Info
Order Info
4
ERD
Bike Category
1
Customer
Describes
1
Places
M
Bike Inventory
M
1
Order
Contains
Consists of
Bike Order Group
M
M
1
5
Data Stores

• Bike Category
• Category ID
• Description
• Rate - Daily
• Rate - Weekly

• Inventory
• Bike ID
• Category ID
• Size
• Type
• Mfgr
• Year Made
• Times Rented
• Inventory Status

• Customer
• Customer ID
• Name
• Address
• Phone
• CC Number
• Last Order
• Total Orders amount

• Rental Order
• Rental Number
• Customer ID
• Order Date
• Return Date
• Phone
• Bike Order Group
• Number of Bikes
• Order amount

• Bike Order Group
• Rental Number
• Bike ID
• Status

6
CRUD Matrix