Consider the Database schema on the relations Courses (Number, Faculty, Course Title, Tutor)Student (Number, Surname, First Name, Faculty)Tutors (Number, Surname, First Name)Exam (Student, Course, Grade, Date)Study Plan (Student, Course, Year) Formulate in relational algebra, in domain calculus, in tuple calculus and in Data log, the queries that produce: The student who have gained an ‘A’ in at least one exam, showing for each of them, the first name, sur name and the date of the first of such occasions;For every course in the engineering faculty, the student who passes the exam during last session;The students who pass all the exams required by their respective study planFor every course in the literature faculty, the student who pass the exam with the highest grade;The student whose study plans require them to attend lectures only in their own faculties;First name and sur name of the students who have taken an exam with a tutor having the same surname as the student. O#2: Consider the Database schema on the relationsCourses (Number, Faculty, Course Title, Tutor)Student (Number, Surname, First Name, Faculty)Tutors (Number, Surname, First Name)Exam (Student, Course, Grade, Date)Study Plan (Student, Course, Year)Formulate in relational algebra, in domain calculus, in tuple calculus and in Data log, the queries thatproduce:1) The student who have gained an A' in at least one exam, showing for each of them, the firstname, sur name and the date of the first of such occasions;2) For every course in the engineering faculty, the student who passes the exam during lastsession;3) The students who pass all the exams required by their respective study plan4) For every course in the literature faculty, the student who pass the exam with the highest grade;5) The student whose study plans require them to attend lectures only in their own faculties;6) First name and sur name of the students who have taken an exam with a tutor having the samesurname as the student.

Answered: Consider the Database schema on the…

Database Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter10: Transaction Management And Concurrency Control

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

100%

Consider the Database schema on the relations

Courses (Number, Faculty, Course Title, Tutor)

Student (Number, Surname, First Name, Faculty)

Tutors (Number, Surname, First Name)

Exam (Student, Course, Grade, Date)

Study Plan (Student, Course, Year)

Formulate in relational algebra, in domain calculus, in tuple calculus and in Data log, the queries that produce:

The student who have gained an ‘A’ in at least one exam, showing for each of them, the first name, sur name and the date of the first of such occasions;
For every course in the engineering faculty, the student who passes the exam during last session;
The students who pass all the exams required by their respective study plan
For every course in the literature faculty, the student who pass the exam with the highest grade;
The student whose study plans require them to attend lectures only in their own faculties;
First name and sur name of the students who have taken an exam with a tutor having the same surname as the student.

O#2: Consider the Database schema on the relations
Courses (Number, Faculty, Course Title, Tutor)
Student (Number, Surname, First Name, Faculty)
Tutors (Number, Surname, First Name)
Exam (Student, Course, Grade, Date)
Study Plan (Student, Course, Year)
Formulate in relational algebra, in domain calculus, in tuple calculus and in Data log, the queries that
produce:
1) The student who have gained an A' in at least one exam, showing for each of them, the first
name, sur name and the date of the first of such occasions;
2) For every course in the engineering faculty, the student who passes the exam during last
session;
3) The students who pass all the exams required by their respective study plan
4) For every course in the literature faculty, the student who pass the exam with the highest grade;
5) The student whose study plans require them to attend lectures only in their own faculties;
6) First name and sur name of the students who have taken an exam with a tutor having the same
surname as the student.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.