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.
- Add the Critique table and define the columns and column attributes in the table. See Adding the Critique Table.
- 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.
- Add triggers to the Critique table. See Adding Triggers to the Critique Table.
- Add columns for new application settings to the Settings table. See Modifying the Settings Table.
- Add a column for the average of the overall ratings to the title table. See Modifying the Title Table.
- Create a new FmLib database diagram that includes the new Critique table. See Revising the FmLib Database Diagram.
- Create the foreign key relationship between the Critique and title tables. See Revising the FmLib Database Diagram.
- Create the foreign key relationship between the Critique and borrower tables. See Revising the FmLib Database Diagram.
- Modify and add stored procedures. See Adding CML/LitCrit Stored Procedures.