There are 9 workers for ASH Development Sdn. Bhd. as shown in Table Q4. Unfortunately, there are only 4 rooms available for these workers. Every week, a worker name is randomly selected to do odd jobs for the company. When a worker has been selected randomly, a these rooms are full. Based on Figure Q4, worker's ID number 0 (Umar) is randomly selected for the first week, and the 4 boxes represent 4 rooms for room needs to be vacated if workers.
Q: StayWell has increased the monthly rent of each large property by $150. Update the monthly rents in…
A: Actually, database is a used to stores the data.
Q: Problem 4 Select all employee's name and bonus whose bonus is < 1000. Table:Employee | empld | name…
A: GIVEN:
Q: If 15% of the product has been returned to the company and the company decided to recycle the…
A: Answer to the above question is in step2.
Q: Computer Science Using the Invoices table (or a variant ... W8A or WK8W), show by vendor ID, the sum…
A: in step 1 first of all i create table in SQL Developers like VENDORS VENDOR_ID (Number, Primary key)…
Q: consider the following tables: Table name: sales salesman_id 5001 city name commission John Paris…
A: Q: Create and perform given SQL Operations
Q: From worksheet sheet3, in cell E11, find the sum of all Total Sales for 2nd half Bonus which are…
A: The given problem is related to MS Excel where the formula is to be used to solve the problem using…
Q: had dout in datastructures: Create the given table and implement the queries: OrderNo PurchaseAmt…
A: CREATE TABLE Purchases( OrderNo int primary key, PurchaseAmt real, OrderDate date,…
Q: nsert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set up…
A: Insert the following customer into the CUST_MYSQL table, allowing the AUTO_INCREMENT attribute set…
Q: Consider the following schema of employees working at Carlson Fabrics Ltd (CFL) and write SQL…
A: Select * From EmployeeWhere emp_name Like 'B%e';
Q: Add the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh…
A: DOCTOR TABLE: CREATE TABLE DOCTOR(Docotr_id varchar2(5),Doctor_name varchar2(25),Degree…
Q: 5. Cars must be ordered from a supplier when the stock for that particular car drops below 8. Find…
A: We have to write Relational Algebra to find the name of all the manufacturers of the cars whose…
Q: ect the constraint (if any) that is violated by each the following operations in questions. Use ples…
A: Here table Student_Course refers to table Course. So when we delete an entry from Course table we…
Q: How did you normalize the following relation? When the PK is (Room#, Reservation#). Name Phone email…
A: Introduction: Normalization is the most popular method of rearranging data in a data collection so…
Q: v three tables that can result by executing each of the following SQL statements. (Put your answer…
A: A. Select the product information which is been ordered. Here productID which is not present in…
Q: There are two types of tables X and Y , let assume the X is the shorter one and Y is more longer.…
A: Java is a high-level, class-based, object-oriented programming language that is designed to have as…
Q: In a city there is a mini market called B-Mart that sells various types of snack. Specified min_sup…
A:
Q: Given the employees of medium-sized semi-conductor firm, find the employee that joined November 8,…
A: The Excel INDEX function returns a value in an array based on the row and column numbers you…
Q: Write a VALID and an INVALID data for each validity check and its field being checked given in the…
A: - The given table has to be filled with valid and invalid data for different scenarios. - The…
Q: (CLO-4] Use the given Student Table to answer the question below: Graduation Date Major GPA Student…
A: Given SQL query: SELECT Student_Name FROM Student_Database WHERE GPA>=2.5 AND GPA<=3.5 This…
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: Three columns and 20 rows make up 'game1' and 15 rows make up 'game2' in this example. Both tables…
A: Degree and Cardinality: The number of characteristics or columns in a connection is referred to as…
Q: (check all that apply) Find all the employees located in DallasA) select ename from dept where loc =…
A: Checking all the given SQL query to find all the employees located in dallas,Creating table from the…
Q: e the following extract from SUPPLIES: PNR PRODNR PURCHASE_PRICE DELIV_PERIOD 0185 32.99 0185 33.00…
A: Here in this question we have given a SQL query and we have aske that what will be retrieved if we…
Q: Write SQL statements and relation algebra for following: Student( Enrno, name, courseId, emailId,…
A: The SELECT statement is a DML(data manipulation language ) command used to retrieve desired columns…
Q: Write SQL query for following consider tableEMP(empno , deptno, ename ,salary, Designation,…
A: The Structured Query Language (SQL) is used for database access, insertion, deletion, and updating…
Q: Consider the following schema: Employee (Ename , EID, EDept, ERank, EAddress) Convert the following…
A: For the given query statements, we have to write the Relational Algebraic Expression.
Q: d Karachi 20,000 01 02 Sanaullah Peshawar 30,000 02 03 Imran
A: Consider you have the following 2 tables. Employee_Table Employee_ID Employee_Name Address Salary in…
Q: Below is a sample data for Parts and for Vendors who supply those parts. In discussing these data…
A: Actually, given information is: uniquely identify parts and that vendor names uniquely identify…
Q: 2. Write a SQL query to solve Question-2-2 (the second sub-question). 3. Write a SQL query to solve…
A: Answer: Looking up for the rating of a sailor using his/he need creating a clustered index in the…
Q: Use the XYZ Apartment Rental Company ERD shown on Figure 1 to answer questions 9 through 12:…
A: In the given ER diagram , We have three entities BUILDING, BUILDER and a Weak entity APARTMENT. For…
Q: From the Salesman and Customer tables below, write SQL statements to do th following: a) List the…
A: Actually, SQL stands for Structured Query Language.
Q: The property managed by Columbia City with the address "105 North Illinois Rd." is in the process of…
A: We can change the value to null using the below query UPDATE LARGE_PROPERTY SET BDRMS = null WHERE…
Q: Use the Relational algebra to retrieve the First names (Fname) and Salary of all employees in…
A: Provided the relational algebra for the above given query is given as shown in the below attached…
Q: Student( Enrno, name, courseId, emailId, cellno) Course(courseId, course_nm, duration) i) Add a…
A: Q: As per bartleby policy, we can only answer 3 subparts per question. Please post rest of sub parts…
Q: Show all item num from the item table, and a matching quoted price from the order line table (show…
A: I have Provided this answer with full description in step-2.
Q: Use the Relational algebra to retrieve the First names (Fname) and Salary of all employees in…
A: WORKS_ON ⋈ WORKS_ON.Pno=PROJECT.Pno and PROJECT.Pname="ProductX" and WORKS_ON.Hours>10 and…
Q: Vacation days are based on status. Using the information in the lower table below, do a lookup in…
A: A lookup function is used to match a lookup value in a one-column or one-row range, and returns the…
Q: You are given N customer data whereeach data contains AccNumber, name, age, and ballance. The…
A: Create a structure named as Customer which will hold data of one customer. Start :- Read N Create…
Q: Input: The issuer table, with respective columns: Issuer Parent ESGRating, separated by Output: • If…
A: According to the information given:- We have to create to read the issuer table with respect to…
Q: Considering the following tables,. is a foreign ke Student Table SID Name Expected Graduation 123…
A: To know which among these is the foreign key we have to understand first what is foreign key…
Q: The table below contains training data from an employee database. The data have been generalized.…
A: The answer is given below:-
Q: In cell D5, create a formula using the VLOOKUP function to determine the cost per participant for…
A:
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: There are two types of tables X and Y , let assume the X is the shorter one and Y is more longer.…
A: Given: There are two types of tables X and Y , let assume the X is the shorter one and Y is more…
Q: Using the Schema - data/statistics.Transform following SQL queries into Relational Algebraic…
A: Required : SQL query to relational algebra query Note : As per guidelines of company, we are…
Q: d (column H) first. What is the average Sales Price for all the properties with 2or as and more than…
A: <Use LIST worksheet> Now by calculating the "Days on Market in column L by finding the…
Q: We have two tables: • employees - This table contains each employee's ID, name, and department ID id…
A: SQL script is given as
Q: There are two types of tables X and Y, let assume the X is the shorter one and Y is more longer. the…
A: Steps followed to create the program using blocks: Go to the Data tab and create 9 variables 3 for…
Q: Q19) List all product rows (including the ones that have no matching vendors) and all matchingvendor…
A: Note: Since you have posted multiple sub-questions in the same request, we will solve the first…
Step by step
Solved in 3 steps with 2 images
- Below are some rows of the PROVIDERS table for a factory: PCODE NAME PHONE 10192 Hans, Inc. 231 - 3092 98411 Tools and More 231 - 1029 0489035 Motors Inc. 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? a. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘%231%’ b. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘% 231’ c. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘___ 231 ___’ d. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’How do you indicate that a column alias should be used?Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
- Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered To Price per Roll From 1 70 $215 71 140 $195 141 280 $175 281 and up $155 Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. (b) Use the COUNTIF function to determine the number of orders in each price bin. From Number of To Price per Roll 70 $215 !!! 140 $195 280 $175 and up $155 1 71 141 281 Orders 172USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two columns basedon how many orders the customer has in the database. The first column is the customer name andthe second column, Membership Type, is based on which case applies to the customer:If the customer has more than 25 orders they are a Diamond Customer.If the customer has more than 15 orders they are a Gold Customer.If the customer has more than 10 orders they are a Silver Customer.If the customer has more than 5 orders they are an Iron Customer.Otherwise the customer is a Valued Customer.Part II: Complete the following exercise: Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state. Using your student table select all students with ZIP codes between “23164” and “98164”. Using your student table select all students where states are in Florida and New York. Using your student table select all students where the last name starts with an “S” and is at least three characters in length.
- Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1. 30 $215 31 60 $195 61 120 $175 121 and up $155 Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number Orders 30 $215 31 60 $195 61 120 $175 121 and up $155 172Choose the SELECT statement that returns the given results from the Auto table below. ID Make Model Type Year Price 1 Toyota Camry sedan 2016 9800 2 Ford Escape crossover 2015 15900 3 Honda Civic sedan 2016 10200 4 Volkswagen Golf compact 2014 8800 5 Toyota RAV4 crossover 2016 12800 6 Toyota 4Runner suv 2015 16900 7 Honda CR-V crossover 2016 17900 Result : Honda 2 Toyota 3 Select Make, Count(Make) FROM Auto Group By Make; Select Make, COUNT(Make) From Auto Group By Make Having Count(Make) > 1; Select Make, Count(Make) From Auto Group By Make Having COUNT >1;Find the first names and last names of employees if they got a salary increase more than 10% in the first month of 2000 together with their salary change dates, old salaries, new salaries, and increase percentages in descending order by their increase percentages.
- After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides to decrease the monthly rent of any property whose monthly rent is more than $1750 by 1%. Update the monthly rents in the LARGE_PROPERTY table accordingly.CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the appropriate attribute name for each of the column. custID 123 124 125 126 reservelD 5001 5002 5003 5004 5005 5006 5007 RESERVATION Each reservation is for one taxi. Reservation table is composed of reservation identification number, start reservation date, end reservation date, reservation days requested by customers starting from reservation date until end of reservation date, customer number that make the reservation and taxi number assigned to the reservation. Give and fill-in the appropriate attribute name for each of the column. taxill custName Ahmad Bin Abdullah Fatimah Binti Adam LAI LA2 Ruqayya Binti Idris Sulaiman Bin Daud LA3 LA4 startDate 01/10/2019 05/10/2019 05/10/2019 15/10/2019 20/10/2019 27/10/2019 02/11/2019 taxiType endDate 03/10/2019 12/10/2019 08/10/2019 17/10/2019 25/10/2019 Sedan Sedan Van Van 30/10/2019 04/11/2019 cust Phoneno TAXI Taxi table is composed of taxi…INPUT TABLE You're given a orders table and the columns in the orders table are shown below: Orders Order_Id INT Type VARCHAR(10) Red_Shipping_ Days INT Scheduled_Shipping_Days INT Customer_Id INT Order _city VARCHAR(20) Order_Date DATE Order_Region VARCHAR(15) Order_State VARCHAR(20) Order _Status VARCHAR(20) Shipping_Mode VARCHAR(20) QUERY Calculate count of all the orders. Where Order_ State is Maharashtra Note - Use the alias of oc for count of orders Group the results by Type Order them by oc in ascending order. OUTPUT COLUMNS oc, Type