Hi so can you write these for me?

I will attach a word doc with the info

EMPLOYEE

DEPARTMENT

DEPTLOCATION

PROJECT

WORKSON

DEPENDENT

Integrity Constraints:

Primary Key Foreign Key

EMPLOYEE.ssn = DEPENDENT.essn

EMPLOYEE.ssn = WORKSON.essn

EMPLOYEE.ssn = DEPARTMENT.mgrssn

EMPLOYEE.ssn = EMPLOYEE.superssn

DEPARTMENT.dnumber = EMPLOYEE.dno

DEPARTMENT.dnumber = DEPTLOCATION.dnumber

DEPARTMENT.dnumber = PROJECT.dnum

PROJECT.pnumber = WORKSON.pno

1. Retrieve the name of employees whose salary is greater than the average salary of his or her corresponding department

1. List the names of departments, and the total number of employees with salaries greater than $27,000, and only those departments with more than one employee.

1. Retrieve the names of all employees who work on every project located in Houston

All relevant info, sorry couldn't attach

ok,

http://wikisend.com/download/157840/EMPLOYEE.docx

There ya go

In about 4 hours?

ok ill send now in a jiffy

http://wikisend.com/download/456568/EMPLOYEE ddl & dml.docx

DDL AND DML

Thankd for this

Would it be better if I sent you a shot of the tables and info included

Here ya go

http://wikisend.com/download/290510/Tables and data.docx

Cool but its 8 hours max im afriad I got to hand it up then!