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
Get step-by-step solutions from verified subject matter experts
