5/7/2025
Design, Creating Documentation &
Database Design & Development
Moe Kaung Kin
Gusto college
HND-67 Moe Kaung Kin
Table of Contents
INTRODUCTION........................................................................................................................................................ 2
DEFINITION OF DATABASE.................................................................................................................................. 3
1
HND-67 Moe Kaung Kin
Introduction
“Aurora” is a successful garment factory, from beginning to end, from initial design to finished
product, from raw materials such as cotton, polyester, and then yarn to fabric, shape, quality
control, fashion designers draw the design, cut the pattern using cutting machine, sewing to
combine with collars, pockets, logos and brands, printing, etc. It is a factory that produce various
categories or clothing in large scale. Aurora is a large factory, so it has many important equipment
such as cutting machines, sewing machines, pressing machines, quality inspection system.
These equipment play an important role in production process and are used every day, so regular
machine inspections must be carried out. When doing so, if a production machine is defective the
employee must immediately inform machine team. This team also prepares & should immediately
investigate and find out what the problem is.
Otherwise, equipment may be damaged and production volume may be reduced, even if thousand
of pieces of clothing are produced. After repair, a respective inspector must verify whether the
machine is actually working. The faulty equipment must be replaced and then allowed to be used
only after the inspection.
I am a senior database developer at Aurora company, and I have been assigned to design and
implement a database that can meet a following requirement,
I. To effectively monitor a maintenance records of equipment
II. Ensure efficient executing of machine maintenance tasks
III. Reduce machine downtime
IV. Optimizing operational cost
2
HND-67 Moe Kaung Kin
Definition of Database
Before designing database, I will first explain what a database is. Is essentially a place where data
is systematically and properly organized and stored. To put it simply, in real life, it is similar to
keeping files and documents together in one place. But in this case, data is stored inside a
computer, so you can easily search for it using keywords, edit it, and use it whenever you need.
As a senior database developer, relational database I will be creating is a system where data is
stored in tables. These tables are connected to each other in a way that build the information easy
to understand at a glance.
In assignment-1, a goal is to design a database that will store all of records related to maintenance
of machine & equipment for Aurora company.
3
HND-67 Moe Kaung Kin
4
HND-67 Moe Kaung Kin
