Chapter 5 Individual Assignment

docx

School

Pace University *

*We aren’t endorsed by this school

Course

623

Subject

Information Systems

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by GeneralHeron3173

Chapter 5 Individual Assignment Step 5.1 - Open the text file called: Inserts_for_University_Example and DDL or University_Example located in this directory. Step 5.2 - Create the Student, Faculty, Class, and Enroll tables in the database as shown in Figure 5.2 in the textbook. Highlight and copy the CREATE TABLE commands (one at a time) and paste them into SQL*Plus at the SQL> prompt. You should see the message: Table Created after each statement is executed. Note: Show your work – screenshots

Step 5.3 - Insert the records into the four tables. Highlight and copy each INSERT command (one at a time) and paste them into SQL*Plus at SQL> prompt. You should see the message: 1 row created after each statement is executed. Note: Show your work – screenshots

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Step 5.4 - Design SQL queries for the following questions: Step 5.4.a - Find the names of all the Math majors Step 5.4.b - Find the class number, schedule, and room for all classes that Smith of the History department teaches.

Step 5.4.c - Find the names of all students who have fewer than average number of credits. Step 5.4.d - Find the names of all the teachers that Ann Chin has. SQL statement should also include these attributes: student ID, first and last name, classes and Ann’s grades for each class

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Step 5.4.e - For each student, find the number of classes he or she is enrolled in. Limit the results to only students who are enrolled. SQL Statement should include these attributes: student ID, first and last name, number of classes he or she is enrolled in.

Chapter 5 Individual Assignment

Related Documents