Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A2Z Caterers (AZC) is a catering firm with twenty employees that caters to office parties with 20 to 50 people each. To keep up with

A2Z Caterers (AZC) is a catering firm with twenty employees that caters to office parties with 20 to 50 people each. To keep up with the growing business owner Liz Warren wants to install a new information system for managing the ordering and buying process. AZC has a set of 15 standard menus. When potential customers call, the receptionist describes the menus to them. If the customer decides to book a party order, the receptionist records the customer information (name, address, phone number, etc.) and the information about the party (e.g., place, date, time, standard menus, their quantities and total price) on a contract. The customer is then faxed a copy of the contract. Sometimes, the customer accepts the price; other times, the customer requests some changes, which have to go back to the owner for a new cost estimate. The customer must sign and return the contract along with a deposit (often by a credit card or check) before the party order is officially booked. The remaining money is collected when the food is delivered. Each week, the owner looks through the party orders scheduled for the week and orders supplies (e.g., plates) and food (e.g., bread, chicken) needed to make them. The owner would like to use the system for marketing as well. The system should help track how customers learned about AZC and identify repeat customers so that AZC can mail special offers to them. The owner also wants to track the orders on which AZC sent a contract or actually booked the picnic order. Given the above information, please do the following:

1. Identify the main entities (min 10 entities excluding any associative entities). You should use them in steps 2 and 3.

2. Based on the business description identify all the relationships between entities and write relevant business rules that explain each relationship (As all relationships are bidirectional, make sure to articulate business rules both ways for each link in the final fully attributed data model). Make suitable assumptions for any missing details.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

101 Database Exercises Text Workbook

Authors: McGraw-Hill

2nd Edition

0028007484, 978-0028007489

More Books

Students also viewed these Databases questions