Hollywood Enterprise
The table below provides access to the Oracle DDL for defining the Hollywood database. The utility scripts allow you to populate the database with good data (satisfying constraints), bad data (violating constraints), and to run constraint checking procedures implemented as views, stored procedures, and triggers. If you choose to download the individual files from the links, make sure you change the file extension to .sql. You can execute the SQL files in the Oracle SQL*Plus environment by typing '@<filename>'.
Schema schema
view
Views to Check Constraint Violations constraintCheckView
Store Procedures to Check Constraint Violations total_proc
disjoint_proc
attriDef_proc
assc_proc
other_proc
Triggers to Enforce Constraints trigger
Utility Scripts do_all
drop
util_proc
popBadData
popGoodData
checkConstraintsByView
del
ex
testTrigger
util