Student (snum: integer, sname: string, major: string, level: string, age: integer) Class (cname: string, meets_at: time, room: string, fid: integer) Enrolled (snum: integer, cname: string) Faculty (fid: integer, fname: string, deptid: integer)   WRITE THE RELATIONAL QUERY (RELATIONAL ALGEBRA ONLY, NO SQL - WILL RESULT IN DOWNVOTE)   Return the class name for all classes with more than two students and class name starts with the letter 'D'.

Sales Database: Customers(custId, lastName, firstName, address, phone, creditLimit) Orders(ordNumber, itemNumber, qtyOrdered.) Items(itemNumber, itemName, price)   For the Sales Database referenced above, write the SQL command to create the LineItem table, assuming the Orders table and items table already exist.

Create a PL/SQL database programming block with DECLARE BEGIN   END; In Declare section define a local scalar (simple) variables. lv_deptno  NUMBER And assign initial values as 10 lv_deptno  NUMBER := 50; In Declare section again, define a cursor and select last_name, salary and manager_id of employees the ones who are working in the department defined in a) In this example department will be lv_deptno:=50;   Sample code:   Cursor c_emp as   SELECT last_name, salary, manager_id FROM employees   WHERE department_id =    lv_deptno;   In the execution section (BEGIN and END) Create CURSOR FOR LOOP for cursor to process In this cursor loop, your code has to check salary and also manager_id  numbers each time new records being fetched. And based on these conditions either employee gets raise or not get raise. If employee salary is less than 5000 and also if employees managers is either 101 or 124 then it means employee is due for raise otherwise employee is not due for raise   Sample…

Please develop PL/SQL program that asks for a radius of a circle.After user enters a radius number, the program then calculates 1. Circumference and 2. Area of a circle, then prints both as follows: You entered radius as 5The circumference is 31.4159The area is 78.5398 If the area is less than 50 then print 'Please enter bigger radius'.Otherwise print 'Your radius is Ok'. Declare variables for circumference and area in such a way that the result would be rounded to 4 decimal places after the dot