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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started