• Question - how to find all staff fname and direct supervisor's fname. MariaDB [dreamhome]> select * from Staff1; | staffNo | FName 1Name | position | sex | SA9 | Mary | SG14 Howe | Assistant | F | David | Ford | Supervisor | M Ann | Beech | Assistant IF | SG37 | SG5 | Susan | Brand | Manager | John | White | Manager | Julie | Lee | | SL21 | SL41 | F IM Assistant | F | | | | | DOB | 1970-02-19 | 9000.00 | B007 | 1958-03-24 | 18000.00 | B003 | salary | branchNo | superno | SG5 | SG5 | SG5 | 1960-11-10 | 12000.00 | B003 | 1940-06-03 | 24000.00 | B003 | 1945-10-01 | 30000.00 | B005 | 1965-06-13 | 9000.00 | B005 staff | Mary | Susan David | Susan Ann | Susan Susan | John Julie | John supervisor | | SL21 | NULL | SL21

Q: What type of join is needed when you wish to include rows that do not have matching values?…

A: Refer to step 2 for the answer.

Q: Given the following view that has been created, how would you query the view to list the artist…

A: The correct answer is given below with proper explanation Happy to help you ?

Q: Task 3: The Driver Relationship team wants to create some workshops and increase communication with…

A: Hi .. As per my company rule i can answer to the first question. You can post task 4 as another…

Q: create database CTU__YourICASNo GO USE CTU__YourICASNo; GO CREATE TABLE Course(     CourseID int…

A: Table Course: Table Students: Table Semester: Table Facilitator: Table Module:

Q: name of table 1  Staff_info:  Staffid (pk) Fname Lname Dob Genderid Course_code (fk)…

A: We need to create the mentioned database using MYSQL.

Q: 8A-

A: The above given is a default schema of a database.

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Triggers? Why do they exist? How can I use the trigger features in Access 2016?

A: Triggers be database-specific technical codes that sprint if an exact condition is met for a…

Q: How do you create an index? How do you create a unique index? What is the difference between an…

A: -Creating an index involves the CREATE INDEX command. -it allows us to name the index, to specify…

Q: What are the key distinctions between a full outer join, a complete outer join, and a left outer…

A: SQL Joins The Join phrase is used to combine data from multiple databases into one. Outer left…

Q: Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and…

A: Structured Query Language : SQL is a space explicit language utilized in programming and intended…

Q: Create entity named schedule with attributes schedule_code as characters with size 15, course_code…

A: Query to create the table is:   Create table Schedule ( schedule_code varchar(15), course_code…

Q: What is the primary key of the WorkHours table? Indicate the redundant field in the Employees table.

A: This question comes from Database Management System which is a paper of Computer Science. Let's…

Q: Parking_Number Car_Model Course Marketing lent_ID 2 Toyota 4 BMW Business IT Оpel Ford Hyundai…

A: Given that using the join statement select records that matching in both tables limited to…

Q: Input: SalesPerson table: ----+- +------ I sales_id | name | salary | commission_rate | hire_date…

A: Select name from salesPerson join orders on salesperson.sales_id=orders.sales_id where (select…

Q: Which query would be more efficient? 1. SELECT * FROM customer WHERE city IN (SELECT city FROM…

A: first one query is more efficient than other    SELECT *FROM customerWHERE city IN(SELECT cityFROM…

Q: Please describe the Index metadata relationship in its normalized form, as well as the reasons why…

A: In a database system, indexes are used to speed up record retrieval.A directory in a file is similar…

Q: your submission will be the query that you would write that would return the needed result How many…

A: Below is the complete solution with explanation in detail for the given question about queries based…

Q: First Task: Create Database using PHPMyAdmin that includes two tables: 1. Order (OID, Price, and…

A: Given Task :  Create Database: purchasing  Number of tables: 2 Table 1 :  Name: Order Attributes:…

Q: Given the default schema of a database:

A: Introduction: SQL queries are the queries that are used in structured query languages just to…

Q: what is the Average number of days it takes for a client to receive a visit…

A: SQL queries are the language that is used to update, manipulate and insert the data in the database…

Q: Which types of joins is used to produce the query? A)Right Join B)Left Join C)Inner Join D)Natural…

A: Incorrect options A. Right join is a join that lists each row of a table available on the right side…

Q: Trigger trg_salary will be fired after a row is deleted from the payroll table. Message Payroll…

A: Step 1: “Since you have posted a question with multiple sub-parts, we will solve first three…

Q: The Driver Relationship team wants to create some workshops and increase communication with the…

A: SQL query to create a new table with name,  ACTIVE_DRIVERS that contains the list of specified…

Q: What data types would you use for the attributes in this entity? How would you code a CREATE TABLE…

A: In a database management system (DBMS), an attribute is a piece of data that describes an entity.…

Q: An index may help speed up searches, but creating an index for every property or combination of…

A: Overview: Creating indexes for every trait and every combination of features that may be used as…

Q: The Driver Relationship team wants to create some workshops and increase communication with the…

A: Given Question  The Driver Relationship team wants to create some workshops and increase…

Q: whose age is equal to their manager’s age. First, a nested query: SELECT E1.ename FROM Emp E1 WHERE…

A: Relationship Database Server (RDBMS): The SQL server is a form of database and makes data points…

Q: The Driver Relationship team wants to create some workshops and increase communication with the…

A: A database driver is a piece of software that enables programs to communicate with a database…

Q: Describe joining index?

A: Given:   Describe joining index?

Q: Create the following table in your database with the following schema: Table: Customer +- | Column…

A: syntax to create table:-  create table tableName(column_name data_type constraint); syntax to insert…

Q: Upload answer sheets Normalize the given table upto 3" Nomal Form and describe the tunctional…

A: Primary key for the given relation is (ProjNo, EmpNo)  The functional dependency is ProjNo ->…

Q: You need to run SELECT query and return all travel data from TRAVELS table filtered by the drivers…

A: The driver id in the both tables to be same and the rating of driver in Driver table should be less…

Q: Please write the MySQL query for the following task: Find the first_name, last_name, employee_id,…

A: we can use the following MySQL query:

Q: Task 4: As a part of marketing strategy, the Marketing team continuously conducting an advertising…

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

Q: Wite a SQL query to create gientable. ТАBLE-TITLE WORKER REP_ID WORKER TITLE AFFECTED_FROM Manager…

A: Given, Table:

Q: After converting the ERD to a table design, what fields will be present in the Contracts table?…

A: An Entity-Relationship (ER) diagram is a visual representation of the data model that represents the…

Q: QUESTION 18 The maximum value that can be stored by defining an attribute as NUMBER (5,3) is O a.…

A: Update queries in access databases to add, change or delete the information in an existing record.

Q: Find the staff name who has the maximum salary for each city.

A: The following SQL query will find the staff name who has the maximum salary for each city in the…

Q: Name an example of an attribute in the following table. Student_ID Student Name Student Street…

A: Attributes are defined in terms of their domain. A domain defines the allowable values that an…

Q: The Driver Relationship team wants to work with the active drivers using a VIEW constructed on the…

A: Explanation: “View” command is sued to view the data in table like structure and it is considered…

Q: The Car Maintenance team wanted to ensure that the default price of the maintenance actions should…

A: Explanation of MYSQL:- MySQL is an open source relational database management system (RDBMS) based…

Q: The Car Maintenance team considered that the available maintenance tasks should also have the price…

A: TASK 1: -- Creating a new table MAINTENANCE_TYPES with following fields create table…

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.