Database - Cellibini Mountain Bikes

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

DATABASE1
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

DATABASE2
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.