College of Computing, Informatics and Media

Bachelor of Information Science (Hons) Information Systems Management

(IM245)

Database Application for Information Management

(IMS506)

Group Assignment:

Database Design & Development

Prepared By:

Nadhratul Husna binti Khamarol Nizam 2022498402

Nur Dini binti Roslan 2022615492
Umi Nadirah binti Rosman 2022864144

Prepared For:

Husain bin Hashim

Submission Date:
12 February 2023
 Group Assignment:

Database Design & Development

Prepared By:

Nadhratul Husna binti Khamarol Nizam 2022498402

Nur Dini binti Roslan 2022615492
Nur Umi Nadirah binti Rosman 2022864144

College of Computing, Informatics and Media,

University Technology Mara, Puncak Perdana

Campus
 TABLE OF CONTENT

Acknowledgement i
Table of content ii

1.0 INTRODUCTION
2.0 BUSINESS ACTIVTIES / PROCESS
3.0 PROBLEM STATEMENT
4.0 OBJECTIVES
5.0 BUSINESS RULES
6.0 ENTITY RELATIONSHIP
7.0 CONCEPTUAL RED
8.0 NORMALIZATION
9.0 RELATIONAL DIAGRAM
10.0 DATA DICTIONARY
11.0 CONCLUSION
12.0 LIMITATION & FUTURE ENHANCEMENT
13.0 REFERENCES
1.0 INTRODUCTION
ZUS Coffee has expanded greatly since its 2019 inception, and it could not
have done it without all its beloved customers.
ZUS Coffee's goal has always been to make specialty coffee accessible to
everyone as a daily necessity. Specialty coffee is frequently regarded by many as a
luxury, something people indulge in on special occasions. They sought to alter this
impression. ZUS Coffee is a pure, reliable, and expertly brewed coffee. Designers are
revolutionizing the way people consume coffee by using the highest-quality
ingredients, cutting-edge coffee brewing technology, and an inventive business
strategy to make specialty coffee accessible to everyone daily.
ZUS Coffee can only thank ZUS’s customer for all its accomplishments thus
far, as they have supplied more than 8.8 million cups. ZUS Coffee were inspired to
uphold its promise to the customers and make sure that ZUS Coffee is always a
Necessity, not a Luxury, by the customer's incredible loyalty and support.

2.0 BUSINESS ACTIVITIES / PROCESS

Gigi Coffee engages in a variety of business activities to ensure the smooth
operation of their business. To begin, we can see that Gigi coffee is very concerned
with quality ingredients. This proves that they receive the best product from the
supplier. The activities conducted are supplier supply products. In addition, they
receive orders from customers both online and in person. This enables them to interact
with customers and provide them with services. They also have a website where
customers can ask them questions and provide feedback. As a result, we created a
database that allows Gigi Coffee to better manage their business by knowing and
controlling information about customers, drinks, orders, and payments. As a result,
their employees will be able to This will cause their staff to be able to know and
manage their business better. Customers will also get benefits such as their orders will
arrive at a fast rate without any problems
3.0 PROBLEM STATEMENT
 Storage of supplier information is difficult.
 The staff had a tough time locating the customer information.
 There seems to be no system to store customer information.
 Customers get slow messages about the problem of missing customer information or
there is a problem.

4.0 OBJECTIVES
 To store all the information of the suppliers which supply all the
ingredients to the store.
 To create a proper database which help staff in retrieving customer’s
data more quickly.
 To create a database which will store all the customer’s data and compute
purchases of each product that have been made in the store.
 To manage and administrate the Gigi Coffee’s database regarding
customers and purchase transactions.
5.0 BUSINESS RULES
Business rules are developed from a detailed description of an organization's
operations and are used to define and enforce behaviors inside the organization's
environment. It defines entities, their attributes, their relationships, and their
restrictions. The database designer must understand the organization's data to
establish an acceptable data model. The business rules are critical to the designer's
grasp of how the company runs and the role that data plays in business operations.
The database's business rules are as follows:

i. Customer order drink

ONE customer order ONE drink (1: 1)

MANY customers order ONE drink (M: 1)

ONE customer orders MANY drinks (1: M)

MANY customers order MANY drinks ( M : N)

ii. Customer make payment

ONE customer pay ONE drink (1: 1)

MANY customers pay ONE drink (M: 1)

ONE customer pay MANY drinks (1: M)

MANY customers pay MANY drinks ( M : N)

iii. Customer wait for order list

ONE customer pay ONE drink (1: 1)

MANY customers pay ONE drink (M: 1)

ONE customer pay MANY drinks (1: M)

MANY customers pay MANY drinks ( M : N)

6.0 ENTITY RELATIONSHIP DIAGRAM (ERD from each BR)

 NO. ENTITIES ATTRIBUTE

 Cust_ID
CUSTOMERS  Cust_Name
 Cust_Contact
1.
 Cust_Address

 Drinks_Code
DRINKS  Drinks_Name
 Drinks_Size
2.
 Drinks_Price
 Drinks_Description

 Order_ID
ORDER  Cust_ID
 Order_Total
3.
 Order_TotalPrice

 List_Code
ORDER_LIST  Order_ID
 Drinks_Code
4.
 Create_At

 Payment_ID
PAYMENT  Order_ID
 Payment_Method
5.
 Payment_TotalPrice
 Payment_Timestamp
Diagram 1: Entity Relationship Diagram (ERD)