Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Home for Little Wanderers Orphanage is planning several trips ( outings ) to different beaches for the children. The staff must organize all of

The Home for Little Wanderers Orphanage is planning several trips (outings) to different beaches for the children. The staff must organize all of the essentials for the children the day before the beach trips. A child can attend 0 to many beach outings. A beach outing can be attended by 1 to many children. When a child attends a beach outing, you can think of that child as a beach goer to that particular beach outing. Each beach trip has a specific date, a specific destination, and a duration. Each child attending an outing (beach goer) will need a swimsuit, a bucket, a shovel, and a towel for the beach outing. Of course, the assigned item to a child can vary for one beach outing to the next. For each child, we track the childs unique social security number, a name, a date of birth, and a description. For each swimsuit, we track the gender of the suit (male or female), its size, its color, and if it is of a 2-piece style. For each bucket, we track its color, its material (metal or plastic), and its size (height, width, depth). For each shovel, we track its color, its material (metal or plastic), and its size (height, width, depth). For each towel, we track its color. For each beach outing a beach goer is assigned to 1 and only 1 swimsuit,1 and only 1 towel, 1 and only 1 bucket and 1 and only 1 shovel On any one beach outing, a towel is used by 0 or 1 beach goer. A bucket is assigned to 0 or 1 beach goer. A shovel is assigned to 0 or 1 beach goer. A swimsuit is worn by 0 or 1 beach goer.

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

Students also viewed these Databases questions

Question

device benchmark result

Answered: 1 week ago