Software academy is responsible for the education of software engineers nd they
ID: 645345 • Letter: S
Question
Software academy is responsible for the education of software engineers nd they hold education sessions where Professors are hosting the sessions(all sessions 1-hour) nd 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 Question.
Explanation / Answer
pl share the table data/ contents. Also, if possible Pl increase the rating points.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.