4. The table represented by the E-R diagram below is valid as a relation? If not, transform the following table into a correct Database Schema. Show a correct Database Tables with the schema and data values and write the corresponding DDLs. Dnumber Dname Dmgr_ssn DLocation Department Department Dname Research Dnumber 5 Dmgr_ssn 333445555 DLocation { Bellaire, Sugarland, Houston { Stafford, Cleveland) (Houston) Administration 4 555667777 Headquarter 1 777889999 4-1) Draw the correctly transformed schema of the table(s) for the Department above to create a correct database schema and Show all the tuple values together. Mark (underline) the primary key of table(s). 4-2) Write the corresponding DDL for each table transformed. Add all the PK, FK constraints. 5-1) Determine Cardinality of Ordering Relationship between Customer and Product Entities in the following E-R diagram as below. 5-2) Write DDL to create a correct database/table scheme for the relationship Order from the E-R Diagram. Specify all the Constraints: PK, FKs, and any other rules for the Attributes needed in your DDL for the Database/Table scheme. You can choose any SQL data type for each attribute. Assume that 1. Two Entities CUSTOMER and PRODUCT in the ER diagram are already created to the table CUSTOMER and PRODUCT as below. Assume that the types of Cid and Pid are INT. 2. You have to choose PK of Any Table from the existing attributes in the table. (No Identity Column (Rowld is allowed as PK