Figure 5.7 Referential integrity constraints displayed on the COMPANY relational database schema. eandi nver Use any programing language, do the following steps (Note: this lab relies on lab 4): 1- Show how many rows and columns in the table above. Simulate the Horizontal fragmentation: 1- Write a SQL query to create two new tables: the first one has the male employees (M) [EmploM] and the other table has the female employees (F) [EmploE]. 2- How many rows in Emploal and Emploak. Simulate the Vertical fragmentation: 1- Write a SQL query to create 3 new tables: the first table has [Ename.Minitatname] [EmploNames], Second table has [Bdate.Address, Salaray] [Emploinfo], and the third table has [Sex Salary Supertossn.Dno] [Emplothers]. Using the three created tables: 2- Write a SQL query to retrieve Lname salary where the salary >30000, using the three created table. 3- Write a SQL query to retrieve Fname and Salary of all employees with Minit =M. 4- Write a SQL query to rejoin the three tables and name it [Emploall]. 5- Show how many rows and columns in the Emploall table