This is my ER diagram: and this is my Schema: please do the following:

[answerhappygod]

This is my ER diagram:

This Is My Er Diagram And This Is My Schema Please Do The Following 1 (96.33 KiB) Viewed 9 times

and this is my Schema:

This Is My Er Diagram And This Is My Schema Please Do The Following 2 (40.69 KiB) Viewed 9 times

please do the following:

This Is My Er Diagram And This Is My Schema Please Do The Following 3 (95.79 KiB) Viewed 9 times

Department) Name Department ID Emp ID Emp_Address Emp_DOB Company ID DEPARTMENT 1 FirstName Has IM 3 EMPLOYEE Emp_Name M Company Name 1 1 Has Emp SSN LastName COMPANY Emp Phone Company Address Has Company Phone Receive BasicPay M 1 Month Grade ID PAY GRADE 1 set/ determine 1 PAYROLL FromDate Leave Grade Allowances ToDate Grade_Bonus Pay ID Emp_ID Salary
Payroll Pay_ID Emp_ID Employee Emp ID Emp SSN Emp_Address Emp_DOB FirstName LastName Emp_Phone Salary Month Leave From Leave_To Grade ID Company Company ID Company Name Company Address Company Phone Department ID Pay ID Department ID Company ID Pay Grade Grade ID BasicPay Grade Allowences Grade_Bonus Department Department ID Department Name Grade ID
• Write SQL statements to create database and tables using the conceptual design from Phase I. Use appropriate naming conventions for all of your tables, attributes, primary keys, and foreign keys. You may copy and paste SQL statements from your own DBMS to the file you'll upload. • Insert at least 5 rows data in each table. Write SELECT * for each table and do a SNIP or screen dump that shows your tables. • Write SQL statements to update 1 column and delete 1 row for each table. You may copy and paste SQL statements from your own DBMS to the file you'll upload. • Write four SQL queries, 1 contains GROUP BY 1 contains GROUP BY and HAVING 1 contains nested query with ALL 1 contains nested query with IN show a screen dump or SNIP that shows the SQL code and the result.