Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1) Consider the database schema on the relations (where key attributes have been underlined): COURSES(Number, Faculty, CourseName) STUDENTS(Number, Surname, FirstName, Faculty) EXAMS(Student, Course, Grade, Date)
1) Consider the database schema on the relations (where key attributes have been underlined): COURSES(Number, Faculty, CourseName) STUDENTS(Number, Surname, FirstName, Faculty) EXAMS(Student, Course, Grade, Date) NOTE: relation EXAMS stores the registration number (attribute Student) of students that passed the exam for a given course (attribute Course is the number of course, not the name of the course), the grade and the date of the exam. a) Formulate in tuple relational calculus the query that retrieves the grades (5marks) achieved in exams that took place on 10/02/15 b) Formulate in relational algebra the query that retrieves the student number and grade of the students in the Faculty of Science that passed the exam for a (15marks) f Siene sed the exm course with CourseName Algebra c) Describe the standard three-level architecture for a DBMS. (5marks) 1) Consider the database schema on the relations (where key attributes have been underlined): COURSES(Number, Faculty, CourseName) STUDENTS(Number, Surname, FirstName, Faculty) EXAMS(Student, Course, Grade, Date) NOTE: relation EXAMS stores the registration number (attribute Student) of students that passed the exam for a given course (attribute Course is the number of course, not the name of the course), the grade and the date of the exam. a) Formulate in tuple relational calculus the query that retrieves the grades (5marks) achieved in exams that took place on 10/02/15 b) Formulate in relational algebra the query that retrieves the student number and grade of the students in the Faculty of Science that passed the exam for a (15marks) f Siene sed the exm course with CourseName Algebra c) Describe the standard three-level architecture for a DBMS. (5marks)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started