Database Project: Cellibini Mountain Bikes - Design and Implementation

This database project focuses on designing and implementing a database solution for Cellibini Mountain Bikes. The project begins with a business description of the company and its current operations, followed by high-level process models such as flowcharts and Event-Process-Chain diagrams. The core of the project involves creating Entity-Relationship (ER) data models for various use cases, including customer management, model configuration, inventory management, order processing, and bike delivery. These individual ER models are then integrated into a high-level ER model. The project also includes the creation of a relational model and SQL queries to retrieve data. The assignment covers all aspects of database design, from conceptual modeling to logical design and query implementation, providing a complete solution for a real-world business scenario.

Running head: DATABASE
DATABASE
Name of the Student
Name of the University
Author Note

1DATABASE
Table of Contents
Business descriptions: -..............................................................................................................2
High-level process models: -......................................................................................................3
ER data model of each cluster: -................................................................................................4
High level integrated ER model: -.............................................................................................6
Relational model: -.....................................................................................................................7
SQL query: -...............................................................................................................................7
List of foreign keys: -.................................................................................................................7
Bibliography: -...........................................................................................................................8

2DATABASE
Business descriptions: -
In 1960, Aida Celli established a mountain bike company name Cellibini Mountain
Bikes. They produce the premium quality hand-assembled mountain bikes. Their factory
situated at Crozet, Virginia.
They are producing every type of motorbikes. Currently, they are keeping every
record in the excel spreadsheets. Every product has its unique code, descriptions and price
ranges. But the spreadsheet is not capable enough to keep every detail. When the company
introduces new models, size spreadsheets become complex and not understandable. In
Cellibini, many employees are working in this company. And every employee is assigned for
a specific order or many employees can work on an order. A single worker can be assigned to
the bicycle production requirements. One worker is assigned to check the bike parts at the
warehouse and examine the parts are available or not. The details of the bike parts will be
provided in the checkout lists. Every bike has a unique serial number. Before delivery, they
provide unique stamps under the seats but parts do not have any serial number. Unique codes
identify a specific part. The same type of two bikes has a different serial number but the same
types of parts can have the same codes. By following this method, a company can easily
identify every component.
Cellibini Mountain Bikes using a hand-based system. Sometimes this system occurs
several problems. To prevent this problem, they want a robust computerized system that is
able to perform the same tasks without any problem and in less time.

3DATABASE
High-level process models: -
Figure 1: Flow chart diagram
(Source: Created by author)

4DATABASE
Figure 2: Event-Process-Chain diagram
(Source: Created by author)
ER data model of each cluster: -

5DATABASE
Figure 3: ERD of customer management use case.
(Source: created by author)
Figure 4: ERD of model configuration use case
(Source: Created by author)
Figure 5: ERD of inventory management use case
(Source: created by actor)
Figure 6: ERD of getting an order use case
(Source: Created by author)

6DATABASE
Figure 7: ERD of deliver a bike use case
(Source: Created by author)
High level integrated ER model: -
Figure 8: Entity relationship diagram
(source: created by author)

7DATABASE
Relational model: -
(source: created by author)
SQL query: -
select * from Customer
inner join Bill on Customer.Customer_ID=Bill.Customer_ID;
List of foreign keys: -
 Customer_id on Bill and Order table.
 Supplier_ID on parts table.
 Part_number on Inventory table.

8DATABASE
Bibliography: -
Buede, D.M. and Miller, W.D., 2016. The engineering design of systems: models and
methods. John Wiley & Sons.
Romiszowski, A.J., 2016. Designing instructional systems: Decision making in course
planning and curriculum design. Routledge.