Consider the following relational schema about a University (the primary keys are underlined and foreign keys are italic) STUDENT(StudentID, name, major, year, age) CLASS(ClassName, meetsAt, room, LecturerID) ENROLLED(StudentID,

Consider the following relational schema about a University (the primary keys are underlined and foreign keys are italic) STUDENT(StudentID, name, major, year, age) CLASS(ClassName, meetsAt, room, LecturerID) ENROLLED(StudentID, ClassName, mark) LECTURER(LecturerID, name, DepartmentID) DEPARTMENT(DepartmentID, name) Write the SQL statements for the following query:

B1. Find the age of the oldest student.

Don't use plagiarized sources. Get Your Custom Essay on
Consider the following relational schema about a University (the primary keys are underlined and foreign keys are italic) STUDENT(StudentID, name, major, year, age) CLASS(ClassName, meetsAt, room, LecturerID) ENROLLED(StudentID,
Just from $8 /Page 0r 300 words
Order Now

B2. Find the ID’s of lecturers whose name begins with “K” \

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

B3. Find the age of the youngest student who is enrolled in Mechatronics.

B4. Find the age of the oldest student enrolled in any of Max Headroom’s classes.

B5. Find the names of all classes that have more than 100 students enrolled

B6. Find the names of students who are not enrolled in any class

Looking for a similar assignment? Get help from our qualified experts!

Order Now