For this question, can you share SQL create table commands and rules for assertions/triggers?

Consider the E/R diagrams given in Figures 6.10, 6.11 and 6.12. keep it. (a) Convert Figure 6.10 to a relational schema with SQL-DDL. (b) Convert Figure 6.11 to a relational schema with SQL-DDL. (c) Convert Figure 6.12 to a relational schema with SQL-DDL. All constraints on ER diagrams must be satisfied and, if necessary, active rules for this (ie, assertion/trigger).

Figure 6.10

6.11

6.12

employee_street