Updating the FmLib Database

The following modifications are necessary to make the FmLib database support the critique-enhanced library application and the LitCrit OutlookŪ application.

  1. Add the Critique table and define the columns and column attributes in the table. See Adding the Critique Table.
  2. Add a UNIQUE constraint to enforce the business rule of one critique per title for each reviewer. See Adding a UNIQUE Constraint to the Critique Table.
  3. Add triggers to the Critique table. See Adding Triggers to the Critique Table.
  4. Add columns for new application settings to the Settings table. See Modifying the Settings Table.
  5. Add a column for the average of the overall ratings to the title table. See Modifying the Title Table.
  6. Create a new FmLib database diagram that includes the new Critique table. See Revising the FmLib Database Diagram.
  7. Create the foreign key relationship between the Critique and title tables. See Revising the FmLib Database Diagram.
  8. Create the foreign key relationship between the Critique and borrower tables. See Revising the FmLib Database Diagram.
  9. Modify and add stored procedures. See Adding CML/LitCrit Stored Procedures.