Product Name Sales Rep Country   Product 1 Paul China   Product 1 Paul Singapore   Product 1 John India   Product 2 Joe Canada   Product 2 Joe China   Product 2 Joe India   Product 2 Harry US   Product 3 Tom India   Product 3 Paul Japan   Product 3 Mike Japan   Product 4 Racheal US   Product 4 Paul Indonesia   Product 4 Mike Canada   Product 5 Stephen India   Product 5 Stephen Philippines           1. Sort table above first by Product (asc), Sales Rep (desc) and Country

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: CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the…

A: Answer:- Atrributes: It is a column in a table Table CUSTOMER: Atrributes : 1.custID( Type),…

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

A: you can use this query

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

A: GIVEN: PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6…

Q: List the names and number of employees supervised (label this value HeadCount) for each supervisor…

A: List  the  nаmes  аnd  number  оf  emрlоyees  suрervised  (lаbel  this  vаlue  HeаdСоunt)  fоr  eасh…

Q: Show all female’s first names and their salary.  Show the branchno that has a supervisor whose…

A: Relational database is a type of database which stores and provides the access to data which are…

Q: explaining why Column chart type selected and why this type was chosen. What is column chart

A: A column chart is a type of chart used to visualize data in the form of vertical columns. Each…

Q: Q9) find the least expensive price Q10) List the UNIQUE v_code of vendors that provide products Q11)…

A: A relational database contains tables. Tables are also known as relations and they contain tuples…

Q: There are 9 workers for ASH Development Sdn. Bhd. as shown in Table Q4. Unfortunately, there are…

A: According to question there are 9 workers and 4 rooms. The Ids of workers selected for the jobs are…

Q: Write a function and name it add_four_nums that takes in 4 parameters as integers (no strings),…

A: JavaScript and HTML code to add the sum of three number and complete Onclick function in input tag.

Q: creat the following tables and insert your own values: emp(eno, ename, bdate, title, salary, dno)…

A: The SQL INSERT INTO Statement is used to add new rows of data to a table in the database

Q: E E+TIT T- TXFIF F>(E) la

A: The Answer is

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition.  student…

Q: data dictornary of this for making tables

A: For 1 to many relationship , we make two tables. All relationships here are 1 to m only. All other…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

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: 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: The table below lists customer/car hire data. Each customer may hire cars from various outlets. A…

A: The SQL statement to insert a record in the table is - INSERT INTO table_nameVALUES (val1, val2,…

Q: D03 Testing Retrieve the Department names and the count of employees work in each Department, but…

A: In this question we have been given with the tables where we need to retrieve the department name…

Q: Find the total revenue generated by each product in the past quarter (last 3 months), you would need…

A: In SQL Server, we can use the DATEADD() function to get last 3 months (or n months) records.

Q: Classify students according to the total number of hours they have completed. (Less than…

A: Note:- There are multiple hours completed columns, two are visible in the first screenshot, assuming…

Q: Employee ID number Employee surname EMPNO Integer Up to 10 characters Integer Integer 7369 SMITH…

A: Given we have to develop a SQL query for the above given scenario:

Q: You have the following table:   MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT)   Write…

A: Stored procedures in a relational database management system (RDBMS) are powerful tools for…

Q: In the Summary sheet, calculate average and median sales and commissions. Use the named ranges shown…

A: To calculate the average and median sales and commissions using the named ranges shown in cells…

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: List the names of all Staff members who hold a faculty position and have a salary of $45,000 or…

A: SQL Space: To leave the space while displaying the data ,a function called space is used. Syntax:…

Q: Calculate count of all the orders. Where Order_ State is Maharashtra Note - Use the alias of oc…

A: Alias is used to give an alias name to a table or a column.   Syntax to be used SELECT…

Q: Assume the EMPLOYEE table contains four attributes, ID, DEPT, SALARY and NAME, and has the following…

A: In the context of relational databases, this discussion revolves around the creation of an EMPLOYEE…

Q: Find the total revenue generated by each product in the past quarter (last 3 months), you would need…

A: Orders, Order_details, and products are the three main tables whose data we need to use in order to…

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.