HW#4 --- last modified January 01 1970 00:00:00..
Solution set.
Due date: Apr 17
Files to be submitted:
ch7.doc
ch8.sql
ch8.log
Purpose:
To get some experience with the Relational Model and
Algebra.
To use SQL in a more extensive manner.
Specification:
Do problems 7.19, 7.25 and submit them in ch7.doc. Then do 8.16 and 8.17.
For the problems in Ch 8, actually create in Oracle the database in Fig 1.2
and try out your inserts, updates, and queries on this database. The file
ch8.sql should contain all the SQL needed to create the DB in figure 1.2
(no sqlldr this time and you should have all the constraints you can think
of for the table's) together with each of the operations in 8.16 and
8.17. ch8.log should be a file containing a session where you run your
ch8.sql. You can use either script from Unix or SPOOL in SQLPLUS to show
this session.
Point Breakdown
7.19 |
2pts |
7.25 | 2pts |
CREATE TABLE's work correctly and all constraints
implemented for Fig 1.2. | 1pt |
Fig 1.2 DB populated using INSERT statements. | 1pt |
8.16 | 2pts |
8.17 | 2pts |
Total | 10pts |
|