Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

am having trouble figuring out how to set up two of the business rules for week 4 Lab a

/in /by

 am having trouble figuring out how to set up two of the business rules for week 4 Lab a.  The date and time of

engagement is in the engagement entity.  How do I show the business rule “Only one engagement may be scheduled for any particular date and time”  Also, The assistant chef is an employee, there is an employees entity.  For the business rule “One assistant chef is assigned to each engagement”, should assistant chef have its own entity or be part of employees to show its relationship to engagements. ATTACHMENT PREVIEW Download attachmentCustomersPKCustIDTEXT(10)CustFirstNameTEXT(20)CustLastNameTEXT(25)CustStreetTEXT(25)CustCity TEXT(20)CustSTTEXT(2)CustPostalCodeTEXT(10)CustPhoneTEXT(10)CustE-mailTEXT(25)CustApproved ForCreditBINARY(3)EngagementsPKEngIDTEXT(10)EngagementDate DATETIMEEngagementTimeDATETIMEEngagementLoca±onTEXT(25)EngagementMenuTEXT(20)NumberOfA²endeesINTEGERSpecialDietPlatesTEXT(25)AssistantChefIDTEXT(10)EmployeesAssignedTEXT(25)PaymentMethod TEXT(15)DepositAmount CURRENCYDepositPaidDate DATETIMETotalChargesCURRENCYBalancePaidDate DATETIMEFK1CustIDTEXT(10)can bookMenuItemsPKMenuIDTEXT(10)MenuItemName TEXT(25)MenuItemDescrip±onTEXT(30)Classi³ca±onTEXT(15)SpecialDietItemTEXT(15)PriceCURRENCYEmployeePKEmployeeIDTEXT(10)EmployeeFirstNameTEXT(25)EmployeeLastNmeTEXT(25)EmployeePosi±onTEXT(25)Engagement_MenuPK,FK1EngIDTEXT(10)PK,FK2MenuIDTEXT(10)Quan±tyINTEGERhasserved atEngEmpPK,FK1EngIDTEXT(10)PK,FK2EmployeeIDTEXT(10)hasmay workAssistantChefPKAssistantChefIDTEXT(10)assigned to

Background image of page 1
 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"