Utilizing the Program Advising Sheets and General Education Electives list in the college catalog menu (link below), determine which physical and life sciences/mathematics elective are required for the Psychology A.S. degree. Link to the college catalog: https://www.nvcc.edu/catalog/ CHM 111 and CHM 112 BIO 141 and BIO 142 PHY 201 and PHY 202 BIO 101 and BIO 102

Insert the following data into your database tables.STUDENTSSTUDENT_ID STUDENT_NAME STUDENT_SURNAMES123456 Neo PetleleS246810 Derek MooreS369121 Pedro NtabaS654321 Thabo JoeS987654 Dominique WoolridgeMODULESMODULE_ID MODULE_NAME MODULE_CREDITDATA6212 Database Intermediate 30INPU221 Desktop Publishing 20PROG6211 Programming 2A 15PROG6212 Programming 2B 15WEDE220 Web Development (Intermediate) STUDENT_MODULESSTUDENT_ID MODULE_IDS123456 PROG6211S123456 PROG6212S246810 DATA6212S369121 DATA6212S369121 INPU221S369121 WEDE220S987654 PROG6211S987654 PROG6212S987654 WEDE220LECTURERSLECTURER_ID LECTURER_NAME LECTURER_SURNAMEL578963 Kwezi MbeteL876592 Julia RobinsL916482 Trevor JanuaryLECTURER_MODULESMODULE_ID LECTURER_IDDATA6212 L578963INPU221 L876592PROG6211 L916482PROG6212 L916482WEDE220 L876592Correct INSERT statements used and all data correctly inserted per table.

View 4 Seneca Courses Inc. Customer Forms All customer information for SCI is maintained on file forms. The following are sample customer information forms:     CUST_ID 78   CUST _ID 54     NAME YORK UNIVERSITY   NAME SENECA COLLEGE     LOCATION NORTH YORK   LOCATION NORTH YORK     SALES_REP ANDRE MARTIN   SALES_REP PARVEZ RAI             CUST _ID 74   CUST _ID 43     NAME RYERSON   NAME INDIGO BOOKS     LOCATION TORONTO   LOCATION TORONTO     SALES_REP PARVEZ RAI   SALES_REP ANDRE MARTIN     Business Rules: NAME must always be different for each customer.   SALES_REP must always have a value. SALES_REP must be an existing employee. A customer only has one sales rep, but the sales_rep may have more than one customer.   Normalize the above user view.  Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF and explain or list the…

List all the tables contained within the system catalog. List all the columns contained within the system catalog.

Display the JOB_ID and the position of the character S in the JOB_ID on jobs table as the following: Search of the character S in the JOB_TITLE Result S not found in the name Not Found S in the last character of the name Last Character The name contains the character S Contains S S in the first character of the name First Character

View 3 Seneca Courses Inc. Employee Forms All employee information for SCI is maintained on file forms. The following are sample employee information forms: EMP_ID 7839   EMP_ID 7654     EMP_NAME JOHN CHIU   EMP_NAME ANDRE MARTIN     SOC_INS 123-234-345   SOC_INS 678-345-123     POSITION MANAGER   POSITION SALES     SUPERVISOR     SUPERVISOR JOHN CHIU     HIREDATE November 13, 1999   HIREDATE September 24, 1999     EMP_ID 7434   EMP_ID 7435     EMP_NAME PARVEZ RAI   EMP_NAME DANIEL CHOY     SOC_INS 234-123-432   SOC_INS 345-312-234     POSITION SALES   POSITION CLERK     SUPERVISOR JOHN CHIU   SUPERVISOR       HIREDATE June 24, 1980   HIREDATE August 4, 1998     Business Rules: 1. SOC_INS must always be different for each employee. 2. EMP_NAME must always have a value. Normalize the above user view. Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF…

WEEK 9 ASSIGNMENT#6   Part II: Complete the following exercise:    Using a subquery, select student first name where the student is in the student course table. Using a subquery, select the course id where the average GPA is 2. Using a subquery, select the course id where the average GPA is greater than 2. Using a subquery, select student first name where the student is not in the student course t

1. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key)

Using the AND or OR statement, filter the employee table for employees who live in the city Lethbridge or have IT within their title.  Identify the first name of the 2nd record.     Robert Laura Michael King

Your university runs many hundreds of courses each semester and needs to keep track of key information on each one. Among the data needed for each course would be the following: - University course identification number - Department course ID and section number (for multiple sections of the same course) - Number of credits for the course Days and times the course meets - Room in which the course meets (building ID and room number) Maximum course enrollment Campus on which the course is held - Name of the course instructor - Number of students currently enrolled and the student ID of each such student - Course status: open (for additional enrollment), closed, or canceled You must be able to change the value of each of these ten data items and, upon request, display all of this information. Initially, the values of the first seven items are known–the last three aren't. Design and implement an abstract data type that can be used to model this university course entity.