Simplify the following query (WHERE clause), expressed in SQL, on the example database above: SELECT ENAME, PNAME FROM EMP, ASG, PROJ WHERE (DUR > 12 OR RESP = "Analyst") AND EMP.ENO = ASG.ENO AND (TITLE = "Elect. Eng." OR ASG.PNO < "P3") AND (DUR > 12 OR RESP NOT= "Analyst") AND ASG.PNO = PROJ.PNO

(a) Write the sql syntax to create a table name Client with the following restrictions; Client(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary key. cname do not accept null values. Payment_mode accepts only cash or credit entries. The default address is “vacoas". client is at least 25 years old. Salary is above Rs 30000. (b) Consider the schema of Customer table in part(a) and write SQL statements for the following queries. i. Using SQL, write the command to add a new column in the client table with the following data definition; (Column “gender" of char data type and field size of 1). ii. Using SQL, write the command to insert the values in the Client table. cid address age occupation salary Payment_mode gender cname 123 sam vacoas 31 manager 60000 cash m 124 david flacq 38 administrator 45000 credit m iii. Write the SQL query to display the cid of all employees. iv. Write the SQL code to list all administrators whose salary is greater than Rs…

Using the Henry Books database,Henry Books no longer carries books written by Barbara Owen. Delete this author from the authors table.  You will insert 2 snips for this question. What construct did you use to delete author Barbara Owens? Insert the snip of the construct used:     Insert the snip of the authors table.  Be sure all rows are displayed:

Consider the following database table named water_schemes: water- schemes scheme_no district_name capacity Ajmer 1 20 1 Bikaner 10 2 Bikaner 10 3 Bikaner 20 1 Churu 10 Churu 20 1 Dungargarh 10 The number of tuples returned by the following SQL query is with total(name, capacity) as select district_name, sum(capacity) from water_schemes group by district_name with total_avg(capacity) as select avg(capacity) from total select name from total, total_avg where total.capacity 2 total_avg.capacity

Please show all work and write it in PL/SQL and copypaste what you have.

Run the problem using Relational Algebra, below the problem I added the needed table. Use self join find the answer   (4) Find the name (fname,lname) of the direct supervisor of “Mary Smith”. (“Mary Smith” is an employee).   group: emplyeeemployee = {fname, lname, ssn,superssn, departnumber'Mary', 'Smith',111, 222, 11'Green', 'Marjorie',333, 222, 12'Gren', 'Cheryl',222, 777, 14}