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 Display the Product ID, Description, and Quantity (QTY) of all the products in the PRODUCTS table whose PID is from 801 to 802 and whose quantity is less than 15.

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: Examine this product table's column definitions: pid number primary key pname varchar2(50) You must…

A: Given:

Q: Display the maximum price of all the products in PRODUCTS table for each Supplier ID having a…

A: Here we need to join Table Supplier and PID. Since they have common attribute,they can be joined…

Q: Display the PID as “Product ID”, Desc as “Description”, and SName as “Supplier Name” with their…

A: Here we can use AS operator to rename the query. Also use JOIN clause using the JOIN On condition.

Q: Show students’ first name, last name, the grades of the students, and the credits of the course for…

A: Select St.FristName, St.LastName, Et.Grade, C.CourseIDfrom Student St INNER JOIN Enrollment Et ON…

Q: Based on the ERD below, display the assignment number, employee number and assigned hours for either…

A: Here we are joining three tables ASSIGNMENT, EMPLOYEE, and JOB and the assigned job is either 501 or…

Q: Cust_id (NOT NULL) Txn_date (Not NULL) Txn_type (NOT NULL) Txn_amount (NOT NULL) 1 2020-01-21…

A: The CREATE TABLE statement is used to create a new table. Syntax: CREATE TABLE table_name (column1…

Q: List every column in the Condo_UNIT table and its associated typ

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

Q: CIS111 Chapter 5 Lab Problems 3. Display the vendor name, number of invoices, average and total…

A: The following example shows three code examples. This first code example returns all rows (no WHERE…

Q: Consider the following PRODUCT table (Primary key underlined). True or False: The two last rows are…

A: Dear Student, Only the primary key column must contain  unique items, other column can contain same…

Q: 1. Use the following table to answer the questions below. Table name: Products Column Role Data Type…

A: We have to extract year from the Date filed and then the year has to be 2021  Now, we have to count…

Q: Display first name, last name and job title of all employees.

A: NOTE - Here I have Oracle SQL to solve the given problem. I have used the Select statement to…

Q: See the following table CREATE TABLE product ( product_id NUMBER(3), product_name VARCHAR(30) NOT…

A:

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: 1. Display the last name and salary for all employees whose salary is not in the range of $5,000 and…

A: As per the database question we will give the query for all of them. 1. select last_name, salary…

Q: i. Insert all rows from Product table into Parts table by using subquery. ii. Find the average of…

A: SELECT query will fetch the result and the same will be inserted to another table using INSERT query…

Q: Write the SQL code to add sample data (1 row for each table).

A: Insertion into table USERS:- INSERT INTO USERS(USER_ID, USER_NAME, USER_TYPE, USER-LIMIT) VALUES…

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: Convert the table "Vehicle" into BCNF normalization and please explain how to do it. In the table,…

A: A relation is said to be in BCNF if all its functional dependency is of type x->y where X is key…

Q: Display only the products (name and ID) that have a quantity greater than the average quantity of…

A: Displaying   the products (name and ID) that have a quantity greater than the average quantity of…

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: SUPPLIERS   SID SNAME STYPE LOCATION 1 Lulu DS Salalah 2 C4 DS Saadah 3 Smile WS…

A: Here first we need to find SID of product 802. Let's name this as X. Then find productID and…

Q: Happy Shop sells different products to the customers. A customer could buy one or more products at a…

A: Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…

Q: Create the INVOICE table structure illustrated in Figure P8.16. INV_NUM should store integer values.…

A: Since database is not mentioned I am assuming Oracle database.

Q: Happy Shop sells different products to the customers. A customer could buy one or more products at a…

A: Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…

Q: Display product ID, product name, and category ID for products of the category(s) that the lowest…

A: In programming a domain specific language is used, which is called SQL or standard query language.…

Q: Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors'…

A: Attribute (Simple): Simple qualities are ones that cannot be further subdivided. For example, in the…

Q: Using the STUDENT table structure shown below, normalize the table to BCNF. ample STUDENT Records…

A: About BCNF: it is advance version of 3NF. in which  every functional dependency x->y, x should be…

Q: 1. List the Customer Id, Last Name for all customers, sorted by Last Name, ID. Table "Customer Id"…

A: As per our company guidelines we are supposed to answer only first 3 sub-parts. Kindly repost other…

Q: amed company with these columns: Company_id varchar(255) Company_na

A: Create a table named company with these columns: Company_id varchar(255) Company_name varchar(255)…

Q: Table Name: SUPPLIERS…

A: Insert the given data in SUPPLIERS TABLE: INSERT INTO SUPPLIERS VALUES(1, 'Lulu', 'DS', 'Salalah')…

Q: Problem 1. Using the INVOICE table structure shown in table below do the following: INVOICE…

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104

A: update command is used to change the cell value and the condition is specified

Q: the employee table have the following . ask user what is the employee_id and how much employee…

A:

Q: nter Employee Id : 101 Enter Enployee Id : nter Employee Name : John Hathew Enter Employee Nane ter…

A: I have written code below:

Q: Branch Table BranchNo Name Kileleshwa Location B001 567, Kileleshwa 890, Karen 894, Rongai B002…

A: Here, Query instruction is given.

Q: Using the STUDENT table structure shown, do the following:   Attribute Name Sample Value Sample…

A:

Q: Create the ROOMS table using the specification below: Table Name: ROOMS Field Name/ Data Type Size…

A: First, create table clients to give reference to the rooms table. In the client table, CID is the…

Q: Display a list of all book titles and the percentage of markup for each book. The percentage of…

A: ROUND function The ROUND function is defined as a numerical function in Oracle or SQL to round the…

Q: Select "Patent Number Search" for patents. Give the title or brief description for each of the…

A: Question = Select "Patent Number Search" for patents. Give the title or brief description for each…

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: SID SNAME STYPE LOCATION 1 Lulu DS Salalah 2 C4 DS Saadah 3 Smile WS Awqad PRODUCTS…

A: Dear Student, To increase the 20% value we need use the UPDATE instruction along with some…

Q: Use Employees table to display the department id and highest salary with the column name "Highest…

A: The Answer is

Q: Display details of employee with ID 150 or 160.

A: We need to write a query to display the details of employees whose ID is 150 or 160. We have a table…

Normalization

Normalization is the process of eliminating redundancy in a database by organizing the data into several smaller tables. The large tables are normalized (converted) into smaller tables by using normalization rules, so that a database administrator can easily handle them. It also eliminates insertion, deletion, and update anomalies.