Question
2) Specify the following questions against the database in the figure above using relational algebra: a) Give a list of the courses (names, numbers) that
2) Specify the following questions against the database in the figure above using relational algebra:
a) Give a list of the courses (names, numbers) that give more than 3 points (credit hours)
b) Give a list of the courses (numbers) given in the autumn of 98
c) Give a list of the students (names, grades) who have taken the course Data Structures
d) Give a list of the students (student name, course number) who have passed someone course either autumn 98 or spring 99
e) (Extra assignment, not compulsory) Give a list of the students (student name, student number) that meets the prerequisites for the course "Database", but who has not yet passed it
Figure 1.2 An example of a database that stores student records and their grades. STUDENT Name Student Number Class Major Smith 17 CS Brown 8 2 CS 1 COURSE CourseName Intro to Computer Science Data Structures Discrete Mathematics Database CourseNumber CreditHours Department CS1310 4 CS CS3320 4 CS MATH2410 3 MATH CS3380 3 CS SECTION SectionIdentifier CourseNumber Semester Year Instructor 85 MATH2410 Fall 98 King 82 CS1310 Fall 98 Anderson 102 CS3320 Spring 99 Knuth 112 MATH2410 Fall 99 Chang 119 CS1310 Fall 99 Anderson 135 CS3380 Fall 99 Stone 17 17 GRADE REPORT Student Number SectionIdentifier Grade 112 B 119 85 8 92 102 135 8 >>O 8 B 8 A PREREQUISITE CourseNumber Prerequisite Number CS3380 CS3320 CS3380 MATH2410 CS3320 CS1310Step 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