(Solved) : A2z Caterers A2z Catering Firm Twenty Employees Caters Office Parties 20 50 People Keep G Q44082844 . . .
A2Z Caterers (A2Z) is a catering firm with twenty employees thatcaters to office parties with 20 to 50 people each. To keep up withthe growing business owner Liz Warren wants to install a newinformation system for managing the ordering and buying process.A2Z has a set of 15 standard menus. When potential customers call,the receptionist describes the menus to them. If the customerdecides to book a party order, the receptionist records thecustomer information (name, address, phone number, etc.) and theinformation about the party (e.g., place, date, time, standardmenus, their quantities and total price) on a contract. Thecustomer is then faxed a copy of the contract. Sometimes, thecustomer accepts the price; other times, the customer requests somechanges, which have to go back to the owner for a new costestimate. The customer must sign and return the contract along witha deposit (often by a credit card or check) before the party orderis officially booked. The remaining money is collected when thefood is delivered. Each week, the owner looks through the partyorders scheduled for the week and orders supplies (e.g., plates)and food (e.g., bread, chicken) needed to make them. The ownerwould like to use the system for marketing as well. The systemshould help track how customers learned about A2Z and identifyrepeat customers so that A2Z can mail special offers to them. Theowner also wants to track the orders on which A2Z sent a contractor actually booked the picnic order.
Given the above information, please do the following: 1.Identify the main entities (min 10 entities excluding anyassociative entities). You should use them in steps 2 and 3. 2.Based on the business description identify all the relationshipsbetween entities and write relevant business rules that explaineach relationship (As all relationships are bidirectional, makesure to articulate business rules both ways for each link in thefinal fully attributed data model). Make suitable assumptions forany missing details. 3. Create fully attributed data model (EntityRelationship Diagram) based on Crow’s foot notation in MS Visio.You should also provide correct cardinality at both ends of eachrelationship i.e., (0,M / 1,M / 0,1 / 1,1) using Crow’s footnotation. For any non-specific (M:N) relationships identifiedbetween entities, you should resolve them by adding associativeentities in your data model.
Expert Answer
Answer to A2Z Caterers (A2Z) is a catering firm with twenty employees that caters to office parties with 20 to 50 people each. To …
OR