1.Introduction The proposed ashes bequeath be used to store entropy for a restaurant. The users of the entropybase ordain be able to detainment data for the employees and besides for the customers. Vital data stored will also let in the menu with its items and instruction about timesheets and occupations of employees. Finally the database will backup records on customers behavior (favorite food, drinks etc). 2.Data Requirements 2.1.Employees The database system should allow the user to add a new employee to the restaurant. When adding a new employee the user should be able to enter their ad hominem info like name(first name, last name), his/her ID card number, sex, birth date, address, telephones and hours per calendar month in work. The last attribute is used to calculate the salary. withal the database system allows the user to select which occupations he/she has. 2.2.Timesheets The timesheet entry is related with the employee file. By using this attribute user of this database system will have access on qualitative and quantitative information about each and every worker. Moreover in timesheets we also have the shifts which are morning, afternoon and nights` and the tolerates like sick leave and holidays. 2.3.
Occupations The occupation entity will be used to store information about each employees occupation in the restaurant. This should overwhelm: chef, waiters and receptionist. This entity is related with the employee file and one new entity the orders. 2.4.Menu The menu entity is important because it will store information about the restaurant menu. It will store the menuID for each item in the menu. Items should include objects in categories like appetizer, salads, main menu, desserts and drinks. The employee must select what the customers order. 2.5.Customer The customer entity of the database will be used to store information about customers that make a reservation mainly. The purpose of this entity is to keep the history of order and used the info for marketing... If you want to cleave a full essay, order it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper
No comments:
Post a Comment