Task 2: Tag existing recipes as \"last-minute\" or \"low-cal\" Recipelngredient

Question

Task 2:

Tag existing recipes as "last-minute" or "low-cal"

Recipelngredient Ingredient Recipe PK RepRecipelD RopName PK RecingRecipelngredient longint longint longini varchar(48) varchar(4000) contains ingredients, PK IngingredientID IngName longint used in recipes FK1 RecingRecipelD FK2 RecingingredientID varchar(64) RepDirections longint IngDescription varchar128) RecingAmount varchar15) IngCreated timestamp varchar(64) IngCreated by RepPrepTimeMins int |RepCook Timelins int RepTotalTimelins RepYieldServingsLow int RepingPrepinfo ReplngCreated timestamp IngLastModified timestamp ReplngCreatedBy IngLastModifiedBy RepYieldServingsHigh int RpingLastModified imestamp RopCalsperServing int RpingLastModifiedBy varchar(128) RepSource RopSkillLevelID RepPicturelD line is level SkillLevel longjint HPK SkillID SkillDescription timestamp varchar(16) RepCreated RepCreatedBy SkillCreated imestamp RepLastModified skillCreated by imestamp int has picture details RepLastModifiedBy SkillLastModified imestamp SkillLastModifiedBy Picture PK PicturelD longini varchar(128) PictureCred Picture BLOB PictureCreated imestamp PictureCreatedBy PictureLastMo lodified imestamp PictureLast modifiedBy int

Explanation / Answer

This alter table query will add the column RcpTag to the table Recipe. Then after adding this column to the Recipe table we can use INSERT queries to insert values into this .

After that when you use the insert queries you have to give the value for RcpTag also.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.