Homework 2

Assigment 2 (Due September 8, 11:49 pm)

Practicing Oracle

create the tables Students (with Id, Name, Address, and Status) and Transcripts (with Studid, CrsCode, Semester, and Grade) as described in the textbook (pg. 43)

insert 5 students into the table Students (2 seniors, 1 freshman, 1 junior, 1 sophomore)

insert 10 tuples into the table Transcripts, (2 for each students)

You should submit the following:

the commands that you use to create the tables and insert data into the tables

Leave the data in your Oracle account so that the TA can check your work.

Exercise 2.3 and 2.5 (pg. 25)

	create the tables Students (with Id, Name, Address, and Status) and Transcripts (with Studid, CrsCode, Semester, and Grade) as described in the textbook (pg. 43)
	insert 5 students into the table Students (2 seniors, 1 freshman, 1 junior, 1 sophomore)
	insert 10 tuples into the table Transcripts, (2 for each students)