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.
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 aliquetm ipsuma. Fusce dui lectuslestie consequat, ulet, consectetur
nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consa 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
435,535 students got unstuck by Course
Hero in the last week
Our Expert Tutors provide step by step solutions to help you excel in your courses