Database Systems Project 1: Writing SQL Queries in Oracle

PROJECT REPORT > Database Systems Project 1: Writing SQL Queries in Oracle

Binghamton University CS 432 Please remember to include the following statement at the beginning of your submitted assignment and SIGN it. Your assignment won’t be graded without the signed statement. “I have done this assignment completely on my own. I have not copied it, nor have I given my solution to anyone else. I understand that if I am in ...[Show More]

Binghamton University
CS 432
Please remember to include the following statement at the beginning of your submitted assignment and SIGN it.

Your assignment won’t be graded without the signed statement.

“I have done this assignment completely on my own. I have not copied it, nor have I given my solution to

anyone else. I understand that if I am involved in plagiarism or cheating I will have to sign an official form that

I have cheated and that this form will be stored in my official university record. I also understand that I will

receive a grade of 0 for the involved assignment and my grade will be reduced by one level (e.g., from A to Aor from B+ to B) for my first offense, and that I will receive a grade of “F” for the course for any additional

offense of any kind.”

The following normalized tables from the Student Registration System will be used in this project (Note 1:

Attributes Faculty_B# and TA_B# are not kept for relation Classes because relations TAs and Faculty are not

used for this project. Attributes start_time and end_time are also not kept for relation Classes as they will not be

used in this project. Note 2: To simplify, relation G_Students is not used in this project. We will let G_B# to be

a foreign key referencing Students.B# directly.)

Students(B#, first_name, last_name, level, gpa, email, bdate)

Courses(dept_code, course#, title)

Course_credit(course#, credits)

Classes(classid, dept_code, course#, sect#, year, semester, limit, size, room)

G_Enrollments(G_B#, classid, score)

Score_Grade(score, lgrade)

As a general clarification, we assume that no student takes the same course (including different sections of the

same course) more than once. If you have questions about these tables, please contact the instructor for

clarification.

1. Preparation

Save the sql script file proj1_tables_script22.txt as proj1_tables_script22.sql in your harveyv account.

To run the above script from your Oracle account, use

SQL> start proj1_tables_script22

Then check whether all tables are created correctly in your Oracle account.