CSc 498/698, Spring 1998
Project (Phase II)
Due: 15 May, 1998 (Friday)



The second phase will deal with creating the database tables of Phase I in SQL*PLUS, populating with sample data, and ensuring that the integrity constraints defined in the schema are being enforced by Oracle.

Some remarks:
  1. To populate the tables, you must use each of the three methods: Use each of these methods on equal number of tables. Submit a screen capture of the activities that go into populating the database.
  2. The sample data must be large. For example, 20 to 30 rows in the tables produced from entity sets and 50 to 100 rows in tables produced from relationship sets.
  3. To verify that the integrity constraints are being enforced, you must enter SQL*PLUS and try to violate these constraints by performing appropriate updates and see if Oracle accepts them. You need to submit a screen capture of the session.
  4. The professional report must be extended with Phase II information.