6. List the number of department of employees in each project. 7. How many project started in year 2010. 8. How many project started and finished in the same year. 9. select the name of the employee whose name's 3rd character is 'h'. 10. List all the values of project table in ascending order of project name.

Q: The Car Maintenance team wants to learn how many times each car is used in every month and day to…

A: Note: I had filled the table  for reference, you have to fill according to the question reference.…

Q: The Car Maintenance team wants to learn how many times each car is used in every month and day to…

A: The Car Maintenance team wants to learn how many times each car is used in every month and day to…

Q: Retrieve all employees (last name, first name, salary) who work on the "RCM" project name. Order the…

A: SQL QUERY select last name, first name, salary from EMPLOYEE where project = 'RCM' ORDER BY…

Q: Make a list of all course offerings. Provide the course code, start date, course duration, and…

A: Solution:   - Please find responses to questions below - Please let it know if there are any changes…

Q: List full details of departments that don't have any graduate students. Find the name and the age of…

A: RDBMS refers to a database management system that maintains data as a group of tables wherein all…

Q: Give employee Id, name, and date hired of the managers who have the highest experience (years…

A: Note: As per Guidelines provided we can answer only first 3-sub parts at t time plese repost the…

Q: 7. For each project, display project name, project platform, project cost and total number of…

A: In sql, we use SELECT statement to display the table details according to the requirement. We will…

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: Retrieve all employees (last name, first name, salary) who work on the "RCM" project. "RCM' is a…

A: SQL QUERY select last name, first name, salary from EMPLOYEE where project = 'RCM' ORDER BY…

Q: Display the result in a new column name “Remaining Balance”. Include the project number and project…

A: AS is command used to alias name to column

Q: Retrieve the average salary of all employees who works for 'Administration' department    2. For…

A: 1. Retrieve the average salary of all employees who works for 'Administration' department SELECT AVG…

Q: a) name of the advisor of the student who takes highest number of courses?

A: According to the question we have to find the student id who takes the highest no of courses: SELECT…

Q: For each department, the department ID, name and office phone extension are stored. For each…

A: Answer: ABC department store keeps information on departments, products, and employees. For each…

Q: Task 1: The StayWell Property Management team wants a list of all property addresses combined with…

A: Task 1   Explanation: To answer this question, we are going to use PROPERTY and OWNER tables as we…

Q: Based on the ERD below, display the first name, last name and employee initial of anyone whose first…

A: 1) Query to display first name, last name, employee initial whose first name starts 'A' > SELECT…

Q: The details of students such as Student Id, Name, Program, and CGPA to be managed. The list…

A: The details of students such as Student Id, Name, Program, and CGPA to be managed. The list…

Q: Create a new table named ScheduledClients to contain client’s name, the scheduled date of service,…

A: CREATE TABLE ScheduledClients AS SELECT c.ClientName AS ClientName, o.ScheduledDate AS…

Q: Using the company schema, when creating the "works_on" table, the foreign key should be specified…

A: Foreign key specified The foreign key is used for linking two tables together. It is also known as…

Q: Review: Linking Data Tables to Answer an Inquiry Data Table 1: Project Table Project number…

A: Diagram showing Link of tables:

Q: In order for a report to be deemed complete, it must include all of the data from the underlying…

A: A report is a subset of the data in a table.A person can obtain all information.

Q: Display the information about the managers and clerks from the column ‘Job’ in the table emp, order…

A: Answer: SELECT * FROM emp WHERE Job=="managers" OR Job=="clerks" ORDER BY deptno;

Q: Referring to the diagram above, which SELECT statement would appropriately display the customer's…

A: The solution for the above given question is given below:

Q: List the Last Name, First Name and Phone Number of all Agents List the First Name, Last Name and…

A: I am writing a single query for each statement provided above Please execute them as a single unit…

Q: When we use criteria to limit the number of rows that are displayed from a single table, we are…

A: When we use criteria to limit the number of rows that are displayed from a single table, we are…

Q: 4) How many instructors are advising more than three students? 5) Which department has the highest…

A: Here, we have to fetch result based on id present in advisors table   select i.* from instructors i…

Q: D2|ProdList Customer Store Staff Record Customer Info D1 CustomerTbl 2 Record Customer Order Record…

A: In the given diagram, it contains 4 tables that are Customer table, ProdList, Trans table, Inv table…

Q: Q1) Look at the following information which relates to a British university. It shows some of the…

A: The complete answer is given below .

Q: Find the range of salaries (min, max) of each department in the following table:EMP(EID, ENAME, SAL,…

A: EMP is the name of the table Employee.EMP table has four rows named EID, ENAME, SAL, and DEPT. Find…

Q: The Car Maintenance team wants to learn how many times each car is used in every month and day to…

A: Ans:)  In order to perform the above query, I am using a sample database. The database name is…

Q: first last cid quantity name ordDate address Customer custord Order prodord pid Product pname price…

A: In the given ERD, Customer entity and the Product entity are related to the weak entity Order…

Q: How do you use absolute reference in excel?

A: Use of Absolute reference: Absolute reference does not change the values in the cell it just locked…

Q: [2] CUSTOMER PARENT ADT Data Operations Customer ID (preferably int, auto-generated) [1] Add…

A: Include necessary Header files create a array structure with struct variables name, Id and address…

Q: Draw flow chart to estimated salary for the proportion of workers 6 people 5 ID per hour where…

A: 1) For start and stop we have to use oval symbol  2)For calculation we have to use rectangle  3)For…

Q: Map the following ERD to relational schema Starting Date Manages CPR Works Name Professor Project in…

A: Below is the relational schema for given ERD:

Q: THIRD QUESTION : A company places orders for items. Each order is placed on a given date, and may…

A: A)  The relationship between orderNo and itemNo is many to many since an order can contain many item…

Q: a) List all employees. Relational Algebra(RA): Tuple Relational Calculus(TRC): Domain Relational…

A: Actually, given list of employees  Relational Algebra(RA): Tuple Relational Calculus(TRC): Domain…

Q: Design an E-R model for garage repair shop based on the following order form: DATE UTD WORK ORDER #:…

A: Garage Repair form is given from this we have to draw E-R Diagram.

Q: 5) Which students took multiple courses from Zafer Erenel but not a single course from Vesile Evrim?…

A: select student.name,takes.course_id from student INNER JOIN takes ON takes.ID = student_ID AND INNER…

Q: List the name of employees and his/her division name if her/his works on more than 2 projects and…

A: I give the query with explanation below

Q: Create a table with emp name. emp_no ,  emp_name  , emp_grade , emp_salary ,    dept_no  ,…

A: SQL query: creating table SQL> CREATE table emp  2  (  3  emp_no NUMBER,  4  emp_name…

Q: What is a decision table? Mention the components present in it.

A: The Given Data is What is a decision table? Mention the components present in it.

Q: What is a decision table? Mention the components present in it.

A: Defined a decision table and  the components present in it

Q: Print the course code, start date, and number of attendants for all course offerings that had at…

A: According to bartleby strategy I am permitted to address explicit number of inquiries (counting…

Q: Find out each manager's work address. Note that a manager's work address is the same as the he…

A: Given: To find out each manager's work address. Note that a manager's work address is the same as…

Q: Client (clientNumber, firstName, lastName, clientCity) Account(accountNumber, #agencyNumber,…

A: For the required query creating the first three tables:   (here, underline cloumn names are the…

Q: Provide a summary of customer balance characteristics for customers who made purchases. Include the…

A: Actually the given information is Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30

Q: STUDENT(sid, firstname, lastname, cgpa, contactno) ENROLLMENT(sid, cid) COURSE(cid, name, code,…

A: the answer is given below:-

Q: 5.1 -Applicant Signature- Receive applicant signature 5.3 5.2 Record of Signed offer letter 4…

A: According to the information given:- We have to Process Specification and techniques for given…

Q: do not copy from chegg!

A: the c++ code is:-

Q: Your university runs many hundreds of courses each semester and needs to keep track of key…

A: the code is given below:-