SID SNAME STYPE LOCATION 1 Lulu DS Salalah 2 C4 DS Saadah 3 Smile WS Awqad PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6 2 15 803 Ballpen 4 2   804 Marker 2 3 20 Update the price of the products to increase it by 20% if the price is more than the price of ‘Pencil’ product. (use subquery) (1)

Q: We have the following tables which creates statement are 1. create table supplier(S_NO int…

A: Given:- We have the following tables which creates statement are1. create table supplier(S_NO int…

Q: PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6 2 15 803 Ballpen 4 2…

A: Two tables can be joined using JOIN and ON keywords in the FROM clause. The column having numeric…

Q: The following table stores details of tutors, students and dates of lectures. The Primary Key is…

A: Rules regarding 2nd NF:-  tables must be in 1st NF.  No non-prime is functionally dependent on part…

Q: SQL SELECT name, yrgoal, contamt 2 FROM donor, donation 3 WHERE donor.idno = donation.idno AND…

A: Given are two tables, Donor table and Donation table. Donor table has attributes idno, name, stadr,…

Q: Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the…

A: query that will is: select e.last_name from employees e, employees m where e.manager_id =…

Q: 1- List all the users and their card name using union 2- List all the users and their card name…

A: Answer1 :   We will need to join the multiple sets to get the required details So, we will join the…

Q: -v is the complete table of registration ciation allowed. Student Course Offering Student

A: Given:

Q: Rewrite the query below to also show INDATE as [Stock Date]: SELECT PRODUCT.P_CODE,…

A: I have given an answer in step 2.

Q: Write correlated and noncorrelated subqueries and understand when to use each.

A: This question argues about correlated and noncorrelated subqueries and understand when to use each.

Q: Given the following ERD, which of the following joins produce the same results. You can assume the…

A: Here, there are three relations named A, B, and C which are shown using the ERD. In this ERD,…

Q: Create a table Customer ; ID | NAME |AGE|ADDRESS | SALARY Select * from customers; I IR | NAME | AGE…

A: Triggers are stored programs, which are automatically executed or fired when some events occur.…

Q: "C" to add $100 in the balance of all the customers having more than $1000 in their balance and then…

A: The following code is in 'C' language:

Q: 8. Which of the following SELECT statements displays a list of student names from the Students…

A: explanation: in the given option only statement B will include both 2020001 and 2020100

Q: FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery…

A: Given subquery SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772

Q: Write SQLSQL statements for following: Student( Enrno, name, courseId, emailId, cellno)…

A: We need to create tables for Student and Course And we need to insert values into these tables.…

Q: Use the table below to find the output PRODUCT ID PRODUCT NAME BRAND UNIT PRICE SUPPLIER ID CATEGORY…

A: Required:

Q: Using MySQL, populate the CUST_LNAME, CUST_FNAME, and CUST_BALANCE fields with the following…

A: NOTE: - Since the CUSTOMER table complete detail is missing, hence a table is created using the…

Q: Using MySQL, populate the CUST_LNAME, CUST_FNAME, and CUST_BALANCE fields with the following…

A: MySql query to display CUST_LNAME, CUST_FNAME, and CUST_BALANCE fields: First step is to create the…

Q: Display CustomerName and Status as 'Q2 for every customer who was born during the 2nd quarter of…

A: The given problem is related to database SQL query. The problem has provided the msCustomer table…

Q: 5- Find Customer ID, Customer name and Customer City for all accounts, sorted by Customer City, then…

A: According to the Question below the solution:   As per our company guidelines we are supposed to…

Q: Which of the following SELECT statements will select the ProdNum field from the Products table, and…

A: Explanation: The “SELECT” statement is used to retrieve the data from the table or database. Here,…

Q: Write a procedure named prc_cust_add to add a new customer to the CUST_MYSQL table. Use the…

A: Creation of the table: Assume that the table CUST_MYSQL is empty because the database is not…

Q: create table branch(branch_name varchar(30) primary key, branch_city varchar(30), assets varchar(60)…

A: Given: create table branch(branch_name varchar(30) primary key, branch_city varchar(30), assets…

Q: Please help me to transcribe SQL codes to python codes create table ab as select * from ali WHERE…

A: import mysql.connector mydb = mysql.connector.connect(host="localhost",…

Q: 4. Write two queries to list the ID of all the authors that do not have any books. a) Using a join:…

A: The requirement is to fetch the author_id from author table for the records where there is no…

Q: You are not required to execute the queries. However, your syntax must by accurate.You must give at…

A: Hey, since there are multiple sub-part questions posted, we will answer first three questions. If…

Q: Rewrite the query below to exclude vendors from TN or KY: SELECT VENDOR.V_CODE,…

A: I have given an answer in step 2.

Q: PLZ HELP WITH THE FOLLOWING: make the following work select MOVIE_NAME, MOVIE_YEAR from MOVIE…

A: Given,    List movie title and movie year for movies that have a movie cost is greater than…

Q: Why i am getting this error in the below query   Here is the query -    List productList =…

A: Required:   Apex SOQL - salesforce object query language Why i am getting this error in the below…

Q: Which of the following statements is valid? (refer to the tables in the JustLee Books database.)a.…

A: Valid statement The SELECT statement returns a result set of records from one or more tables. It…

Q: Emp ld First name Anil Last name Salary Overtime Manager_ld 320 10 Ramon 500 18 |16 18 17 18 16 11…

A: 1.) SELECT * FROM Employee WHERE salary > 500ORDER BY Country Manager_id;

Q: Write the SQL statement to display product name and prices from the product table. Table Name:…

A: Product Table Creation: create table Product(  Product_ID Number(3),  Product_Name varchar2(30),…

Q: You have been instructed to add a new student information to the students table. Because the student…

A: You have been instructed to add a new student information to the students table. Because the student…

Q: Write a SQL statement that will display product ID with alias Prod_ID" and product name with alias…

A: Required:

Q: Draw the ERD TI e ithat is implemented by the following SQL code: CREATE TABLE PROJ_USER USER ID…

A: ER diagram: The ER diagram for the given SQL code:

Q: Add the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh…

A: 4. Show the doctor's names, degree and salary for all doctors who hoint between 2010 and 2015 select…

Q: BASIC JQUERY ... Make a simple portfolio using JQuery (link below), provide much detail as…

A: It is a simple portfolio using JQuery. As it is difficult to paste all the code here so i am…

Q: Why this give me an error The INSERT statement conflicted with the FOREIGN KEY constraint…

A: Answer: Because you donot insert any rows into the Suppliers table

Q: c) Write the standard MYSQL query to retrieve the Name and CustNumber of customers with a balance…

A: In the question it is asked for retrieving the Name, But in the CUSTOMER table there is column name…

Q: Rewrite the query below to show only those products with P_INDATE prior to 2018 and P_DISCOUNT equal…

A: Since you have asked multiple questions in a single request we will be answering only the first…

Q: When we choose to display only a partial set of the fields from a single table, we are using the…

A: Actually, database is a used to stores the data.

Q: Inserting data 10. Enter your own information in the student table. For example, I entered the last…

A: Above given Student table with the fields:- Id,name,dept_name and tot_cred. Now I am inserting 3…

Q: A manager at JustLee Books requests a list of the titles of all books generating a profit of atleast…

A: SQL query statement: In the books table, there are two columns cost and retail which specify the…

Q: Change these SQL query statements to XML Statements select distinct company_name from (employee…

A: Extensible Markup Language (XML) Extensible Markup Language (XML) is a markup language that…

Q: Create table sales ( sales_no   number (4), sales_date   date ); Insert into sales values…

A: --creating tablecreate table orders(order_number number primary key,order_date date,ship_city…

Q: Write an SQL query for printing the details of DEPARTMENT name as "Admin". WORKER_ID FIRST_NAME…

A: Given, Table:

Q: Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients…

A: Answer :--  Jan-12-01

Q: •Create and load the Employee, Department and Titic Tavics: ton •Write Queries for the following:…

A: Since multiple queries have been asked to be answered, we will answer first three queries. If you…

Q: Which one is correct Select the constraint (if any) that is violated by each the following…

A: The Entity integrity constraint states that primary key value can't be null. -------- Domain…

Q: ow can I write an SQL SELECT Queries for each of the information requests?   List the…

A: List the Patients_Full_name, PatientsID, Patients_State, and Patients_Zipcode who has an…