Alex Events Inc., a local event planner, has several longtime clients that are becoming an issue. Historically, Alex has been able to keep business records in a notebook. There were only a few clients; they had some recurring events; only a few caterers were involved. Things have changed. Alex has decided to focus on this business full‐time, and has recently picked up some new clients. Additionally, Alex has developed more favorable contracts with new caterers, but only for certain types of events.
Furthermore, Alex would like to charge clients different rates based on the length of their contracts with Alex Events Inc. Frankly, this has all gotten out of ...view middle of the document...
You should display the event type, event date and event attendance. For each client indicate the client name. For each caterer, indicate the caterer name.
Koko’s Canine Pet Club is a dog‐walking service, catering to caring, yet busy, pet owners. Although the service was only started six months ago, it currently provides pet walking services for more than 50 pets and is registering, on average, 5 new pets per week. She requires a database that tracks her clients, their pets, and the different breeds of dogs that she walks. Ms. Hannah gives you her existing spreadsheet and requests that you create the appropriate tables, create several relationships, construct several queries, design a pet report, and design a client form.
ERD: Develop a 3‐table data model (an entity relationship diagram or a relational model) for the above business problem. Import the provided Excel spreadsheet, Access 2 Dataset. Once you look at the date and decide on what tables to make, use the table analyzer to create the tables and let Access assign primary keys. Rename the keys to fit the tables. Paste a screenshot...