Translate the ER diagram into relational database tables (i.e. give the SQL DDL statements). Make sure that the translation captures key constraints (primary keys and foreign keys if applicable) and participation constraints in the ER diagram. Identify constraints, if any, that you are not able to capture.

Branch num Staff num Name ContractExt num Salary DiscountValue Branch Allocated Staff Position ContractExt Date Has Type Contract num House num Can or SSN House Status Contract Name Signs Address SellValue IS A RentCost Customer Rent Deposit Duration SellValue RentCost