https://supernalgun446.weebly.com/blog/central-intelligence-full-movie-free-download. Find and compare Restaurant Management software. Free, interactive tool to quickly narrow your choices and contact multiple vendors. Cloud based Restaurant inventory management software and app. MarketMan gives you the tools you need to manage your inventory, suppliers, orders, and menu costing. https://lightingsupernal.weebly.com/blog/authentic-success-robert-holden-pdf-to-excel. Restaurant management project is a desktop application which is implemented in VB platform.Free download Restaurant management VB project with source code, Document, Reports, synopsis.Restaurant management source code in vb and database is ms access used.Free download VB project tutorial.
- Hospital Management Software In Pakistan
- Free Restaurant Management Software In Vb Net Database Download
Xforce keygen autocad 2014 64 bit windows 8 free download. https://cleverteacher939.weebly.com/blog/lands-of-lore-download-mac. Free Restaurant Management Software In Vb Net Tutorial Visual Basic. How to Create a Stock Management Database in Microsoft Access - Full Tutorial with Free. Restaurant Management system vb net. Human Resource Management system is a VB.NET project. Human Resource Management System VB.NET Project. Free Visual Basic.NET Course. VB.Net allows you many ways to connect to a database or a data source. The technology used to interact with a database or data. This project is written using VB.NET and SQL. Restaurant Management Ordering System. Boris becker 11 special edition feedback. Contribute to rishirajsinghjhelumi/Restaurant-Management-Ordering-System development by creating an account on GitHub.
PermalinkJoin GitHub today
Agile software development company noida news. GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together. https://thisburn.weebly.com/home/old-movie-countdown-download-mac.
Sign up Find file Copy path
1 contributor
dropdatabase if exists `restaurant`; |
createdatabase `restaurant`; |
use `restaurant`; |
droptable if exists `USER`; |
createtable `USER`( |
`User_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(50) NOT NULL, |
`Lname`varchar(50) NOT NULL, |
`Password`varchar(50) NOT NULL, |
PRIMARY KEY (`User_Id`) |
)ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `RESTAURANT`; |
createtable `RESTAURANT`( |
`Name`varchar(100) NOT NULL, |
`Location`varchar(100) NOT NULL, |
`Contact`varchar(100) NOT NULL, |
`Opening_Closing_Time`varchar(100) NOT NULL, |
`Details`varchar(500) default NULL, |
PRIMARY KEY (`Name`) |
)ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `OWNER`; |
createtable `OWNER`( |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(100) NOT NULL, |
`Rest_Name`varchar(100) NOT NULL, |
PRIMARY KEY (`Fname`,`Lname`,`Contact`), |
FOREIGN KEY (`Rest_Name`) REFERENCES`RESTAURANT`(`Name`) |
ONUPDATE CASCADE |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `BILL`; |
createtable `BILL`( |
`Order_Id`intNOT NULL AUTO_INCREMENT, |
`Customer_Fname`varchar (20) NOT NULL, |
`Customer_Lname`varchar (20) NOT NULL, |
`Customer_id`intNOT NULL, |
`Total_Amount` double NOT NULL, |
PRIMARY KEY (`Order_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `MENU_BILL`; |
createtable `MENU_BILL`( |
`Order_Id`intNOT NULL, |
`Name`varchar(100) NOT NULL, |
`Quantity`varchar(20) NOT NULL, |
`Price`varchar(20) NOT NULL, |
FOREIGN KEY(`Order_Id`) REFERENCES`BILL`(`Order_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `CUSTOMER`; |
createtable `CUSTOMER`( |
`Customer_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) DEFAULT NULL, |
`Email_Id`varchar(50) DEFAULT NULL, |
PRIMARY KEY (`Customer_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `MANAGER`; |
createtable `MANAGER`( |
`Manager_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Address`varchar(30) DEFAULT NULL, |
`Salary`varchar(30) DEFAULT NULL, |
`Sex`char(1) DEFAULT NULL, |
`Bdate`date DEFAULT NULL, |
`Join_Date`dateNOT NULL, |
PRIMARY KEY (`Manager_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `WAITER`; |
createtable `WAITER`( |
`Waiter_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Address`varchar(30) DEFAULT NULL, |
`Salary`varchar(30) DEFAULT NULL, |
`Sex`char(1) DEFAULT NULL, |
`Bdate`date DEFAULT NULL, |
`Join_Date`dateNOT NULL, |
PRIMARY KEY (`Waiter_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `CASHIER`; |
createtable `CASHIER`( |
`Cashier_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Address`varchar(30) DEFAULT NULL, |
`Salary`varchar(30) DEFAULT NULL, |
`Sex`char(1) DEFAULT NULL, |
`Bdate`date DEFAULT NULL, |
`Join_Date`dateNOT NULL, |
PRIMARY KEY (`Cashier_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `COOK`; |
createtable `COOK`( |
`Cook_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Address`varchar(30) DEFAULT NULL, |
`Salary`varchar(30) DEFAULT NULL, |
`Sex`char(1) DEFAULT NULL, |
`Bdate`date DEFAULT NULL, |
`Join_Date`dateNOT NULL, |
`Specialization`varchar(50) DEFAULT NULL, |
PRIMARY KEY (`Cook_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `HOME_DELIVERY`; |
createtable `HOME_DELIVERY`( |
`Delivery_Id`intNOT NULL AUTO_INCREMENT, |
`Address`varchar(50) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Cust_Id`intNOT NULL, |
`Order_Id`intNOT NULL, |
PRIMARY KEY(`Delivery_Id`), |
FOREIGN KEY (`Cust_Id`) REFERENCES`CUSTOMER`(`Customer_Id`), |
FOREIGN KEY (`Order_Id`) REFERENCES`BILL`(`Order_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `DELIVERY_BOY`; |
createtable `DELIVERY_BOY`( |
`Delivery_Boy_Id`intNOT NULL AUTO_INCREMENT, |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Address`varchar(30) DEFAULT NULL, |
`Salary`varchar(30) DEFAULT NULL, |
`Sex`char(1) DEFAULT NULL, |
`Bdate`date DEFAULT NULL, |
`Join_Date`dateNOT NULL, |
PRIMARY KEY (`Delivery_Boy_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `DELIVERY_BOY_2`; |
createtable `DELIVERY_BOY_2`( |
`Boy_Id`intNOT NULL, |
`Delivery_Id`intNOT NULL, |
FOREIGN KEY (`Boy_Id`) REFERENCES`DELIVERY_BOY`(`Delivery_Boy_Id`), |
FOREIGN KEY (`Delivery_Id`) REFERENCES`HOME_DELIVERY`(`Delivery_Id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `MENU`; |
createtable `MENU`( |
`Menu_Id`intNOT NULL AUTO_INCREMENT, |
`Name`varchar(100) NOT NULL, |
`Price`varchar(20) NOT NULL, |
`Type`varchar(20) DEFAULT NULL, |
`Category`varchar(30) NOT NULL, |
PRIMARY KEY(`Menu_Id`,`Name`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `SALE_DETAIL`; |
createtable `SALE_DETAIL`( |
`Date`dateNOT NULL, |
`Daily`intNOT NULL, |
`Weekly`int DEFAULT NULL, |
`Monthly`int DEFAULT NULL, |
`Rname`varchar(30) DEFAULT NULL |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `SUPPLIER`; |
createtable `SUPPLIER`( |
`Fname`varchar(15) NOT NULL, |
`Lname`varchar(15) NOT NULL, |
`Address`varchar(30) NOT NULL, |
`Contact`varchar(20) NOT NULL, |
`Details`varchar(500) DEFAULT NULL, |
PRIMARY KEY (`Fname`,`Lname`,`Address`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `TABLES`; |
createtable `TABLES`( |
`Table_Number`varchar(9) NOT NULL, |
`Details`varchar(200) DEFAULT NULL, |
PRIMARY KEY (`Table_Number`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `BOOKING`; |
createtable `BOOKING`( |
`Booking_Id`intNOT NULL AUTO_INCREMENT, |
`Table_Num`varchar(30) NOT NULL, |
`Date`varchar(30) NOT NULL, |
`Time`varchar(30) NOT NULL, |
`Cust_Id`intNOT NULL, |
PRIMARY KEY (`Booking_Id`), |
FOREIGN KEY (`Cust_Id`) REFERENCES`CUSTOMER`(`Customer_Id`), |
FOREIGN KEY (`Table_Num`) REFERENCES`TABLES`(`Table_Number`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
droptable if exists `INGREDIENT`; |
createtable `INGREDIENT`( |
`Ingredient_Id`intNOT NULL AUTO_INCREMENT, |
`Name`varchar(30) NOT NULL, |
`Quantity`varchar(15) NOT NULL, |
`Description`varchar(100) DEFAULT NULL, |
`Supp_Name`varchar(50) NOT NULL, |
PRIMARY KEY (`Ingredient_Id`,`Name`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
insert into`RESTAURANT`(`Name`,`Location`,`Contact`,`Opening_Closing_Time`,`Details`) |
values |
('Tandoori By Nature','Gandhi Nagar Jammu And Kashmir','09642540626/09581871321','10:00 AM - 12:00 AM','None'); |
insert into`OWNER`(`Fname`,`Lname`,`Contact`,`Rest_Name`) |
values |
('Yash','Vadalia','9999999999','Tandoori By Nature'); |
insert into`MANAGER`(`Fname`,`Lname`,`Contact`,`Address`,`Salary`,`Sex`,`Bdate`,`Join_Date`) |
values |
('Rishi Raj','Singh Jhelumi','9642540626','E-28 OBH , IIIT Hyderabad','30000','M','1992-09-29','2012-08-01'), |
('Prachish','Gora','9581871321','E-27 OBH , IIIT Hyderabad','30000','M','1993-11-18','2012-08-01'); |
insert into`WAITER`(`Fname`,`Lname`,`Contact`,`Address`,`Salary`,`Sex`,`Bdate`,`Join_Date`) |
values |
('Raghav','Sharma','123456','E-22 OBH , IIIT Hyderabad','8000','U','1993-10-12','2012-08-01'), |
('Rishav','Kumar','132244','E-28 OBH , IIIT Hyderabad','8000','M','1992-12-22','2012-08-01'), |
('Vinil','Narang','213122','E-27 OBH , IIIT Hyderabad','8000','M','1993-05-12','2012-08-01'), |
('Bharat','Jain','121232','E-26 OBH , IIIT Hyderabad','8000','M','1992-03-12','2012-08-01'), |
('Megan','Fox','213122','Hollywood USA','9000','F','1986-10-13','2012-08-01'), |
('Sunny','Leone','323322','Bollywood INDIA','9000','F','1982-10-13','2012-08-01'); |
insert into`CASHIER`(`Fname`,`Lname`,`Contact`,`Address`,`Salary`,`Sex`,`Bdate`,`Join_Date`) |
values |
('Abhinav','Mittal','124142','E-19 OBH , IIIT Hyderabad','12000','M','1993-11-30','2012-08-01'), |
('Sanchit','Gangwar','113332','E-24 OBH , IIIT Hyderabad','12000','M','1993-02-21','2012-08-01'), |
('Abhishek','Kumar','122121','E-25 OBH , IIIT Hyderabad','12000','M','1992-07-21','2012-08-01'); |
insert into`COOK`(`Fname`,`Lname`,`Contact`,`Address`,`Salary`,`Sex`,`Specialization`,`Bdate`,`Join_Date`) |
values |
('Bhavshuk','Jindal','123211','E-18 OBH , IIIT Hyderabad','15000','M','Maggi','1992-08-02','2012-08-01'), |
('Japneet','Singh','231312','E-19 OBH , IIIT Hyderabad','15000','M','Samosa','1992-10-12','2012-08-01'), |
('Dinesh','Singla','874594','E-18 OBH , IIIT Hyderabad','15000','M','Omlette','1992-03-14','2012-08-01'), |
('Siddharth','Sinha','587654','E-26 OBH , IIIT Hyderabad','15000','M','Bonda','1992-01-01','2012-08-01'), |
('Himanshu','Aggarwal','142355','E-24 OBH , IIIT Hyderabad','15000','M','Jalebi','1992-02-22','2012-08-01'), |
('Priya','Rai','897933','HOLLYWOOD USA','15000','F','None','1980-01-02','2012-08-01'); |
insert into`DELIVERY_BOY`(`Fname`,`Lname`,`Contact`,`Address`,`Salary`,`Sex`,`Bdate`,`Join_Date`) |
values |
('Tarang','Goyal','133132','E-17 OBH , IIIT Hyderabad','10000','M','1993-02-21','2012-08-01'), |
('Saksham','Maheshwari','657569','E-17 OBH , IIIT Hyderabad','10000','M','1992-10-21','2012-08-01'), |
('Rajat','Agarwal','596509','E-16 OBH , IIIT Hyderabad','10000','M','1993-02-21','2012-08-01'), |
('Vidit','Bhaskar','344244','E-15 OBH , IIIT Hyderabad','10000','M','1993-10-22','2012-08-01'); |
insert into`MENU`(`Name`,`Price`,`Type`,`Category`) |
values |
('Vegetable Pakora','3.00','Veg','Starters'), |
('Vegetable Samosa','3.00','Veg','Starters'), |
('Onion Bhaji ','3.00','Veg','Starters'), |
('Potato and Mushroom Chaat','3.00','Veg','Starters'), |
('Mushroom Garlic Fry','3.00','Veg','Starters'), |
('Chicken Tikka','4.00','Non-Veg','Starters'), |
('Tandoori Chicken','4.00','Non-Veg','Starters'), |
('Chicken Garlic Fry','4.00','Non-Veg','Starters'), |
('Chicken Tikka on Puree','4.00','Non-Veg','Starters'), |
('Lamb Tikka','4.00','Non-Veg','Starters'), |
('Tandoori King Prawn','6.95','Non-Veg','SeaFood'), |
('King Prawn Rosun','5.95','Non-Veg','SeaFood'), |
('King Prawn on Puree','5.95','Non-Veg','SeaFood'), |
('Prawn Bhuna on Puree','3.95','Non-Veg','SeaFood'), |
('Prawn Cocktail','3.95','Non-Veg','SeaFood'), |
('Chi/Lam Sashlik Chi','9.95','Non-Veg','Tandoori Specials'), |
('Tandoori Deluxe','12.95','Non-Veg','Tandoori Specials'), |
('Tandoori Chicken Main','9.95','Non-Veg','Tandoori Specials'), |
('Chicken Tikka','7.95','Non-Veg','Tandoori Specials'), |
('Lamb Tikka','9.95','Non-Veg','Tandoori Specials'), |
('Bombay Aloo ','6.50','Veg','Vegetable Dishes'), |
('Mushroom Bhaji ','6.50','Veg','Vegetable Dishes'), |
('Saag Dall','6.50','Veg','Vegetable Dishes'), |
('Mattor Paneer','6.50','Veg','Vegetable Dishes'), |
('Vegetable Roshun','6.50','Veg','Vegetable Dishes'), |
('Boiled Rice','2.50','Veg','Side Orders - Rice'), |
('Keema Pilau Rice','3.50','Non-Veg','Side Orders - Rice'), |
('Mushroom Rice','3.20','Veg','Side Orders - Rice'), |
('Garlic Naan','3.00','Veg','Side Orders - Bread'), |
('Stuffed Naan','3.50','Veg','Side Orders - Bread'), |
('Chapati','1.00','Veg','Side Orders - Bread'), |
('Green Salad','2.00','Veg','Side Orders - Sundries'), |
('Spice Popadum','0.80','Veg','Side Orders - Sundries'), |
('Chutney','0.70','Veg','Side Orders - Sundries'), |
('Ras Malai','2.95','Veg','Dessert'), |
('Ice Cream','2.95','Veg','Dessert'), |
('Gulab Jamun','2.95','Veg','Dessert'), |
('Kulfi','2.95','Veg','Dessert'), |
('Kheer','2.95','Veg','Dessert'); |
insert into`SUPPLIER`(`Fname`,`Lname`,`Address`,`Contact`,`Details`) |
values |
('Varun','Vashisht','E-121 OBH , IIIT Hyderabad','123211','Provides Non-Veg Stuff.'), |
('Aneeq','Dholakia','E-15 OBH , IIIT Hyderabad','678668','Provides Sea Food.'), |
('Sharad','Gupta','E-16 OBH , IIIT Hyderabad','856855','Provides Grocery.'); |
insert into`TABLES`(`Table_Number`,`Details`) |
values |
('1','Capacity 4 People'), |
('2','Capacity 4 People Near Window'), |
('3','Capacity 3 People'), |
('4','Capacity 2 People'), |
('5','Capacity 8 People Family Table'); |
insert into`CUSTOMER`(`Fname`,`Lname`,`Contact`,`Email_Id`) |
values |
('Arpit','Sharma','938912','[email protected]'), |
('Yash','Shah','289374','[email protected]'), |
('Darshit','Serna','234322','[email protected]'), |
('Aditya','Sharma','778989','[email protected]'), |
('Pallav','Shah','364932','[email protected]'), |
('Rajat','Bharadwaj','734277','[email protected]'), |
('Achintya','Madhav','347534','[email protected]'); |
insert into`USER`(`Fname`,`Lname`,`Password`) |
values |
('admin','admin','admin'), |
('Akhil','Jindal','cheetah'), |
('Deepak','Goyal','manga'), |
('RoopGUN','Deeep','sodhi'); |
Copy lines Copy permalink
![Management Management](/uploads/1/3/3/2/133276012/773941074.jpg)
ManageEngine Applications Manager provides deep-dive performance monitoring for 100+ business applications, spanning physical, virtual and cloud environments. Additionally, it tracks the end-user experience of web applications running on Java, .NET, and Ruby on Rails platforms. More than 5000 businesses around the world use Applications Manager to quickly detect, isolate and resolve performance issues, effectively plan capacity and ensure optimal performance of their applications. Learn more about ManageEngine Applications Manager
Ensure your mission-critical business applications meet end-user expectations with 360-degree monitoring from Applications Manager. Learn more about ManageEngine Applications ManagerHospital Management Software In Pakistan
![Free restaurant management software in vb net database software Free restaurant management software in vb net database software](/uploads/1/3/3/2/133276012/706302000.jpg)
Free Restaurant Management Software In Vb Net Database Download
ManageEngine Applications Manager provides deep-dive performance monitoring for 100+ business applications, spanning physical, virtual and cloud environments. Additionally, it tracks the end-user experience of web applications running on Java, .NET, and Ruby on Rails platforms. More than 5000 businesses around the world use Applications Manager to quickly detect, isolate and resolve performance issues, effectively plan capacity and ensure optimal performance of their applications.