You are given a database in a MS Access file called ‘Database Query Assignment’

Question

You are given a database in a MS Access file called ‘Database Query Assignment’ that contains data collected in a school of business. The school of business hired you as a data analyst to answer questions in order to help them make business decisions that will help better prepare students for future job placements. Write the SQL statement in the SQL Statement column for each query

Query Question

SQL Statement

List all students who graduate in May 10 2002 and are Accounting majors.

List all students who accepted an internship, including the job title, and the name of the company.

List the average salary offer by major.

List the interviews scheduled for December 1, 2001 by company.

List the average bonus offer by company.

List the jobs that are currently available.

List all students who received more than one offer.

List the students still searching for jobs.

List the jobs that require leadership and communication skills.

Query Question

SQL Statement

List all students who graduate in May 10 2002 and are Accounting majors.

List all students who accepted an internship, including the job title, and the name of the company.

List the average salary offer by major.

List the interviews scheduled for December 1, 2001 by company.

List the average bonus offer by company.

List the jobs that are currently available.

List all students who received more than one offer.

List the students still searching for jobs.

List the jobs that require leadership and communication skills.

ame Offer ame er IfRep_GPA Recruiter dentStatus FirstName LastName Interview bID terview_Date dentSkills SID rview_Time JobSkills ID ID ID Skill bStatus JobDescription RID killName tion

Explanation / Answer

Answer:-------------

SELECT FirstName,J.JobTitle,C.NameFROM Student(S) AND Offer(O) AND Job(J) AND Company(C) AND Recruiter(R) where S.SID = O.SID AND O.JobID = J.JobID AND J.RID = R.RID AND R.CID = C.CID ;

Query Question SQL Statement List all students who graduate in May 10 2002 and are Accounting majors. SELECT * FROM Student where GradDate = '2002-05-10' AND Major = "Accounting" ; List all students who accepted an internship, including the job title, and the name of the company.

SELECT FirstName,J.JobTitle,C.NameFROM Student(S) AND Offer(O) AND Job(J) AND Company(C) AND Recruiter(R) where S.SID = O.SID AND O.JobID = J.JobID AND J.RID = R.RID AND R.CID = C.CID ;

List the average salary offer by major. SELECT AVG ( O.SalaryOffer) FROM Student(s) AND Offer(O) where S.SID = O.SID ; List the interviews scheduled for December 1, 2001 by company. SELECT C_Name,Interview_Date FROM Interview(I) AND Job(J) AND Recruiter (R) AND Company(C) where I.JobID = J.JobID AND J. RID = R.RID AND R.CID = C.CID AND I.Interview_Date = '2001-12-01' : List the average bonus offer by company. SELECT AVG (BonusOffer) FROM Offer(O) AND Job(J) AND Recruiter(R) AND Company(C) where S.SID = O.SID AND O.JobID = J.JobID AND J.RID = R.RID AND R.CID = C.CID ; List all students who received more than one offer SELECT * FROM Student(S) AND Offer(O) where S.SID = O.SID AND O.OfferStatus >1; List the jobs that require leadership and communication skills. SELECT * FROM Job(J) AND JobSkill(JS) AND Skill(S) Where J.JobID = JS.JobID AND JS.SkID = S.SkID AND S.SkillName="leadership and communication" ;

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.