Implement the following ER model using Oracle SQL Developer and your CDM Oracle database account and show the SQL script file and its full output.

Grade types are as follows:

IS411, Introduction to Programming for Business Applications, Professor Govind. IS421, Systems Analysis, Professor Charan. [course number of your choice], [course name of your choice], [instructor of your choice].

QUESTIONS:

1) The SQL script to (i) drop the three tables, (ii) create the three tables, (iii) insert the sample data, and (iv) show the full contents of all the three tables.

a) Make sure to start your script file with DROP TABLE commands for all three tables in order to avoid conflicts. Use the DROP TABLE commands in the following order.

i) ENROLLMENTS

ii) STUDENTS

iii) COURSES

b) Make sure that your SQL script runs without an error from the first line to the last one.

2) The Word/text file to show the entire outputs of your SQL script.

a) Show output of the script in a word file after running it.

Student The table name should be STUDENTS (plural). Each StudentID should be a five-digit number. LastName and FirstName must be entered. - 12341, Doe, Jane - 12342, [last name of your choice], [first name of your choice] - 12343, [last name of your choice], [first name of your choice] Enrollment The table name should be ENROLLMENTS (plural). Quarters should be something like 2021Fall, 2022Winter, 2022Spring, 2022Summer1, 2022Summer2, 2022Summer 10 , and so forth. A The instructor judged the student to have accomplished the stated objectives of the course in an EXCELLENT manner. B The instructor judged the student to have accomplished the stated objectives of the course in a VERY GOOD manner. C The instructor judged the student to have accomplished the stated objectives of the course in a SATISFACTORY manner. D The instructor judged the student to have accomplished the stated objectives of the course in a POOR manner. (A grade of D will not fulfill the requirements in a major field of concentration.) F The instructor judged the student NOT to have accomplished the stated objectives of the course. FX Student failed to accomplish the stated objectives of the course due to non-attendance. Nonattendance is defined as never attending or ceasing to attend an in-person course (or never participating or ceasing to participate in an online course) without officially withdrawing. The FX is calculated into the student's GPA as an F. Instructors are required to provide the last date of attendance/participation. IN Temporary grade indicating that, following a request by the student, the instructor has given his or her permission for the student to receive an incomplete grade. In order to receive an IN grade, the student must have a) a satisfactory record in the work already completed for the course, b) encountered unusual or unforeseeable circumstances which prevent him/her from completing the course requirements by the end of the term, and c) applied to the instructor for permission to receive an IN. ING Permanent grade assigned to a degree recipient who chooses not to resolve a grade of IN awarded during the two terms prior to graduation. The grade of ING (Incomplete, Graduated) is final, and cannot be changed or lapsed to F once the degree is posted. PA Passing achievement in a pass/fail course. (Grades A through D represent passing performance.) W Withdrawal from the course initiated by the student after the Last Day to Drop With No Penalty anc before the Withdrawal Deadline. The W grade is automatically recorded on the student's transcript once it has been processed. WA Withdrawal from the course initiated by an advisor or administrator at the student's request, usually outside of established deadlines. Administrative withdrawals may be granted under extraordinary circumstances and require documentation for support. See the Withdrawal Policy page in this handbook for more information. During their DePaul career, students may be allowed one medical/personal approved administrative withdrawal and one college office administrative withdrawal, each for one or more courses in a single term. R Temporary grade indicating that the student is making satisfactory progress in a course that formally extends beyond the end of a term. Only designated courses are eligible for R grades. RG Permanent grade assigned to a degree recipient who chooses not to resolve a grade of R awarded during the last year prior to graduation. The grade of RG (Research, Graduated) is final, and cannot be changed or lapsed to F once the degree is posted. M Final grade not submitted by instructor. AU Auditor status; course does not earn credit. Grades in future quarters are entered as null. - 2021Fall, 12341, IS411, A - 2022Winter, 12342, IS421, null - 2022Summer10, 12343, [course number of your choice], null Course The table name should be COURSES (plural). CourseNumbers should be strings of up to seven characters (e.g., IS411, DSC411, CSEC440). The course and instructor names should be strings of characters. CourseName must be entered. Instructor may be undetermined at the time of initial data entry