create ER-diagram for the following system Snatch n Grab is a small groceries store, which has been getting a lot of attention recently, and the...
This question has been answered
Question

create ER-diagram for the following system

Snatch n Grab is a small groceries store, which has been getting a lot of attention recently, and the

owner has decided to expand his business.

The owner has requested you to create an Inventory Management System for his store. This system

will allow his employees to manage the store's inventory, and should contain the following features:

• Allow entry of new items

• Categorize items into groups, such as dairy/produce/fruits/vegetables etc.

• Allow entry of suppliers

• Allow entry of shipments

• Automatic request for restocking inventory

The way the store operates, is that after a deal is made between the store and a supplier, the supplier is

assigned certain items from the inventory. The supplier is then responsible for maintaining the stock

of said items in the store. Previously, the employees had to manually request the suppliers to restock

their items, but the owner wishes your application will be able to automate this process.

Multiple suppliers send multiple shipments, which contain multiple items for the store. All this need

to be organized and maintained.

Once the items reach the store, they are placed in appropriate counters, where customers may pick

them up and buy them. When a customer makes a purchase, the store records which item was sold and

when, and if the item inventory reaches a certain threshold (can be different per item), a request for

restock is generated.

If a new item is provided to the store, it needs to be cataloged along with its category, and sub category,

and then assigned to a supplier, and then finally confirm inventory size for the shop.

Answered by Expert Tutors

icitur


facilisis. Pellentesque dapibus e


cing elit. Nam lacinia pulvinar tortor nec faci

ng elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam r

Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet
Step-by-step explanation

ER Diagram.PNG






m ipsuma. Fusce dui lectuslestie consequat, ulet, consectetur

nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie cons
1 Attachment
ER Diagram.PNG
PNG
The student who asked this found it Helpful
Overall rating 100%
Other answer

a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vi

pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolo
Step-by-step explanation

1.jpg

congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui
1 Attachment
1.jpg
jpg
The student who asked this found it Unhelpful
Overall rating 0%
Get unstuck

435,535 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses