Deliverable #4

Description:

• Deliverable 4: Construct food item' table with real restaurant's menu

Some sample mySQL statements:

Insert a new Restaurant:

INSERT INTO `fooddata`.`restaurant` (
`ResName` ,
`UsrName` ,
`ResLoc` ,
`ResRate` ,
`ResPhone` ,
`ResMonOpen` ,
`ResMonClose` ,
`ResTueOpen` ,
`ResTueClose` ,
`ResWedOpen` ,
`ResWedClose` ,
`ResThuOpen` ,
`ResThuClose` ,
`ResFriOpen` ,
`ResFriClose` ,
`ResSatOpen` ,
`ResSatClose` ,
`ResSunOpen` ,
`ResSunClose` 
)
VALUES (
'pho queen noodle house', 'Kelly', '1133 Tasman drive, Sunnyvale, CA94089', '3', '4087457753', '9', '21', '9', '21', '9', '21', '9', '21', '9', '21', '9', '21', '9', '21'
);

Insert a new Food item:

INSERT INTO `fooddata`.`food` (
`FoodName` ,
`FoodPrice` ,
`FoodRate` ,
`ResName` ,
`ResLoc` ,
`UsrName` 
)
VALUES (
'Jumbo shrimps, jumbo crab claw, pork & chicken (Dry or Soup with thin rice noodle)', '8.75', '4.5', 'pho queen noodle house', '1133 Tasman drive, Sunnyvale, CA94089', 'Kelly'
);

Insert a new User:

INSERT INTO `fooddata`.`usr` (
`UsrName` ,
`UsrPhone` ,
`role` ,
`UsrLoc` 
)
VALUES (
'Angela', '4082593876', '1', 'Siant Lucia street, San Jose, CA 95127'
);