H1 Eman Elsweisy 0015233 PDF

Preview

Summary

Download H1 Eman Elsweisy 0015233 PDF

Description

Home Work 1 by Eman Elsweisy (2) Use the University DB in Access modified from that of the textbook: c4333u.accdb. Show the screen captures of the query designs and the SQL statements for the following queries. (a) The names, advisors, and minor codes of all students majoring in 'CSCI'. The result:

SQL statements: SELECT student.lastName, student.firstName, student.advisor, student.minor FROM student WHERE (((student.major)='CSCI'));

(b) The student names, their numbers of credits, and their faculty advisor names of all students with 40 or more credits. The result:

SQL statements: SELECT student.lastName, student.firstName, student.credits, faculty.name FROM faculty INNER JOIN student ON faculty.facId = student.advisor WHERE (((student.credits)>=40));

(c) The names of students who have taken courses from an instructor of the department 'CSCI', with the course names and grades.

SQL statements: SELECT student.lastName, student.firstName, enroll.classNumber, enroll.grade FROM (enroll INNER JOIN (class INNER JOIN faculty ON class.facId = faculty.facId) ON enroll.classNumber = class.classNumber) INNER JOIN student ON enroll.stuId = student.stuId

WHERE (((faculty.deptCode)="CSCI")); (d) Show the faculty names and their department names of all associate professors. Note that the result is displayed in the order of department names.

SQL statements: SELECT faculty.name, department.deptName FROM department INNER JOIN faculty ON department.deptCode = faculty.deptCode WHERE (((faculty.rank)="Associate"));...