A company canteen needs an automated system for its food and beverage manageme

A company canteen needs an automated system for its food and
beverage
management. The canteen receives food and beverage items
from different
distributors. All the non perishable items are stored in the
store-room and the
perishable items are put in the fridge. The manager should
be able to add, delete
or update food and beverage items onto the system and
perishable and non
perishable item details are to be stored separately. Both
waiters and the cooks
should be able to update the perishable items, but only the
cooks should be
allowed to update the non perishable items. Both cooks and
waiters are not
allowed to add or delete any items that are entered.

identify the Schema, Table , Fields

Question Posted / rahul bisht

1 Answers
3278 Views
Accenture, I also Faced
E-Mail Answers

A company canteen needs an automated system for its food and beverage management. The canteen rece..

Answer / Shubham Goel

To design a database schema for this scenario, you can create two tables: one for non-perishable items and another for perishable items.

1) Non-Perishable Items Table:
- item_id (Primary Key)
- item_name
- description
- quantity_on_hand
- supplier_id
- purchase_date
- cost_price

2) Perishable Items Table:
- item_id (Foreign Key referencing non_perishable_items.item_id)
- expiration_date
- quantity_on_hand

With this schema, you can store the details of each food and beverage item separately, including their names, descriptions, quantities, costs, suppliers, and expiration dates (for perishable items). You can control access to update non-perishable items only for cooks, while allowing both cooks and waiters to update perishable items.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Engineering AllOther Interview Questions

can u tell me any JAM topics.........and answers also...plz send me.........e-mail: anitha839@gmail.com

1 Answers

write a programe to print this string in reverse order and find out how many times letter c is repeated? string = { c was desined by dennis ritchie}. also find out the lenth of the string.

1 Answers

how to join the pc to the domain?

1 Answers Aegis, jetking,

Dear frds In my office we are using chiller . in that chiller inlet and outlet water diff. is 2.5 decgree always. if i intduce the cooling tower can i get good result in chiller Inlet water. reply plz.

1 Answers

hai im going to face ibps SO IT officers grade 1 interview. if anyone had an idea plz tel me expected and experienced questions and mail to anusha_k_anu@yahoo.com

1 Answers

What is success factors online trainings?

1 Answers

What are daemon Threads?

1 Answers Impetus,

What do you mean by static routing and dynamic routing?

10 Answers IBM, Microsoft,

can u tell me what are the subjects involved in group I and II and how i prepare for the exam

1 Answers

in HVAC how does the chiller functioned .. and what is the chiller cyclic process

1 Answers

write a c programme to count the characters words and lines in a text book

1 Answers

What is candidate key ? What is Alter net key ? & What is foreign key ?

1 Answers Globsyn,

For more Engineering AllOther Interview Questions Click Here