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

Q: display all fields in the JOB table sorted by the largest hourly charges for the job first

A: SELECT * will fetch you all record in table

Q: Q. List all the attributes of movie in the given Model.

A: Q. List all the attributes of movie in the given Model.  Answer. All the attributes of movie in the…

Q: Create a list showing only the EmployeeID, Sales, and Projected Sales sorted from highest to lowest…

A: The query selects the specified columns from the EmployeeSales table and orders the result set based…

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: 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: lter table product so that column productlype is an integer instead of a varchar, not null should be…

A: Lets see the solution.

Q: Display only the sales territories that have more than one salesperson.

A: The HAVING clause is used in SELECT statement as we cannot use the WHERE clause with aggregate…

Q: Name the candidate keys in the following table: Student L number Student_Name Student SS Number…

A: a candidate key is a super key which has no redundant attribute.

Q: Costumer_ID Contact No Order_Total Order No COSTUMER 1 n ORDER Order Date n Name Mode_of_Payment…

A: It is evident by looking at the ERD that, there are no relationships between the attributes which…

Q: 1. Given the following relation that stores details about students' activities: StudentID…

A: here have to determine functional dependencies with given relation.

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: Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd…

A: Overview : The COUNT() function returns the number of rows that matches a specified criterion. The…

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: Results Messages id emp_name emp_age emp_salary join_date phone id emp_name emp_age emp_salary…

A: An entity in a real world object and can be described by using set of attributes.  An entity store…

Q: Show the list of courses numbers that are taken at least once by students. The course should appear…

A: So, all the unique course numbers has to be printed So, for this you can make use of DISTINCT…

Q: Task 4: KimTay Pet Supplies is running a promotion that is valid for up to 20 days after an order is…

A: Here, we are using dateadd function to add 20 days into the invoice date the day today function…

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…