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
- 1 Answers
- 3279 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
sir, plz send me the question regarding DMS gr1 questions of previous year as my exam is on 27/09/08...thanking u in advance...
can anybody send me the technical papers of hewitt associates pls...I cleared aps n GD n has only less time for technical round?
hai iam selected in po exam in allahabad bank . my interview date is 02-06-2009. so plese send me some sample question on my email. my email is nitinbikhani@yahoo.com
what is total power generation capacity in india at present (as on 12-12-2011)
please send me latest Aptitude Test paper
sir, please send me the last three years exam papers conducted by CPCL- RECRUITMENT EXAM FOR Recruitment of Engineer ELECTRICAL ENGINEERING. A Soon as possible. i would be greatfull to u
What is Campus selection process of patni at Adcet,Ashta at 24th dec 2010.Also give apti syllabus.
Please send me Sample papers National Informatics Centre (NIC) Programmer. I am giving this paper first time..so if any one have previous question papers send to manoj200.yadav@gmail.com. thnx in advance
Draw the diagram showing the function stack, illustrating the variables that were pushed on the stack at the point when function f2 has been introduced . type def struct { double x,double y} point; } main( int argc, char *arg[3]) { double a; int b,c; f1(a,b); } f1(double x, int y) {point p; stack int n; f2(p,x,y) } f2(point p, double angle) { int i,j,k,int max;
Can anyone send me iocl written test paper fro computer engineers
consiteunts of indian railways
hi, please send me "state bank of india", last 5 years question paper with answers to my mail id.
who is your favourate actor in tollywood tellme about him in few points
how to create user name stape by stape in cisco router {with command}
can you provide me uniken pvt ltd. technical interview question and answer?
