Question: Create the internal model. That is, write data definition language (DDL) commands to create each entity/table based on the specifications illustrated in the ERD diagram
Create the internal model. That is, write data definition language (DDL) commands to create each entity/table based on the specifications illustrated in the ERD diagram and the following additional specifications:
meal PK meal_id name meal_date meal_total carbohydrate_total PK fat_total protein_total contains meal_item PK, FK1 meal_id PK, FK2 item id quantity is for item item id description price HH -contains K item macronutrient PK, FK1 item_id PK, FK2 macronutrient_id gram_amount -corresponds to +H macronutrient PK macronutrient_id description calorie_amount
Step by Step Solution
3.45 Rating (171 Votes )
There are 3 Steps involved in it
CREATE TABLE meal mealid int NOT NULL PRIMARY KEY name varchar50 mea... View full answer
Get step-by-step solutions from verified subject matter experts
