Software academy is responsible for the education of software engineers and they
ID: 645373 • Letter: S
Question
Software academy is responsible for the education of software engineers and they hold education sessions where Professors are hosting the sessions(all sessions 1-hour) and young engineer candidates are enrolled in these sessions consider following relations;
Student (snum , sname , age, level)
Education(ename, professor_id, eday, ehour, eroom)
Enrolled (snum, ename)
Professor(pid, pname)
Write the following queries/assertions in SQL. Omit the duplicate values at all times. 1. Find the names of all young engineer candidates (level = JR) who are enrolled in a education session taught by "Professor Turing".
2. Find the age of the oldest student who is either a Junior (level = JR) or enrolled in a education session taught by "Einstein".
3. Find the names of all education sessions that either meet in room R128 or have five or more students enrolled.
4. Find the names of Professors for whom the combined enrollment of the education sessions that they host is less than five.
5. For all levels except JR, find the level and the average age of students for that level.
6. Find the names of students enrolled in the maximum number of classes.
7. Write an assertion that guarantees that two trainings cannot happen at the same room and same time. 8. Write an assertion that guarantees that a student cannot be enrolled to training sessions that meet at the same time.
Database Management Systems Study Question.
Explanation / Answer
1. Find the names of all young engineer candidates (level = JR) who are enrolled in a education session taught by "Professor Turing". SELECT sname FROM Student RIGHT JOIN Student ON Student.snum=Enrolled.snum, RIGHT JOIN Enrolled ON Enrolled.ename=Education.ename RIGHT JOIN Education ON Education.professor_id=Professor.pid WHERE Student.level=
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.