some intersection for this assignmentEach student will submit the following two things in a “ZIP” folder:a. PDF file of their answer sheet.b. SQL queries written on a given template.c. Not following...

-- Question 1 Option 1: = SOME is identical to IN clause Option 2: SOME is not the same as NOT IN
-- Query is written below.
Option 1: = SOME is identical to IN clause
Example:
SELECT * FROM project.dbo.Floor WHERE floor_name = 'Floor1'
SELECT * FROM project.dbo.Floor WHERE floor_name IN ('Floor1');
Both the above SQL statements are identical and will return the same results.
Option 2:<> SOME is not the same as NOT IN
Example:
SELECT * FROM project.dbo.Floor WHERE floor_name <> 'Floor1'
SELECT * FROM project.dbo.Floor WHERE floor_name NOT IN ('Floor1');
Both the above SQL statements are identical and will return the same results.
-- Question 2
-- Query is written below.
#1. A block can hold 1024/200, or 5 rows.
#2. The file will need 200,000/5, or 40,000 blocks.
#3. The file will need 40,000/4000, or 10 platters.
#4. The disk can hold 100 * 4000 * 100 * 10, or 4,000,000 records.
#5. Time = (Number of blocks * block size) / (transfer rate)
Time = (100,000 * 200) / (1024 * 1024)
Time = 0.1953125 seconds
#6. Time = (Number of blocks * block size * seek time) / (transfer rate)
Time = (100,000 * 200 * 10) / (1024 * 1024)
Time = 1.953125 seconds
-- Question 3.1
-- Query is written below.
SELECT
fc.user_id AS TeacherID,
st.user_id AS StudentID,
fcg.group_name AS FacultyGroup,
stg.group_name AS StudentGroup,
class.Class_Name AS ClassName
FROM
Faculty AS fc
LEFT JOIN FacultyDepartment AS fcd ON...