Need 3 very simple SQL queries written. Am new to SQL and need them for an assignment.Example:Retrieve the names of all employees who work on every project located in Houston
Language (or Software): SQL
Hello and welcome! My name is XXXXXXX XXX I look forward to assist you today with your question and provide the best answer possible
please do let me know the name of the table and its fields so that i could write the query for you
Hi so can you write these for me?
yes i will write the queries for you. please provide me the name of the table and the columns with the queries you want
I will attach a word doc with the info
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
All relevant info, sorry couldn't attach
please type them in a word document and upload to www.wikisend.com
There ya go
when do you need them
In about 4 hours?
can you send me the database file as well so that i could test the queries?
ok ill send now in a jiffy
http://wikisend.com/download/456568/EMPLOYEE ddl & dml.docx
DDL AND DML
Thankd for this
thank you very much. i will be back with the queries in a while
can you provide me some sample data under the columns in a word document
Would it be better if I sent you a shot of the tables and info included
that would be of great help. thank you so much
Here ya go
http://wikisend.com/download/290510/Tables and data.docx
can i take more time on this? i have a pre-schedule engagement
if i take 6-8 hours?
Cool but its 8 hours max im afriad I got to hand it up then!
yes i will do it before that
thank you very much!
due to my engagements, i will not be able to complete the assignment in time. so i will opt out so that any other expert can help you on this. thank you very much for your patience
hii am jatechexperti will help you
hihere is the answer link belowhttp://ge.tt/50mFBtJ/v/0hope this helps
Master of Computer Application plus 5+ year experience in Software development