SuperseMart was just a regular self-service market in the countryside. A year later, they became…

SuperseMart was just a regular self-service market in the countryside. A year later, they became one of the biggest supermarkets in the country. They even expanded as an eCommerce, covering nation-wide deliveries directly from the main warehouse. To ease their day-to-day tasks, they need an adequate but reliable system. And they need your help to realize the idea.

They only have one headquarter and one main warehouse and are located in the capital. They have lots of branch stores across the country. They get their goods from several suppliers and store them in the main warehouse. Periodically, they sent out goods to the branch stores.

Locations

There are 3 locations on which the application will be accessed from.

1. Headquarter (HQ)

There’s a manager in the HQ that is on top of the other managers. The manager will be able to monitor the WH, the online store, and all of the branch stores activities. The manager will require the system to be able to help to monitor these activities:

a. Online sales, which at least consists of buyer, order, final affected stocks, and revenue information. b. Online employee performances, which at least consists of employee, orders served by the employee, and goods served by the employee information.

c. Periodic report of both points but reported separately.

d. Monthly and annual cashflows.

e. Company financial situations.

Also residing in the HQ are employees that take care of the online store. They’re the ones receiving online orders and send out packages to the delivery couriers. The online orders are fulfilled directly from the main WH, because the buildings are located next to each other. The employees will need to interact with the system to receive online orders and process with the available goods stocks.

2. Main Warehouse (WH)

The WH will also be managed by a single person. The manager is responsible for anything happen inside the WH and the manager’s activities will also be monitored by the HQ. At the very least, she needs to be able to monitor these activities:

a. Goods procurements, which at least consists of supplier, procurement time, payment, and final affected stocks information.

b. Goods distributions, which at least consists of branch store destination, distribution time, and final affected stocks information.

c. Periodic report, which is the combination of both above points, to monitor goods flow.

Also working in the WH are employees that take care of goods procurements from suppliers and distributions to branch stores. They will need to interact with the system to update stocks amount with the appropriate goods received and distributed.

3. Branch Stores (BS)

Notice to plural notation. There are a lot of SuperseMart branch stores across the country, but they are treated equally. Each of the branch store is under the responsibility of a manager. They will be required to

monitor the store activities and make reports accordingly. Those reports also available to the HQ manager. The activities are:

a. Goods distributions, which at least consists of distribution time, receiving employee, and final affected stocks.

b. Store sales, which at least consists of serving employee, purchase time, order, final affected stocks, and revenue information.

c. Periodic report of both points but reported separately.

Also hired to do day-to-day basis of the store are several employees. Their job is to unload distributed goods and store them in the store warehouse, as well as take care of the store and serve customers. They will need to interact the system to update stocks amount and make sales.

Additional Notes

There are several conditions that you have to take into consideration.

1. Periodic reports are collected daily, weekly, monthly, and annually. It is possible to check past reports. 2. The managers might also want to make timely reports based on custom dates.

3. During goods handling and storing, it is possible for the goods to be damaged, and that will affect stocks and profit calculation.

4. All the managers and employees are professional, so they get paid by the company.

What to do

Do the following:

1. Make an ERD based on your understanding of the case.

2. Design a normalized database based on the ERD.


Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Online Academic Experts
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
History
Looks great and appreciate the help.
Customer 452675, April 26th, 2021
Psychology
quick and before due date/time.
Customer 453027, January 29th, 2022
Psychology
Received before the deadline. Great job!
Customer 453027, January 15th, 2022
Health Care
The writer did not follow my choice of topic (Food/Water Insecurity, Hunger, & Poverty), the paper was instead written about Climate Change in Africa. However, the paper was still great and informative. Thank you!
Customer 452777, January 28th, 2022
Nursing
Thank you so much for your help! :)
Customer 453167, May 11th, 2022
Nursing
I just need some minor alterations. Thanks.
Customer 452547, February 10th, 2021
IT, Web
Awesome paper in such a short amount of time. Was in a jam with another service who didn't deliver, but Theresa did the job correctly. I will use her again to do my essays for sure!
Customer 452967, November 27th, 2021
Professions and Applied Sciences
Thanks. This helps a lot. Was a bit late but some cushion was given.
Customer 453015, February 10th, 2022
Education
N/A
Customer 453057, May 23rd, 2022
Humanities
Thank youuuu
Customer 452729, May 30th, 2021
History
Don't really see any of sources I provided, but elsewise its great, thank you!
Customer 452697, May 8th, 2021
Management
Love this writer!!! Great work
Customer 452597, April 5th, 2021
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Live ChatWhatsApp