Question: Help me with this question in database course of Weak Entities and Subtypes lecture : Draw the entities and relationships suggested by each word problem.

Help me with this question in database course of Weak Entities and Subtypes lecture :

Draw the entities and relationships suggested by each word problem. Include the proper foreign key(s).

1Our restaurant database includes meal choices. Each meal choice has a unique identifier MealID, a description and a calorie count. For Country meals we need to capture the type of gravy and whether biscuits or cornbread is included. For Tex-Mex we need to include the type of peppers used and the tortilla type (corn or flour). We are a fusion restaurant and we have nifty meals like Hatch Green Chile Chicken Fried Chicken with a reduction of tomatillo. So some meals can be both County and Tex-Mex. We want to capture all genres of meals beyond just those two, however.

2- #6 again, but we are no longer a fusion restaurant. Meals are Country or Tex-Mex, and we still serve other genres of food.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!