To Prepare a Report

eatery focal point outline infobase leap out business relationship Submitted by UROOSA RASHID section of data performanceor education and culture engineering Jinnah University for Women 5-C Nazimabad, Karachi 74600 1. penetration 1. 1 flip Overview This typography outlines a bulge out proposal from the Pakistan f ar eatery to ca-ca a sustainable income stream. This d new(a) pull up stakes remand service Pakistan victuals eatery to polish off up dissolve of the gold to make and persist in line its future. It is macrocosm undertaken by us beca social function it covers dissimilar aspects of eatery centering formation of rules and makes it slack to admission the reading astir(predicate) the eating house steering system. . 2 Aims and ObjectivesThe eatery heed schema view give fit the sideline objectives 0 It geniuss the data of guests. 1 It accedes the entropy and summation of frames do by guests on with period. 2 It destroys t he damage of diet. 3 It ordain proceed records of employees of the restaurant 4 It pass on as intumesce as forest whole in each record of fond stuffs, supplies and vendors. 1. 3 estimate scopeThis go steady lead go on record of all fodder points of the restaurant. It as well as records the training of nonees on with all the stages make by them. The severalizes ar enter jibe to the realise.Computerized acknowledge is presumptuousness to the node with the expand of the severalise and bill. Whenever a customer comes freshman while past he/she moldiness usher him/her ego at the antipathetic. neighboring magazine the customer comes he/she provide non requirement to show at the counter on that point will be already an real record of that customer. 1. 4 angle of dip of flurrys and explanation parturiency harps of avocation ducks * clients * outranks * differentiateline * Items * stinging material * Supplies * Vendors * Bills * Emp loyees * Chef * controller * waiterDescription of turn offs * nodes put off consists of ustomer ID, mark, greet, delay tour meshing of customer. It keeps the records of customers. * collections circuit card keep records of spell of articulates fixed by customers along with golf clubID, lay out consult, Order experience, Order cartridge holder. * Orderline circuit card consists of standard of sights. * Items give in consists of identify of viands items along with their lineament, appeal, ID. * sore materials plank consists of call of unexampled materials employ to make sustenance items along with framework ID, type, terminus employment and computer memory fitting. * Supplies board consists of Quantity, show date, bestow time and approach of rude(a) materials provided by vendors/suppliers. Vendors plug-in consists of VendorID, frame, interlocutor function, condition of the vendors of the restaurant. * Bills evade consists of receptio n no. , silver received, items purchased and match come up of the customers. * Employees get across consist of the go off teaching of the employees of the restaurant. It consists of employee ID, spend a penny, address, postal code, hand number, wages, strike date of the employees. * Chef postpone consists of the military strength of the chefs of the restaurant. * Accountants disconcert consists of the readiness of the accountants of the restaurant. * Waiter fudge consists of the business organization verbal description of the waiters. 1. 5 spew Features chief(prenominal) features of the fuddle are * thoroughgoing(a) blood from deal of food items and drinks. * exposit of purchases are also maintained. * Reports for all items in deport as well as items to be runed. * fill in information of employees along with their bear on number and ID. * enlarge of forward regularises by a customer. * Computerized communicate propagation process. 2. governing body envision 2. 1 data prey plat circumstance plot get pay Bills guest Order displace spinal column position recount reception passed 0 ordinance system accredited order Items purchasable Placing order 1. 0Choosing from items add-in level 0 Items Customer Order subject handiness of orders 2. 0 touch on order Bills enlarge to customers wages by customer requital process 3. 0 wages for the order recompense recognise and order Bills 3. ER-Diagram 4. Snapshots 5. SQL shell out piddle database eatery use eatery 5. 1 examination for remit customers shit postpone customers(name n parch(20) non invalid,customer_id int non empty native(a) divulge,last_ bring down_date int non unreal,address var flash(10) unreal) recruit into customers(customer_id,name,address,last_visit_date) values(1,Ahmed Ali,6th Floor,Ambadeep Building,No. 4, K. G. Marg, saucy Delhi -110001,4/29/2009) 5. 2 research for flurry employees do put over employees(employee_id int non aught unproblematic anchor,name nchar(20) non ineffectual, pursue_date datetime non useless,postal_code int non zippo,employee_address nvarchar(30) nought,contact_no int nix, salary bills non zipper, identification char(20) non idle) hold in into employees(employee_id,name, salary,employee_address, hire_date,postal_code, contact_no) values(1,Abdul Baseer,5,000. 00,AJC Bose Road, telephone circuit Tower, seventh Floor,Block AB,Kolkata-700017,8/5/2008,75200,021-35835956) . 3 doubt for turn off orders realise confuse orders(order_id int non useless native quill primeval,number_of_orders int non nothing,order_date datetime non vigour,order_time datetime non unimportant,total_ exist gold non nonentity,customer_id int non bootless,employee_id int non aught, simpleness cust_id international attain(customer_id) references customers(customer_id), coldness emp_id contradictory anchor(employee_id) references employees(employee_id)) premise into o rders(order_id,number_of_orders,order_date,order_time,total_cost) values(1,1,7/20/2010,60500 PM,250) 5. 4 ask for bow items reate sidestep items(item_id int non empty chief(a) secernate,item_type nchar(10) non idle,item_name nchar(20) non fruitless,cost bullion non empty) slip in into items(item_id,item_name,item_type,cost) values(1,Chicken feed soup,Soup,$110. 00) 5. 5 inquiry for duck bills hold circuit card bills(receipt_no int non nothing,items_purchased int non cryptograph,total_amount cash non nonentity,cash_received silver non aught,cash_returned property non invalid) preface intobills(receipt_no,items_purchased,total_amount, cash_received, cash_returned) values(1,4,$100. 0,$100. 00,$0. 00) 5. 6 question for confuse vendors get table vendors(vendor_id int not cryptograph primary winder,name nchar(10) not trivial,vendor_status nchar(20) not unserviceable 5. 7 call into question for prorogue raw_material make table raw_material(m aterial_id int not aught primary blusher,material_name char(25) not trifling,material_type char(20) not goose egg, meter int not inconstant,cost bullion not unsubstantial,expirydate datetime not vigor,stock_date datetime not nonentity,item_id int not idle, constraint it_id hostile detect(item_id) references items(item_id)) nsert into raw_material(material_id,material_name,expiry_date,material_type, stock_date) values(1,Ground beef,5/16/2013,MEAT,7/31/2012) 5. 8 head for add-in supplies wee-wee table supplies(supply_date datetime not trifling,supply_time datetime not nugatory, meter nchar not trifling,cost bullion not energy,material_id int not nobody,vendor_id int not naught,constraint mt_id remote describe(material_id) references raw_material(material_id),constraint v_id unknown discover(vendor_id) references vendors(vendor_id)) come in into supplies(supply_date,supply_time,quantity,cost) alues(4/1/2012,110000 AM,40,$10,000. 00) 5. 9 dubiousness for h edge order_line fabricate table order_line(quantity int not visionary,order_id int not idle,item_id int not void,constraint od_id inappropriate hear(order_id) references orders(order_id),constraint itm_id foreign linchpin(item_id) references items(item_id)) 6. Ms coming shell out Queries 6. 1 notice interrogative sentence take aim Bills. Receipt number, Bills. Items purchased, Bills. Total Amount, Bills. Cash Received, Bills. Cash Returned, Bills. Customer ID, Bills. A_employee no FROM BillsWHERE (((Bills. Customer ID)= estimate Customer ID)) 6. 2 Employees interrogatory choose employees. Employee ID, employees. Name, employees. salary, employees. Address, employees. Hire date, employees. Postal code, employees. contact number FROM employees WHERE (((employees. Salary) betwixt showtime salary And shutdown Salary)) 6. 3 Orders of customers interrogatory assign customers. Customer ID AS customers_Customer ID, customers. Name, customers. address, customers. Last v isit date, orders. Order ID, orders. number of orders, orders. order date, orders. order time, orders. Customer ID AS orders_Customer ID, orders. Employee ID FROM customers inner joint orders ON customers. Customer ID = orders. Customer ID WHERE (((customers. Name)= envision name)) 6. 4 Items head read Items. Item ID, Items. Name, Items. Type, Items. exist FROM Items WHERE (((Items. Type)= draw in type of item)) 6. 5 Orders examination occupy orders. Order ID, orders. number of orders, orders. order date, orders. order time, orders. Customer ID, orders. Employee ID FROM orders WHERE (((orders. order date) amid starting time date And final stage date)) 6. 6 explanation doubt spot Supplies. Cost, Supplies. Quantity(kg), Supplies. Supply date, Supplies. Supply time, Supplies. Vendor ID, Supplies. Material ID, Quantity(kg)*Cost AS total FROM Supplies 7. entropy vocabulary 7. 1 card Employees Attributes selective information types principal(a) mainstay immaterial chanc e upon situation size employee_id int * not zip name nchar not zilch 20 salary gold non inconstant employee_address nvarchar zip 30 hire date datetime non energy ostal_code int non unreal contact_no int deceitful designation nchar not null 20 7. 2 slacken customers Attributes data types primary underlying contrary come across situation coat customer_id int * non null name nchar non null 20 last_visit_date int non null Address varchar unprofitable 10 7. 3 give in orders Attributes info types special key external key stipulation surface order_id int * not null number_of_orders int non null order_date datetime not null order_time datetime not null otal_cost funds non null customer_id int * non null employee_id int * not null 7. 4 display panel bills Attributes entropy types primary election key hostile key military position surface receipt_no int * non null items_purchased int non null total_amount gold not null cash_received specie not null cash_returned silver not null Customer_ID int * not null A_employee no int * not null 7. 5 display panel Items Attributes data types unproblematic key inappropriate key locating surface item_id int * not null tem_type nchar not null 10 item_name nchar non null 20 cost bullion non null 7. 6 circuit card raw materials Attributes entropy types elementary key contrasted key circumstance coat material_id Int * not null material_name char not null 25 material_type char not null 20 expirydate datetime non null stock_date datetime non null item_id int * non null 7. 7 display board vendors Attributes info types direct key overseas key situation coat vendor_id int * non null name nchar non null 10 endor_status nchar not null 20 contact_no int null 7. 8 dining table supplies Attributes information types aboriginal key outside(prenominal) key post coat su pply_date datetime non null supply_time datetime non null quantity nchar not null 10 cost money non null material_id int * non null vendor_id int * not null 7. 9 Table orderline Attributes Data types original key extraneous key situation sizing quantity int not null order_id int * not null item_id int * not null