Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Instructions Implement the following ER model and sample data using Oracle SQL Developer and your CDM Oracle database account. You will submit a SQL script

image text in transcribed

Instructions Implement the following ER model and sample data using Oracle SQL Developer and your CDM Oracle database account. You will submit a SQL script file and its entire outputs. 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, 2022Summer10, and so forth. Grades are the same as ours (https://offices.depaul.edu/depaul-central/records/Pages/grades.aspx). 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. - IS411, Introduction to Programming for Business Applications, Xiaowen Fang - IS421, Systems Analysis, Steven Rubinow - [course number of your choice], [course name of your choice], [instructor of your choice] What you submit are 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. The header of your script should be something like: / Your Name IS451 HW6 / b. 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 c. Save your SQL script as HW6YourName.sql (e.g., HW6JohnDoe.sql). d. 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. The header of your file should be something like: /* Your Name IS451 HW6 */ b. Name your file to HW6YourName.docx (e.g., HW6JohnDoe.docx) or HW6YourName.txt (e.g., HW6JohnDoe.txt). c. The easiest is to clear the Script Output window first and then save the output of your script file after running it

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Programming With Visual Basic .NET

Authors: Carsten Thomsen

2nd Edition

1590590325, 978-1590590324

More Books

Students also viewed these Databases questions