Question: PL/SQL script to build tables - Create PL/SQL scripts to build all the tables included in the final approved ERD. Fill in the template provided.
PL/SQL script to build tables - Create PL/SQL scripts to build all the tables included in the final approved ERD. Fill in the template provided.
ERD:

Template:
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
-- ============================================= -- Author:
-- Insert your procedure here GO
Recipelngredient PK RcpRecipelD PKRcp1ngRecipelngredientlD |int FK1 RcpingRecipelD FK2 RcplngingredientlD PK InglngredientID IngName archar(48) varchar(4000) used in recipes varchar(64) varchar(128) RcpPrepTimeMins int varchar(16) ins IngLastModifiedBy RcpingLastModifiedBy varchar(128) RcpSkillLevelID SkillLevel RcpPicturelD PK SkillID varchar(16) RcpLastModifiedBy int PK PicturelD varchar(128) Has photo details PictureLastModifieddatetime PictureLastModifiedBy int
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
