Question: please solve as soon as possible The following relational schema form a university database which is implemented in a relational database: student (s ID, S_name,

please solve as soon as possible
The following relational schema form a university database which is implemented in a relational database: student (s ID, S_name, year, semester) department(d_ID, d_name, floor) course (c_code, c_title, d_ID, credits) Write down the Relational Algebra operations for the following queries: a) Find your own name from the student relation using your own student ID. b) Show the ID and name of department located at the floor number n. (here, n = the length of your own name; you do not need to calculate the length using Relational Algebra, just calculate in your mind and put the value in the desired Relational Algebra operation) c) Find the course codes and titles using your own department ID. (CSE 01) d) List the course names which are more than 3 credits. e) Find all the students' name from the year 2019
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
