I require assistance in creating a script that transforms the following entity relational diagram into a database structure using DDL statements. It requires the creation of the tables as well as the constraints including primary key, foreign key and check constraints

R_City Part_Num (PK) Part Desc Part Num (FK) (PK) Product Material is part of Part P_Code (FK) (PK) has O_Num (FK) (PK) P_Code (FK) (PK) O_Num (PK) O_Date C_ID (FK) P_Desc P_Code (PK) Product is present in Order line contains Order Price O_aty F_Qty B_Qty is used in places C_Phone C_Name Date (PK) Product Inventory C_ID (PK) (FK) Cust Phone has Customer C_ID (PK) C_Disc P_Code (FK) (PK) A_Qty B_City has C_ID (PK) (FK) Cust Address C Address Address Type