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: Determine the primary keys.

A: For creating Er diagrams, all the table names are written in a rectangle and are called Entities.…

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: Refer the below schema and create the table USERS. Column Name Datatype | Size Number Varchar2 20…

A: We have to create the table USERS from the given schema

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: Each key that meets the criteria for a primary key is called functional key a O lookup key b O…

A: According to the asked question, the solution is given below with a proper explanation.

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: hich one is correct Select the constraint (if any) that is violated by each the following operations…

A: Here table student_course contains primary key of table student and course.  Now we are deleting…

Q: Add a CHECK constraint on the BEDROOOM column in the ROOMS table. It must accept a value from 1 to 5…

A: CHECK is the keyword used for CHECK constraint and after table has created, if you want to add this…

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: Create a scatterplot in Excel of age and years worked. Comment on what this scatterplot tells you…

A: SOLUTION - For the given table we have to create a scatterplot in Excel -   Steps to create a…

Q: SUPPLIERS   SID SNAME STYPE LOCATION 1 Lulu DS Salalah 2 C4 DS Saadah 3 Smile WS…

A: Here first we need to find SID of product 802. Let's name this as X. Then find productID and…

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: what

A: Errand assistance service application:  An errand is a brief trip taken to distribute, retrieve, or…

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: Customers Id Username D Firstname Sumame Email PostalAddress Orders ld Customerld Created Status +…

A: Let's discuss which statements are true in the diagram

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: The materials manager at Tricky Pee Furniture Company maintains a list of suppliers for each of the…

A: We need to create table and fill sample data for the given schema.

Q: Customers ld Username Firstname Sumame Email PostalAddress Orders ld Customerld Created Status…

A: According to the information given:- We have to choose the correct option in order to satisfy the…

Q: Normalise the data below to third normal form (3NF)

A: This is very simple. We know for a table to be in the third normal form, It should be in the Second…

Q: Customers ld Usemame Firstname Sumame Email PostalAddress Orders ld Customerld Created Status…

A: Below I have provided the solution to the given question

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…