HW#2 --- last modified March 02 2019 21:20:13..
Solution set.
Due date: Oct 3
Files to be submitted:
Ch3Ch4Problems.pdf
Spool.txt
Purpose: To gain experience with ER, EER, and UML diagrams.
To test out your accounts on sigma.
Specification:
Do problems 3.20, 3.21, 4.22, 4.23 out of E&N. Submit these in the file
Ch3Ch4Problems.pdf. Then I would like you to test out your Oracle accounts
on sigma. I want you to spool an Oracle session into the file Spool.txt
in which you log into your Oracle account on sigma and do the following things:
First, do a
select * from user_tables;
Secondly, create a table which has a name consisting of your first name
and has an integer field which is your last name. Third, insert one row
with a value 7 into this table. Lastly, do another
select * from user_tables;
Point Breakdown
Book problems (2pts each) |
8pts
|
Spool file looks legit and records the four things listed to do (.5 each) |
2pts
|
Total | 10pts |
|