I'll ask this query one more: how much room does a computer need?

I need help with creating the SQL statement for the instructions below. Create the following 2 tables with columns and constraints Table Lab4program_xxxx has 3 columns: code is varchar(5) and the primar key, name is varchar(20), tel varchar(20). Table Lab4course_xxxx has 3 columns: cid is int, and the primary key, name is varchar(20), credits is int, mycode is a foreign key reference to your Lab4program table. Table Lab4program_xxxx has 3 columns: code is varchar(5) and the primar key, name is varchar(20), tel varchar(20). Table Lab4course_xxxx has 3 columns: cid is int, and the primary key, name is varchar(20), credits is int, mycode is a foreign key reference to your Lab4program table.

DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted. Also explain why other options are FALSE. Thank you!

Students: Johnson, Williams, Matt, Jones, Eric, Lili, John and Jason, whose grades are listed below. Each column is the grades each student received. There are 8 students with 10 grades each. Johnson: 79, 92, 85, 0, 100, 64, 72, 99, 90, 86 Williams: 80, 75 93, 94, 0, 90, 89, 88, 87, 86 Matt: 82, 67, 72, 74, 89, 0, 70, 89, 100, 76 Jones: 85, 84, 82.5, 82, 84, 80, 80.5, 90, 96, 85 Eric: 90, 91, 87, 85.5, 86.5, 0, 90, 90, 91, 92 Lili: 60, 75, 81, 70, 80, 81, 94, 67.5, 99, 98 John: 79,0, 74, 96, 88.5, 88, 0, 100, 86, 83 Jason: 89, 90, 90, 85, 85, 90, 91, 88, 100, 79 Write user-defined functions or build-in functions (e.g., sum, mean, max, min, etc.) to calculate: The Average Grade of each student; this average should be a vector. The average of the class; this average is a scalar vector. The highest grade among the Average Grade of Each Student The lowest grade among the Average Grade of Each Student Show a table with each student's name, average grade and letter score using A, B, C, D, F…

Intersection table is needed when you have a relationship     1:1     M:N     M:1     1:M

The following two SQL statements will produce the same results. SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE P_QOH >(SELECT P_QOH FROM PRODUCT WHERE P_CODE='11QER/31') AND   P_PRICE>(SELECT P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31');     SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE (P_QOH,P_PRICE) >  (SELECT P_QOH,P_PRICE  FROM PRODUCT   WHERE P_CODE='11QER/31');   A) True B) False

Some of the inquiries that need a response are as follows:.

Write a SQL statement to prepare a list with salesman name, customer name and their cities for the salesmen and customer who belongs to the same city.

How many homes/apartments/etc. are in your masm etymology?

Is the following table in First Normal Form? If so, how would you get it into first normal form.         SalesPerson/Product table         Order Number Product  Number Salesperson ID SalesPerson Name Commission Percentage Year of Hire Department Number Department                 Name Product Name Unit Price Quantity 137 19440 15 Baker 10 1995 73 Commercial Sales Hammer 17.50 473   24013             Saw 26.25 170   26722             Pliers 11.50 688 186 16386 7 Adams 15 2001 59 Home Sales Wrench 12.95 1745   19440             Hammer 17.50 2529