Assume the tv_guide database was created with the two tables tvstation and play that are shown in the diagram. How do you produce a report with the following columns? play.channel, play.name, play.playDate, play.playTime, tvstation.city, tvstation.email AND the report must be ordered by channel DESCENDING. tvstation channel (PK) callleters city st phone email url |++ play name (PK) playdate (PK) playtime (PK) (FK) channel (PK) episodelD affiliate

Question 2 and 3

• create a sql script that loads your tables with data. Note: in addition to the data present in the table, add several more records for each table in the database, including Client's taking multiple courses and Courses with NO students having taken (think planned course). LANGUAGE SCHOOL TABLE CourseID Course Language CourseLevel ClientID ClientName Attendance FinalScore German C111 Mr. Smith Ms. Jones German German Mr. Vance German Ms. Clark German Ms. Wong German Ms. Hess Japanese Mr. Smith Japanese Ms. Jones 10 11 12 10 11 G 12 20 21 Basic Intermediate C222 Advanced C333 Basic C444 Intermediate C555 Advanced C666 Basic C111 Intermediate C222 100% 90% 95% 100% 90% 95% 100% 95% 80% 90% 100% 100% 95% 98% 100% 100%

1. Open SQL Microsoft SQL Management Studio. 2. Create a database named DB_CompanyX. 3. Create tables for the database. See Table 1 for the table name, column name, and data type. Table 1. Creating Tables Table Name Data Type Column EMPLOYEE_NO *primary key* BIGINT BIRTH_DATE DATE FIRST_NAME VARCHAR (50) TBL_EMPLOYEE LAST_NAME VARCHAR (50) GENDER VARCHAR HIRE_DATE DATE EMPLOYEE_NO *foreign key* BIGINT TITLE VARCHAR (50) TBL_EMP_TITLE FROM_DATE DATE TO_DATE DATE EMPLOYEE_NO *foreign key* BIGINT SALARY INT TBL_EMP_SALARY FROM_DATE DATE TO_DATE DATE EMPLOYEE_NO *foreign key* BIGINT DEPARTMENT_NO *foreign key* CHAR (10) TBL_DEPT_EMP FROM_DATE DATE TO_DATE DATE 02 Task Performance 1 *Property of STI Page 1 of 2 STI IT1924 DEPARTMENT_NO *primary key* CHAR (10) TBL_DEPARTMENTS DEPARTMENT_NAME VARCHAR (40) DEPARTMENT_NO *foreign key* CHAR (10) EMPLOYEE_NO *foreign key* BIGINT TBL_DEPARTMENT_MANAGER FROM_DATE DATE TO_DATE DATE 4. Create a database diagram and include all the tables. 5. Using…