Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello I need help with the next sql assignment. Concept Question 2 - Normalize the Dinner Club Database Suppose you are given the following business

Hello I need help with the next sql assignment.

image text in transcribedimage text in transcribedimage text in transcribed

Concept Question 2 - Normalize the Dinner Club Database Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club's members, to plan the meals, to keep track of who attends the dinners, and so on. Each dinner serves many members, and each member may attend many dinners. Just because a dinner is offered does not mean that it is attended. More than one dinner can be offered on the same night. Dinners are "themed". Le., one particular dinner may be an ocean theme and thus be known as "Glowing Sea Delight" A dinner code defines a theme, the entre choice, and the dessert choice. . .Each particular invitation is mailed to a single member, but a member may receive many invitations. For example invitation #8 is mailed to Alice Vandervoort. However, Alice VanderVoort has received invitations #8 and #10. o A dinner on a particular day is based on a single entree, but an entree may be used as the basis for many dinners. For example, a Mar 15, 2014 'D15' dinner serves Stuffed Crab. But stuffed crab may be served on another date for a dinner code of 'D20 Because the manager is not a database expert, the first attempt at creating the database uses the structure shown in Figure 2

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_2

Step: 3

blur-text-image_3

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

Master The Art Of Data Storytelling With Visualizations

Authors: Alexander N Donovan

1st Edition

B0CNMD9QRD, 979-8867864248

More Books

Students also viewed these Databases questions

Question

1. How might volunteering help the employer and the employee?

Answered: 1 week ago