CS 330
Lecture 12
Project Discussion
I will present the three possible projects, as described
here.
Oracle Computer Based Training
In lieu of homework assignments, for the next 2-3 weeks you will have to
learn Oracle on your own. The Computer Based Training units that came with
the software, plus your own familiarity at this point with SQL, should
allow you to do this relatively smoothly. However, since this is the first time
we are using the software and many unexpected things could happen, I will
ask you to:
- Read
here
the details of how to proceed.
- Agree to exercise caution, especially given that you are allowed, for
the first week or so, to have full database administrator power.
- Create separate accounts for you as soon as you learn how to (may have
two or three accounts, depending on whether you work with administrator or
plain user privileges), and do all the
work, whenever possible, from these accounts. I will ask you to email me the
names and passwords of all the accounts you create on Oracle (so that
I will be able to assist you with problems and debugging, should they occur).
I also ask you
NOT to modify any of the already existing accounts and passwords.
- At the end of each week, email me a 1-2 page status report: what you have
covered from the CBT units, questions about what you have learned, what
modifications you have created to the database.
A little Embedded SQL
I will present the general structure of Embedded SQL, so that you are
at least familiar with the issues in this case, as opposed to the
interpreted version. Chances are that you will not use Embedded SQL for
your project (although if the need might arise, I might reconsider the
issue).
Ileana Streinu