Do the following instruction using SQL   DATABASE NAME: PSYCOTROMPUS             TABLE NAME: YOUR SURNAME                             EMP_NO SURNAME FIRSTNAME DEPARTMENT RATEPERDAY NO.OF WORK SALARY   300011 YOUR SURNAME YOUR FIRSTNAME IT 655 12 NULL   300012 AVILES KATE HRD 740 13 NULL   300013 CHUA LANCE ACCOUNTING 550 13 NULL   300014 DELA CRUZ JOHN FINANCE 650 12 NULL

Q: SQL is a declarative language means that   (a) it allows describing the algorithm to carry out the…

A: In this answer I will be discussing about SQL.

Q: 3. Write a query to display the book number, book title, and subject for every book sorted by book…

A: In the  database management and information organization, a common scenario involves designing…

Q: What Level of normalization is the following table?  Student_ID Student_Name Course_ID…

A: The given table is in the First Normal Form (1NF), which means it has atomic values in each cell.

Q: Display a report that calculate the average of hours in the table works_on, regardless of whether…

A: Answer 1 :-   For calculate the average of hours in the table works_on, regardless of whether null…

Q: Write a PL/SQL code to print 'PASS' if the student has scored above 40. Choose an answer A declare…

A: C is the correct option Declare m number:= 80;begin if m>40 dbms_output.put_line('Pass') ; end…

Q: reate a PL/SQL block using a FOR loop to generate a payment schedule for a donor’s pledge, which is…

A: ANSWER:-

Q: Get the student#, course# and midterm grade of the enrollments for courses of the CS department.

A: Relational Algebra :- A procedural query language is relational algebra. It walks you through the…

Q: ***Using SQL*** Assume you have a table as follows table name: Accounts columns: account_num char(9)…

A: Find the answer given as below :

Q: What is the output of the following SQL statement? SELECT name, hCity, pcity, population FROM…

A: Answer: Output 3

Q: A trigger is procedural SQL code that is manually invoked by the RDBMS upon the occurrence of a…

A: Trigger in SQL           A trigger is a particular class of stored procedure that starts running…

Q: Write SQL statements to list the name of Lee’s subordinate employee.    (Data Update)     Write…

A: Lees Employee ID is 2 So, to get the lees subordinate then we need to search for this employee ID in…

Q: 2. Write a query to display the checkout number, checkout date, and due date for every book that has…

A: Algorithm:Select Data: Select the desired columns Check_Num, Check_Out_Date, and Check_Due_Date.Join…

Q: please answer Exercise 4-7

A: In this question we have to answer the bash related question  Let's code and answer

Q: 5. EMP table has records as follows: EMP_NUM EMP_TITLE EMP UNAME Kolmvcz Lewis Vandam 100 101 102…

A: Below I have provided a SQL Qurey program for the given question. Also, I have attached a screenshot…

Q: Write a SQL statement to display a sentence similar to the format below for all the employees…

A: Solution:   TABLE NAME =  EMP   CAST = CAST use to convert int to string data type + =  + operator…

Q: The PL/SQL block that is always executed, regardless of whether an exception is raised or not, is…

A: PL/SQL subprograms are named blocks that may be called repeatedly. Subprogram parameters may change…

Q: 5. Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The problem involves retrieving key information from a database tracking book checkouts by patrons.…

Q: Name the candidate keys in the following table: Student L number Student_Name Student SS Number…

A: a candidate key is a super key which has no redundant attribute.

Q: Answer the given question with a proper explanation and step-by-step solution. sid name value…

A: SQL (Structured Query Language) is a programming language designed for managing relational…

Q: Write SQL queries for the following statements. 1) Write a stored procedure which takes an integer…

A: Create proc using create command  Create a variable as input parameter Declare incrementation…

Q: Find the first names and last names of employees if they got a salary increase more

A: create table commands and inserting sample data into the table for query  create table employees…

Q: SQL Sailors (sid: integer, sname: string, rating: integer, age: real) Boats (bid: integer, bname:…

A: We need to write the SQL query to compute named and ratings of the sailors who sailed two different…

Q: SQL: Change the salary of those employees in dept 4001, to be 1.5 times their current salary.

A: To write SQL statement to change the salary of those employees in dept 4001, to be 1.5 times their…

Q: True/False: Parallel processing in SQL can improve query performance by utilizing multiple threads.

A: By using many threads, the question investigates how SQL's parallel processing might improve query…

Q: According to tables below, write  SELECT statements to exemplify nested and/or correlated nested…

A: Here are the sample SQL Query for the given options: 1. Display number of flights between 6.00 AM…

Q: Enter all the various kinds of numbers. In SQL

A: Numbers can be either accurate or approximative in SQL. The precise data types for numbers are…

Q: Write a SQL statement to display the lowest final marks per department

A: The clause used in this case would be MIN. Using this MIN clause the minimum element in a column of…

Q: Employees (EmployeelD, LastName, FirstName, BirthDate, Notes) Orders (OrderID, CustomerID,…

A: To compute the total sales of products in orders handled by each employee, we need to join the…

Q: By default, data returned by the SQL SELECT statement is in descending order.   a. True   b.…

A: Please find the answer below :

Q: Identify the relational keys in the following two tables.

A: Table Branch Candidate key: branchNo, postcode Primary key : branchNo Superkey: branchNo…

Q: d) Write an SQL query to display the unique members for books returned (Return_date) by the members…

A: Query: select Member_Name from MEMBER where Return_date like '%May%'; Output: Member_Name SINHA JOHN…

Q: Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is…

A:

Q: What is the output of the following SQL statement? SELECT name, hcity, pcity, population FROM…

A: FULL JOIN: The function of FULL JOIN is to return the entire tuples of right table and the left…

Q: 8. Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: Algorithm:Select Data: Retrieve the CHECK_NUM, BOOK_NUM, PAT_ID, CHECK_OUT_DATE, and CHECK_DUE_DATE…

Q: 2. Get employee details from employee table whose first name starts with 'J', order the result…

A: According to the information given:- We have to follow the instruction in order to get desired…

Q: Perform first normalization based on the table information given.

A: Please refer to the following step for the complete solution of the problem above.

Q: SQL Server's character data types come in three varieties: NVARCHAR, NVARCHAR, and NVARCHAR.

A: Introduction: A SQL developer must choose what information will be kept in each column before…

Q: I need help with creating the SQL statement for the instructions below. Create the following 2…

A: In this question we have to write a SQL based query for the given statement Let's query and hope…