Part $1$ Create database and DB objects based on the below ER Diagram

Create a database called Orders. Create DDL scripts for the database objects and enforce referential integrity and PK $.$ Show the CREATE TABLE statements with the modifications including the constraints given in step $2$