1 a) Write the SQL code that will implement the following ERD. You need to determine Database Management b) Write the SQL code to insert 4 rows of data in each table. No field can have null values. 2. Consider the following database. stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. Relational diacram Table name: jOB Table name: PROIECT a) Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted by project number. b) Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query should retrieve the assignment number, employee number, project number, the stored assignment charge (ASSIGN_CHARGE), and the calculated assignment charge (calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS). Sort the results by the assignment number. c) Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked, sorted by employee number. 3- Consider the following database. Table name: CUSTOMER Table name: VENDOR Table name: INVOICE Table name: LINE Table name: PRODUCT a) Write a query to count the number of invoices. b) Write a query to count the number of customers with a balance of more than $500. 1 a) Write the SQL code that will implement the following ERD. You need to determine Database Management b) Write the SQL code to insert 4 rows of data in each table. No field can have null values. 2. Consider the following database. stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. Relational diacram Table name: jOB Table name: PROIECT a) Write the SQL code that will list only the distinct project numbers in the ASSIGNMENT table, sorted by project number. b) Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query should retrieve the assignment number, employee number, project number, the stored assignment charge (ASSIGN_CHARGE), and the calculated assignment charge (calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS). Sort the results by the assignment number. c) Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked, sorted by employee number. 3- Consider the following database. Table name: CUSTOMER Table name: VENDOR Table name: INVOICE Table name: LINE Table name: PRODUCT a) Write a query to count the number of invoices. b) Write a query to count the number of customers with a balance of more than $500