During this COVID-19 pandemic era, Salmahs business is booming. While others have suffered losses from the reduction of volumes in sales, Salmahs sales, however are sky-rocketing. Her online business which were set up a few years back, with the help of Raihana, has received large numbers of orders. She is very happy to receive advice from Raihana to concentrate on business selling various type of masks and sanitizers. However, she has problem keeping track of the large number of orders she received from her customers. For the past few weeks, she received more and more complaints from her staff stating that they do not have enough goods in hand to cater large volume of orders. There are also events where some customers received wrong items, wrong amount, or shipments were sent to different addresses. Thus,

this lead to some cancelled orders by her customers. When she started her business a few months ago, she kept her customers details in

a simple spreadsheet. When her business grows, she needs to properly manage not only her customers details but other relevant information for her business transactions. Upon hearing Salmahs problem, Raihana suggest some recommendations. She has heard of database before and suggested for Salmah to find someone who knows and can create a database for her business.

REQUIRED:

However, information collected will be easier to be visualized using the ERD as compared to database management system. Briefly explain what ERD is and shows an example of (any) connection between entities/tables, complete with the attributes (any eight) within the relational tables for Salmahs business operation.