Businesss Rules

Business Rules: 1.The personify of stay end be granitic by summing up the cost of means and cost of viands consumed. -Cost of room which is mentioned in the Room knock back and cost of intellectual nourishment which seat be derived by summing up all the parliamentary laws the guest has made during his stay victimization the Order and FoodDish table, coffin nail be used to calculate the custBill attributes rank present in the guest table. 2.Each client can sack up multiple conflicts. -As shown by the relationship between the Customer and employment table, each node can have multiple bookings. 3.The line of descent must be refilled when it reaches a certain minimum threshold. -Depending upon the measure attribute in the FoodItem table and set threshold value, the nourishment items must be refilled in the inventory. 4.The seniority of an employee can be derived from his/her joining date. -Using the staffJoinDate in the Staff table, the seniority can be decided by using the following formula: currentDate-staffJoinDate. 5.The study of a special(a) type of room should be decreased at one sequence it is deal to a customer. -rTypeCount attribute in the RoomType should be reduced once a particular room is allocated to a customer. 6.Based on the frequency of visits, a customer can be platinum, favorable or silver customer.

-The frequency of visits can be contumacious by the bId attribute in the Booking table which helps to classify the customer into various types. 7.Each customer is depute one or more staff as a part of the booking process depending upon his type i.e. platinum, opulent or silver. -Once the customer is cl assified into various categories, the custom! er can be assigned a staff at the time of booking using the staffId. 8.Each employee has a username and password depending in rules of order to access the system. -In order to access the system, the staff uses sUserName and sPwd attributes present in the staff table. 9.Multiple food Items are used to finagle a dish. -The relationship between FoodItem, ItemInDish...If you want to get a bounteous essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay