List the department IDs for those departments that have less than 5 employees:
Q: List the vendor names and address for all the vendors who have active invoices. And the invoice…
A: SQL Inner Join Query
Q: Show the average salary for each different job_id group in the employee table
A: Code: SELECT JOB_ID, AVG(SALARY) FROM Employees WHERE JOB_ID <> 'IT_PROG' GROUP BY JOB_ID;
Q: Based on the ERD below, display the assignment number, employee number and assigned hours for either…
A: Here we are joining three tables ASSIGNMENT, EMPLOYEE, and JOB and the assigned job is either 501 or…
Q: No plagarism please! Write your own answer. Correct and detailed answer will be Upvoted else…
A: Let’s take few data samples to work on this query . Here is customer table with some data . Our…
Q: For each employee, show their full name and the region name of their department
A: Assuming Sql query for given statement is asked, considering table employee, with attributes…
Q: sign a query to show the accounts related contact in the salesforce Inspe d also explain what is…
A: Program in APEX using Salesforce Object query Language to Fetch Contacts and Opportunities Records…
Q: 4. List all customers (last name, first name and zip code) whose zip code is missing (unknown).
A: 4. Answer: SELECT LastName, FirstName, ZipCode FROM Customer WHERE ZipCode IS NULL;
Q: SQL 1.Show the first name of employees and their related department name. 2.For each employee,…
A: Given: SQL 1.Show the first name of employees and their related department name. 2.For each…
Q: Student(Id, name, age, class, grade) Retrieve all students who have grade 'B'
A: Structural Query Language Structural Query Language also called SQL is a query language use for…
Q: 1. List the address, square footage, owner number, services ID, number of estimated hours, and…
A: List the address, square footage, owner number, service ID, number of estimated hours, and number of…
Q: Address Book First Name: Last Name: City: Province: Postal Code: Add First Next Previous Last Update
A: Solution:-- 1)A layout is been given in the question for the topic of Address Book. 2)To do the…
Q: Display first name, last name and job title of all employees.
A: NOTE - Here I have Oracle SQL to solve the given problem. I have used the Select statement to…
Q: Display details of employee with ID 150 or 160. (Database Systems)
A: Since here no database table is provided. So, we are assuming the below-given table: Table - emp
Q: NOTE; language SQL List the office number, address, and monthly rent for properties whose owners…
A: Database: A database is used to store a huge amount of data records. Generally, most industries or…
Q: Find the number of (unique) products that have been sold to more than 10 customers. SQL Question
A: We need to write a SQL query for finding the number of (unique) products that have been sold to more…
Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…
A: The above question is solved in step 2 :-
Q: List the name of all departments that have more than four courses (you are not allowed to use join).
A: The SQL query is given in next step without using JOIN
Q: Using SQL Show the distinct location_id for all the locations where the company has departments
A: SQL SQL stands for Structured Query Language, and it is a programming language used to store,…
Q: For each reservation for customer Ryan Goff , list the reservation id, trip id and number of…
A: AND Operator: In Structured query Language (SQL), "AND" keyword is used in order to check two and…
Q: Please explain how to set the mining “difficulty”.
A: The difficulties of mining association rules from large databases: 1. Security and social issues:…
Q: List the department name, manager id and location id of all the departments that location id is 2500…
A: SELECT department_name, manager_id, location_id FROM departments where manager_id=124 ||…
Q: For every completed or 'open service request for janitorial work', list the condo id, description,…
A: The querry has given
Q: Queries: 1. List the first and last name of all patients who had blood cancer. 2. List names and…
A: As per Bartleby policy, we can only answer 3 sub parts per question. Please post remaining sub parts…
Q: SELECT firstNAME,City FROM students WHERE AGE 20;
A: convert to relational algebra
Q: For each customer, list the CustomerID and the total number of orders placed in 2015.
A: Answer: Query: select Order_T.Customer ID,sum(OrderLine_T.Ordered Quant from OrderLine_T inner join…
Q: Display the product ID and the number of orders placed for each product. Show the results in…
A: SQL (Structured Query Language) is a database computer language primarily designed for the…
Q: The name of the students that has the highest total credit. table =student students have >>…
A: Table name - student The table student has id,name, department_name, total_credit are the entites.…
Q: Checkout items from the inventory. (item name, count, price, remaining number of items in the…
A: Checkout items from the inventory. (item name, count, price, remaining number of items in the…
Q: List all customers who were referred to the bookstore by another customer. List each customer's last…
A: The way the question is put up. It is very likely that the question is of SQL language. Also, you…
Q: Find the name of the organization that has the smallest grant contribution.Using mysql
A: Given: Find the name of the organization that has the smallest grant contribution.Using mysql
Q: SQL Find the guide last name and guide first name of all guides who can lead a paddling trip
A: To merge the data between the tables: guide, trip guide, and trip tables SQL join method is used. It…
Q: List the index number, and course number for all classes taught by Dr. Smith during the Fall 02…
A: The query provided is done using SQL and considering all the data is present in a single table as…
Q: What are subqueries, and why are they used?
A: Subqueries A subquery may be a question inside another question, conjointly referred to as a nested…
Q: List the names of those products that have been sold to more than 10 customers. Sort your results by…
A: SQL is also known as Structured Query Language. SQL is a standard language for storing, manipulating…
Q: Explain how to use SQL's identity column feature.
A: In SQL we can create an Identity column for auto-generating the increasing value. As per my learning…
Q: SELECT e.Last_Name, m.Last_Name AS "Manager Name", e.Salary*12 AS "Annual Salary", 1.City FROM…
A: Please find all supporting table details and the output in the following steps.
Q: List the item ID, description, and on-hand value of each item whose number of units on hand is more…
A: Subquery : A subquery is a query that is nested inside a SELECT , INSERT , UPDATE , or DELETE…
Q: Display the territory ID and the number of salespersons in the territory for all territories that…
A: SQL (Structured Query Language) is designed primarily for managing data in a relational database…
Q: nter Employee Id : 101 Enter Enployee Id : nter Employee Name : John Hathew Enter Employee Nane ter…
A: I have written code below:
Q: List the owner number, last name and first name of every condo owner.
A: Use a nested query where we are including the condition to include only the OwnerNum which is…
Q: d)' List property location, owner name and maintenance date for property managed by Property Pete.…
A: The correct query is given below with output screenshot in the below step
Q: Using SQL find the number of employees from the table:
A: We just need to count all the rows in the given table that will result in the number of employess.
Q: Show a list of employee id, names, department, years and job of any employee in the staff table who…
A: First you have to make a table called Employee after this you just have to enter random values to…
Q: Display the highest, lowest, sum, and average salary of all employees. Label the columns Maximum,…
A: max - function to get the maximum value of column min - function to get the minimum value of column…
Q: Display last_name from students table who obtained below 75 algebra_grade or trigonometry_grade.
A: Since the question did not provide a table and its columns, a sample table Students created with…
Q: • Select the FirstName of customers with the highest Total in Invoice.
A: We have to select first-name of customers with the highest total invoice
Q: Display details of employee with ID 150 or 160. using sql
A: To find the details of the employee having ID 150 or 160. Note: The detail of the table is given…
Q: Select all the staff full names with the customer full names of the consignments they have worked…
A: Hey there , I am writing the required SQL query for the above mentioned question. Please do find the…
Q: display the first and last names, hire dates, and number of years employed for all employees who…
A: ORDER BY is the keyword used to sort the list and to make it in descending order, we use DESC…
Step by step
Solved in 2 steps
- Assignment 8. Student -324 234.428, .A local veterinarian hospital keeps record about the different pets they see over time, as well as information about the owners and treatment provided.The following tables represent a sample of the information recorded about owners, pets, and treatments. Owners LastName FirstName Phone Downs Marsha 555-537-8765 James Richard 555-537-7654 Frier Liz 555-537-6543 Pets PetName Type Breed Weight King Dog Std. Poodle 25.5 Teddy Cat Cashmere 10.5 Fido Dog Std. Poodle 28.5 King Horse Border Collie 25.0 Treatments Name Anesthesia Required Vaccine No Dental Yes Surgery Yes A veterinarian hospital wants to set up a data warehouse containing various information about the business. One section of this data warehouse should focus on recording information related to each pet visit to the hospital. For each of the visit, it is essential to record the various information…Normalize the following table to the 3rd Normal form: Student Student Phone Course Term Grade Instructor Instructor Phone Lauren Fernell 555-7771 MIS 350 F12 A Hess 555-2222 Lauren Fernell 555-7771 MIS 372 F12 B Sarker 555-2224 Lauren Fernell 555-7771 MIS 426 F12 A Fuller 555-2227 Lauren Fernell 555-7771 MIS 375 F12 B+ Wells 555-2228 Brigit Schnieder 555-2215 MIS 350 F12 A Hess 555-2222 Brigit Schnieder 555-2215 MIS 375 F12 B+ Wells 555-2228 Brigit Schnieder 555-2215 MIS 372 F12 A Sarker 555-2224 Brigit Schnieder 555-2215 MIS 374 F12 B Clay 555-2221 Jackie Judson 555-1245 MIS 350 F12 A Hess 555-2222 Jackie Judson 555-1245 MIS 372 F12 B+ Sarker 555-2224 How many tables did you create after normalizing the table? List each of…
- The following table shows a list of pets and their owners that is used by a veterinarian service. P_Name Type Breed DOB Owner O_Phone O_E-mail Kino Dog Std. Poodle 3/27/97 M. Downs 5551236 md@abc.com Teddy Cat Chartraux 4/2/98 M. Downs 1232343 md@abc.com Filo Dog Std. Poodle 2/24/02 R. James 2343454 rj@abc.com AJ Dog Collie Mix 11/12/95 Liz Frier 3456567 liz@abc.com Cedro Cat Unknown 12/10/96 R.James 7865432 rj@abc.com Woolley Cat Unknown 10/2/00 M. Trent 9870678 mt@abc.com Buster Dog Collie 4/4/01 Ronny 4565433 ron@abc.com a. Describe 4 problems that are likely to occur when using this table. b. Break the table into two tables in a way that fixes the four problems.CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…
- 1. Display the name (first name and last name) for those employees who gets more salary than the employee whose ID is 163. 2. Display all the information of those employees who did not have any job in the past. 3. Display the details of departments managed by Susan. 4. Display the details of those departments which max salary is 7000 or above for those employees who already done one or more jobs. 5. Display the detail information of those departments which starting salary is at least 8000.INSTRUCTIONS Using spreadsheet software enter the following table below that shows the number of tourists visiting the following countries over a five-year period. Use Times New Roman and Font size 12. Name the worksheet Table. COUNTRIE S 2014 2015 2016 2017 2018 ‘000 ‘000 ‘000 ‘000 ‘000 Grenada 350 465 375 250 485 Antigua and Barbuda 153 160 155 149 256 Barbados 573 625 725 680 740 St. Kitts 347 515 538 178 384 St. Lucia 600 436 368 535 858 Trinidad and Tobago 379 563 475 415 563 Jamaica 416 200 500 300 475 Bahamas 300 450 550 460 470 Aruba 208 367 415 500 684 Dominica 135 317 279 350 465 Insert a column to the right of the table with the heading “Total Visitors”. In that same column compute the total number of tourists that visited each country over the years. Insert a row heading Maximum to show the maximum number of visitors for each given year. Sort the data in ascending order based on the Countries. Insert a row heading Minimum to show the minimum number of visitors for…Given the following relation that stores details about students' activities: StudentID StudentName Activity ActivityFee AmountPaid 100 Jones Golf 65.00 65.00 100 Jones Skiing 200.00 0.00 200 Davis Skiing 200.00 0.00 200 Davis Swimming 50.00 50.00 300 Garrett Skiing 200.00 100.00 300 Garrett Swimming 50.00 50.00 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00
- Answer the following questions by referring to the tables below. COURSE Course_name Course_number Credit_hours Department Intro to Computer Science CS1310 4 CS Data Structures CS3320 4 CS Discrete Mathematics MATH2410 3 MATH Database CS3380 3 CS SECTION Section_ID Course_number Semester Year Instructor 85 MATH2410 Fall 07 King 92 CS1310 Fall 07 Anderson 102 CS3320 Spring 08 Knuth 112 MATH2410 Fall 08 Chang 119 CS1310 Fall 08 Anderson 135 CS3380 Fall 08 Stone Retrieve a list of all the courses under the "CS" department, listed alphabetically by course name. Retrieve the section ID, course name, course number, semester, year, and Instructor of the courses taught by Instructor "Anderson". Insert a tuple for a new COURSE with the following information: 4.The course name is Computer networks, and the course number is CS3480. It belongs to the CS…So if I have this table: staffNo dentistName patientNo patientName appointment_date appointment_time surgery_no S1011 Tony Smith P100 Gillian White 12-Aug-03 10:00 S10 S1011 Tony Smith P105 Jill Bell 13-Aug-03 12:00 S15 S1024 Helen Pearson P108 Ian MacKay 12-Sep-03 10:00 S10 S1024 Helen Pearson P108 Ian MacKay 14-Sep-03 10:00 S10 S1032 Robin Plevin P105 Jill Bell 14-Oct-03 16:30 S15 S1032 Robin Plevin P110 John Walker 15-Oct-03 18:00 S13 Here the non-trivial functional relations include at least the following: staffNo --> dentistName patientNo -->patientName partientNo, appointment_date, appointment_time --> surgery_no Do you believe there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed.How do I draw this out?# Begin constantsCOLUMN_ID = 0COLUMN_NAME = 1COLUMN_HIGHWAY = 2COLUMN_LAT = 3COLUMN_LON = 4COLUMN_YEAR_BUILT = 5COLUMN_LAST_MAJOR_REHAB = 6COLUMN_LAST_MINOR_REHAB = 7COLUMN_NUM_SPANS = 8COLUMN_SPAN_DETAILS = 9COLUMN_DECK_LENGTH = 10COLUMN_LAST_INSPECTED = 11COLUMN_BCI = 12 INDEX_BCI_YEARS = 0INDEX_BCI_SCORES = 1MISSING_BCI = -1.0 EARTH_RADIUS = 6371 # Sample data for docstring examplesdef create_example_bridge_1() -> list:"""Return a bridge in our list-format to use for doctest examples. This bridge is the same as the bridge from row 3 of the dataset.""" return [1, 'Highway 24 Underpass at Highway 403','403', 43.167233, -80.275567, '1965', '2014', '2009', 4,[12.0, 19.0, 21.0, 12.0], 65.0, '04/13/2012',[['2013', '2012', '2011', '2010', '2009', '2008', '2007','2006', '2005', '2004', '2003', '2002', '2001', '2000'],[MISSING_BCI, 72.3, MISSING_BCI, 69.5, MISSING_BCI, 70.0, MISSING_BCI,70.3, MISSING_BCI, 70.5, MISSING_BCI, 70.7, 72.9, MISSING_BCI]]] def create_example_bridge_2() ->…