CSC 240: The Week beginning Nov. 8
- Reading:
Section 13.6 in Database Systems: Design, Implementation,
& Management(Rob and Coronel)
- Homework:
- Read Chapter 10 of Database Nation (Simson Garfinkel) and write a summary of or reaction to what you read.
- Start your project. The project can be done alone or in teams of up to three (somewhat more will be expected from larger groups). The project consists of two parts: one part will involve a database for audio-visual equipment that
is borrowed by students or faculty for classes (everyone will
do this part), the other part is a database of your own design
(it must be sufficiently complex).
- MultiMedia documents
Due Nov. 15
- Monday:
Database Security
- Wednesday:
Examine the data found in StudentTranscripts.xls,
decompose it into tables to reduce redundancy (you have already done this exercise). Make a script that creates those tables in Oracle. Be sure to identify primary keys
and foreign keys. Include in
the script statements to add the data to the tables. Write a query that finds the
names of students who have taken ENG 108.
- Friday:
More Oracle