CPSC 304 Project

Our project enhances the reading experience by helping users track character relationships, important quotes, and thematic elements across books and series. It supports both casual readers and critics, offering features like personalized ratings, tagging, and searchable themes to better understand stories and discover new reads. By connecting characters, quotes, and themes, it makes exploring novels more interactive and engaging.

To run project -> enter into terminal:

 sqlplus ora_cwlUserName/aCWLpassword@dbhost.students.cs.ubc.ca:1522/stu < schema.sql

The following lines are recommended to enter into terminal after running schema, they will format SQLPlus output

 SET LINESIZE 200 
 SET PAGESIZE 100
 SET HEADING ON

Honorable Mentions:

CREATE OR REPLACE TRIGGER update_isbn
AFTER UPDATE OF ISBN ON BOOK
FOR EACH ROW
BEGIN
  UPDATE hasTheme
  SET ISBN = :NEW.ISBN
  WHERE ISBN = :OLD.ISBN;
  UPDATE hasTag
  SET ISBN = :NEW.ISBN
  WHERE ISBN = :OLD.ISBN;
  UPDATE appearsIn
  SET ISBN = :NEW.ISBN
  WHERE ISBN = :OLD.ISBN;
  UPDATE UserRating
  SET ISBN = :NEW.ISBN
  WHERE ISBN = :OLD.ISBN;
END;
/