Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20) LastName varchar(20) Gender char(1) DateofBirth date Courses Attribute Name Data Type CourseCode varchar(6) CourseName varchar(70) Level char(2) Credits int   Registration Attribute Name Data Type StudentID char(11) CourseCode varchar(6) Grade decimal(2, 1)   Write SQL code to:  1. How many courses are there on each level? 2. What is the average grade of courses that have been taken by the student with student ID 861103-2438?   3. Which students (studentID only) have the highest grade for the course ‘CS052’? 4.  Find the courses (course codes only) that have been taken by both the student 861103-2438 and the student 123456-0980.

Q: Cust_id (NOT NULL) Txn_date (Not NULL) Txn_type (NOT NULL) Txn_amount (NOT NULL) 1 2020-01-21…

A: The CREATE TABLE statement is used to create a new table. Syntax: CREATE TABLE table_name (column1…

Q: Based on the ERD below, display Employee first name, middle initial and last name so it displays in…

A: In this case, the whole name is displayed in a single column of employees where the job code is…

Q: Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20)…

A: Structured Query Language, abbreviated as SQL, which refers to the one it is a domain-specific…

Q: If  the functional dependencies are consistent with the above relation,  put TRUE. If they are not,…

A: functionally dependent defines the relationship between attributes, how they are related.  A-> B…

Q: Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.

A: Query to display the average hourly job charge for a job. To get average hourly job charge for all…

Q: CREATE TABLE DONORS ( donor_id INT NOT NULL, donor_name varchar(255) NOT NULL, donor_age int,…

A: INSERT INTO DONORS VALUES(1,'SAI',20); INSERT INTO DONORS VALUES(2,'PAVAN',21); INSERT INTO DONORS…

Q: Course • Courseld CourseCode CourseName Capacity Instructorld 3815 ENGL862 American Literature 75 2…

A: The question requires us to write a SQL query that will return the details of instructors who teach…

Q: View 3 Seneca Courses Inc. Employee Forms All employee information for SCI is maintained on file…

A: Actually, the answer has given below:

Q: DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY…

A: Answer in step 2

Q: Execute a SQL statement to add a not null constraint to the field date_of_order

A: The NOT NULL constraint in SQL ensures that a column cannot incorporate any NULL values, that means…

Q: Column Name Sie Constraints Data Type DepelD Varchar 4 Primary key DepeName 40 Not mull Varchar…

A: I have created the query below for the table:

Q: I. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: To write the SQL query.

Q: Activity 7: Sorting Data Using ORDER BY In this activity you will sort rows by using the ORDER BY…

A: The ORDER BY clause in MySQL is used to sort the results of a query in ascending or descending…

Q: Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20)…

A: 1. The MySQL code for the given problem is as follows: CREATE TABLE Students (    StudentID…

Q: 1. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: Structure of a table employee is given having attributes First_Name, Last_Name, SSN_Number.…