11. In a Database Company, there are two tables given below : Table : SALES Table : LOCATION SALESMANID NAME SALES LOCATIONID LOCATIONID LOCATIONNAME ANITA SINGH ARORA 250000 102 101 Delhi $2 Y.P. SINGH 1300000 101 102 Mumbai S3 TINA JAISWAL 1400000 103 103 Kolkata S4 GURDEEP SINGH 1250000 102 104 Chennai $5 SIMI FAIZAL 1450000 103 Write SQL queries for the following : () To display SalesmanID, names of salesmen, LocationID with corresponding location names. (#) To display names of salesmen, sales and corresponding location names who have achieved Sales more than 1300000. (m) To display names of those salesmen who have "SINGH' in their names. (") Identify Primary key in the table SALES. Give reason for your choice. Write SQL command to change the LocationID to 104 of the Saiesman with ID as $3 in the tabie ICBSE OD 15) "SALES'.

Q: Explain what each line of the following code does and what data is created and stored (both in regis...

A:

Q: Check the time of Vladimir as he arrive in his home

A: In this question, we are asked to write a java program which as per the given flow chart Explained e...

Q: Microsoft Excel 2016 includes a slew of new and improved features. What do you believe the most usef...

A: Introduction: Excel 2016 included "one-click" statistical forecasting for data with a temporal compo...

Q: With the logical operator both conditions must be true for the * .entire condition to evaluate True

A: The above selection is like With logical operator AND  , both condition must be true for the entire ...

Q: Why is it vital to display accounting and financial data in an appealing and easy-to-read format? Wh...

A: The answer is 

Q: Explain what the CPU should do in the event of an interrupt. Include the mechanism the CPU employs t...

A:

Q: Write a C# program that using loops keeps asking the user to enter a number until the 5th even numbe...

A: We will run the while loop till the value of count reaches 5. Inside while loop we will check whethe...

Q: from typing import List def count_odds(values: List[List[int]]) -> List[int]: "" "Return a list of c...

A: I give the code in Python as per your requirement along with output and code screenshot

Q: Write the primitive counting results for your 40 sheep: 40= For example, the answer for "14" would...

A: - We need to write binary conversion of the number 40.

Q: Kindly give proper and correct explanation Need help asap. QUESTION: For the destructor: when it co...

A: The problem is based on the basics of object oriented programming.

Q: Source papers, according to some system experts, are superfluous. They claim that all data should be...

A: Answer : Yes , i agree with your statement.

Q: Identify Testing Types a. John is a manual tester working for a Retail Company. He is currently test...

A: the answer is given below:-  

Q: sql

A: SQL COUNT() function with DISTINCT clause eliminates the repetitive appearance of the same data. The...

Q: What is the output of the following code, show your work on white paper and attach it in the classro...

A: Given code (numbered) , Num = 9 Be = 9 S = 1 Do Until ( Num <= Sqrt(Be+7) ) S = S * Num Num = Nu...

Q: ne orcgam beg 151one 32-5:vcc orelsadec re dea mero, te segning sthe cate segrer a:access Cx10000cO....

A:

Q: (13.)Write a function slope(x1, y1, x2, y2) that returns the slope of the line through the points (x...

A: def slope(x1,y1,x2,y2):    return (y2-y1)/(x2-x1) print(slope(5,3,4,2))print(slope(1,2,3,2))print(sl...

Q: Given the IP address:  181.122.75.75/26 (basis is /24) Determine the following addresses for subnet...

A: IP Address: 181.122.75.75 Network Address: 181.122.75.0 Usable Host IP Range: 181.122.75.1 - 181...

Q: How to writte a code as a class that inherits from Tk and the application must resize gracefully ? P...

A: Find the code given as below :

Q: Simplify the following expressions according to the commutative law. a) AB + BA + CDE + CDE - ECD b)...

A: Commutative Law: It states that when two numbers are added or multiplied, the final value remains th...

Q: What is the d-ary tree's minimum feasible depth?

A: INTRODUCTION: The depth of a tree can be defined as the shortest path between the root and the tree'...

Q: Remove the left recursion from the productions: E →E+T|E- T|T T→T* F|T/F | F

A:

Q: Explain the usage of three distinct methods by which an attacker might force a victim to submit DNS ...

A: Domain Name Server (DNS) Spoofing is a cyber attack that tricks your computer into thinking it’s goi...

Q: Order By/Functions Using the database provided, Write and Execute SELECT statements to get the follo...

A: Answer: Our instruction is answer the first three part from the first part and I have given answered...

Q: What are the four methods for implementing a system conversion in an organisation?

A: We have asked for the 4 methods for implementing a system conversion in an organization.

Q: Use block diagram to determine the sum generated by 5-bit parallel adder and show on the diagram the...

A: Let A=11101, B=01010 A=A4 A3 A2 A1 A0  ==>A4=1, A3=1, A2=1, A1=0 , A0=1 B=B4 B3 B2 B1 B0==> B4...

Q: cte: The D= 1195003-2 is crl, ar exampecu shoulc Jse cur C= irsteac ne pogramsnculdore ray crelcaced...

A:

Q: What is the most popular programming language and interface for developers in the world's software h...

A: JavaScript (JS) is one of the most popular programming language for developers in the world's softwa...

Q: Define the associations between entities and cardinalities using the following business rules: Ther...

A: Introduction: Entities in this context include the terms "university," "school," "department," and "...

Q: Suppose you have an investment plan where you invest a certain fixed amount every year. Modify futva...

A: They commitment of an asset to improve in value over time is referred to as investment. Investment n...

Q: Find all strings in L(ba + ab*a) of length less than four. Find a regular expression for the set { a...

A: Length = 0 This regular expression does not generate the empty string Length = 1 No strings Length =...

Q: Draw the logic circuit represented by the following expression. X= A+ B[C + D(B+ C)]

A: Logic circuit... Given: X=A+B[C + D(B +C)]

Q: The solution determined by the manual methods is called as the ___________. Group of answer choices ...

A: 1.  Answer : Analytical solution Analytical solution is a solution, which can be calculated manually...

Q: o Do: LinkedList.h: add a new Node* called tailPtr which points to the last item in the list   @f...

A: I have created a variable tailPtr of type ItemType. I have also created a function signature, moveTa...

Q: #include #include #include #include int counter = 0; void child(O { counter += 7; } void parent(...

A: Answer: I have done code  and also I have attached code as well as output   

Q: This question assumes the machine architecture at the right. Note the stack pointer register, SP, is...

A: Given Question

Q: What exactly is metric? Who examines it? What is the significance of this? Describe the metrics used...

A: - We need to talk about metric.

Q: In what ways might cryptocurrencies be adopted over the world?

A: Introduction: There are several impediments to cryptocurrency adoption on a global scale. Several of...

Q: partition contained within the USB flash? I am using virtual box and Linux mint.

A: Here have to determine about forensic copy of a partition contained within the USB flash.

Q: WHAT IS CRYPTOCURRENCY AND HOW DOES IT WORK?

A: Cryptocurrency: Cryptocurrency is the digital or online currency that used in a system of payment th...

Q: 4- A multiplexer has N data inputs and M select inputs, to determine the number of select input it d...

A: As per the answering guidelines solving the first 3 sub question 4) The given statement is FALSE Her...

Q: Convert: 12-j42 to polar form Answer format: modulus, argument

A: The polar form of the complex number is given below. It is calculated by using r and theta.

Q: B. Define a function R0ToR10 that converts a radix 0 numeral to a decimal number.

A: It is defined as the type of Number Representation techniques, in which there value of base is 16. I...

Q: Describe Ethernet in detail. Take note of the topology that Ethernet is built on. Explain the differ...

A: Answer: A Local Area Network (LAN) technology, Ethernet is used to link devices that are relatively...

Q: Question 4 Consider a disk drive that has a capacity of 8 Gigabytes (assume 1GB = 1,000,000,000 byte...

A: 8,000,000,000/(2*5*10,000*200) = 400 bytes per sector

Q: Calculate the area of circle when radius = 20, area = TR² with explanatory words print about result.

A: For the required MATLAB program, we will define a function handle for calculating the area of the ci...

Q: i have output in terminal like this: [[22, 31, 32, 100, 16, 17, 23, 24], [5, 25, 26, 100, 10, 11, 1...

A: There are lot of inbuilt python libraries which can help you do this  some of them i am listing here...

Q: What is the difference between a splitstream upgrade, patch, release, and version in terms of system...

A: System maintenance is a blanket word that refers to a variety of different types of computer or serv...

Q: Load your bag with some initial values, but do not fill it. Your client code should give the user th...

A:     Array Bag   import java.util.*;   public class ArrayBag implements Bag   {   private Object[] it...

Q: ask 2 → design an information security poster for end users

A:

Q: :) Given the language L=(a + b)* (ba* + ab*) a a. Construct an FA for L (FA is given) b. Convert the...

A: Answer 1. A Here is a Finite Automata Answer 1. B DFA(Deterministic finite automata) As labels, eq...