1 / 16

# The Student Database - PowerPoint PPT Presentation

The Student Database. The Selection Operator . Give me information of students under the age of 18  age<18 (Student). The Projection Operator  . Give me the name, address, and GPA of all the students  name, addr, GPA (Student)  name, GPA, addr (Student) . Sample Query.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'The Student Database' - step

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

• Give me information of students under the age of 18

• age<18(Student)

• Give me the name, address, and GPA of all the students

• Give me the SID and GPA for students under the age of 18

• sid, GPA(age<18(Student))

• Give me all combinations of students and the enrollment of students

• Student  Enroll = (Student.sid, name, addr, age, GPA, Enroll.sid, dept, cnum, sec)

• Give me all the information of enrolled students

• Student.sid = Enroll.sid(Student  Enroll)

• Give me the name and addresses of students taking CS courses whose GPA is below 3.0

• name, addr(dept = ‘CS’  GPA < 3.0  Student.sid = Enroll.sid(Student  Enroll))

• Class Enroll

•  Class.dept = Enroll.dept  Class.cnum = Enroll.cnum  Class.sec = Enroll.sec(Class  Enroll)

• Class Class.cnum = Enroll.cnum  Enroll.dept = ‘CS’ Enroll

• Class.cnum = Enroll.cnum  Enroll.dept = ‘CS’(Student  Enroll)

• Give me the SIDs of all students

• Give me the department, course number, and section of all classes without any enrolled students

• dept, cnum, sec(Class) – dept, cnum, sec(Enroll)

• Give all the instructors who teaches both CS and EE classes

• instructor(dept=’CS’(Class)) instructor(dept=’EE’(Class))

• Give me pairs of student names who live at the same address

• Give me the SIDs of students who are enrolled in all of the CS classes

• sid(Student) – sid(sid(Student dept, cnum, sec(dept=’CS’(Class))) – Enroll)

• Give me the SIDs of students who are enrolled in all of the CS classes

• sid(Student) –

sid(

sid(Student) 

dept, cnum, sec(dept=’CS’(Class))

– Enroll)

)