consider the following tables: Table name: sales salesman_id 5001 city name commission John Paris 0.15 James New York 0.13 Neel 5002 5005 Rome 0.11 5006 lla Paris 0.13 5003 Jordan Mexico 0.12 Table name: customers customer id Cust_name city Nick grade salesman_id 100 3002 Paris 5001 3007 David New York 200 5001 3005 London 5002 Jozy Julian 200 3008 Paris 300 5003 3004 Brad New York 100 5003 Perform the following queries on the above tables: 1. Create the above tables using the validations of your choice. (4 Marks) 2. find the salesperson(s) and the customer(s) he handle. Return Customer Name, city, Salesman, commission. (3 marks) 3. Display the customer information who have salesman associated with them.

Q: I need help with the SQL query for the following question: 1. Get top 5 list of products liked in…

A: QUERY: Creating table: CREATE TABLE Reviews(     ProductModelName text,     ProductCategory text,…

Q: Write sql query to create given table.

A: Given, Table:

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: For the below given schema diagram develop a SQL query to find the guest name whose total bill…

A: According to the given problem statement we are required to develop a SQL query to find the guest…

Q: Using the the Employees table below write an SQL query which displays Last Name, First Name and how…

A: As per the table above, we have the ID, LastName, FirstName, Birthdate, Payrate, and HoursWorked…

Q: Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE DATE SALARY DEPARTMENT…

A: The name of the given table is Employee. It has six columns named EMPLOYEE_ID, Name, EMAIL,…

Q: Find the numbers that has not been used as DEPTNO in the DEPT table.

A: you can use this query

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: Write SQL Command to display employee first name , department name and the county id.

A: i have provided answer in step2.

Q: Write SQL statement that retrieve the department_name that has the maximum number of employees:…

A: The given is the requirement to find the department_name from depart table for the department that…

Q: Analyze the given tables showing the information of different candidates and departments. You are…

A: => here in the question given 2 tables one is Candidates and other one is Departments

Q: Refer the given tables and answer the question that follow: Table : PURCHASE_ORDER ORDER_NO AMOUNT…

A: Answer: a) SELECT * FROM PURCHASE_ORDER; SELECT ORDER_NO,ORDER_DATE FROM PURCHASE_ORDER WHERE…

Q: a Write in SQL a command that creates the table Products according to the above description a. Write…

A: Given :

Q: List the names of places from which the company sells in the form of a query in Microsoft access.…

A: The objective of the question is to create a query in Microsoft Access that lists the names of…

Q: Course • Courseld CourseCode CourseName Capacity Instructorld 3815 ENGL862 American Literature 75 2…

A: The question requires us to write a SQL query that will return the details of instructors who teach…

Q: Write the SQL code required to list the first name and last name of all customers whose middle…

A: Writing the SQL code required to list the first name and last name of all customers whose middle…

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: an SQL query to find the names of the airlines that have at least 10 Boeing 737 in their fleet.

A: The above given question is to write the SQL query to extract the names of airlines that have…

Q: Write SQL Command to display all employees details whose job id is either AD_VP or PU_MAN. Order the…

A: We are given Employess table which contain all the attributes asked in query, so we will use…

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: For each sale made on June 1, 2015, show the following information: CustomerID, Customer name…

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

Q: Ph_No Bank Code Name Addr Branches N Bank Branch Bank Name Addr Branch No

A: When you make 1 to N relationship ,then automatically the class which has 1 written on it ,pass the…

Q: eate the table that results from EMPLOYEE PRODUCT DEPT I am unsure of what to do here. I f the…

A: Description:   1- No, don't need to create a DEPTNAME column in two places.  2- Create a column name…

Q: CUST_ID 78   CUST _ID 54     NAME YORK UNIVERSITY   NAME SENECA COLLEGE     LOCATION…

A: Given, CUST _ID NAME LOCATION SALES_REP 78 YORK UNIVERSITY NORTH YORK ANDRE MARTIN 54 SENECA…

Q: Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN ID DELIVERY_ DATE 1001 300…

A: b) SELECT * FROM PURCHASE_ORDER INNER JOIN PURCHASE_DETAILS ON PURCHASE_ORDER.ORDER_NO =…

Q: price 29.8.29 m sell city store sid S1001 S1002 $1003 store table sid city Union Edison Newark sid…

A: In the ER diagram we can see that we have the three entities those entities are  Store , sell and…

Q: Customer ID Name Address Phone Card Password Usernam number number Employee

A: ERD diagram is given below

Q: Write an SQL statement to create tables with details given below Table: LIBRARY Book_ID Book_Name…

A: Here, We have to create two tables.

Q: REQUIREMENTS TABLE: Field Name Data type Field size Constraints Content / Description REQUESTS…

A: The Staff and Admin has many attributes common and hence it seems Admin is sub-type of Staff entity…

Q: departmant ID invoice InvoicelD Product product_id Employee phone Department_id Department_name…

A: Normalization is the technique or process in which the removal of redundant data from the database…

Q: Write the standard MYSQL query to retrieve the average customer balance grouped by SalesRepNo Write…

A: I have provided answers in step 2.

Fundamentals of Datawarehouse

A data warehouse is a data repository which is used to store large quantities of historical data that are mostly used for creating reports that help businesses to identify their weaknesses and strengths. For example, demographics data about people of a region can help businesses identify the needs and preferences of the region’s population. A data warehouse acts as a central storage for storing data that comes from one or more heterogenous sources. It also consists of data which can be old and of historical value. One of the most important applications of this type of system is that it is used for supporting business intelligence and data analytics applications.