Home page
Welcome to the Greentree Vet Clinic web application! This project demonstrates a database-driven veterinary clinic management system that fulfills all CS340 requirements. Below is a breakdown of how this implementation meets or exceeds each project specification:
Entity Relationship Diagram
Project Requirements Breakdown
| Minimum Requirement | Greentree Implementation |
|---|---|
| 3 rows of sample data illustrating each table's function | 4-5 rows of sample data per DB table |
| 4 entities | 5 entities plus 1 intersection table |
| 4 relationships (including 1 M:N relationship) | 4 relationships (including 1 M:N relationship) |
| Select/Read data from all tables | Data from all tables is being displayed |
| Create/Insert - 1 table, using PL/SQL | The user can Insert data into the Owners DB table through the corresponding form on the Owners webpage. The create form will call an SQL Stored Procedure that creates a new row in the Owners DB table. |
| Update - 1 table, using PL/SQL | The user can Update table data on the Appointsments-Vaccines intersection table through the corresponding form on the Appointments-Vaccines webpage. The update form will call an SQL Stored Procedure that updates the selected row from the Appointments-Vaccines DB table. |
| Update M:N - 1 M:N relationship | The user can update M:N relationships by updating foreign keys on the Appointsments-Vaccines intersection table through the corresponding form on the Appointments-Vaccines webpage. The update form will call an SQL Stored Procedure that updates the selected row from the Appointments-Vaccines DB table. |
| Delete - 1 table, using PL/SQL | The user can delete table data on the Appointments-Vaccines intersection table by using the corresponding delete buttons on the Appointments-Vaccines webpage. The delete buttons will call an SQL Stored Procedure that deletes a row from the Appointments-Vaccines DB table. |
| Delete M:N - 1 M:N relationship | The user can delete M:N relationships by deleting rows from the Appointsments-Vaccines intersection table by using the corresponding delete buttons on the Appointments-Vaccines webpage. The delete buttons will call an SQL Stored Procedure that deletes a row from the Appointments-Vaccines DB table. |
| RESET DB, using PL/SQL | The user can reset the database by clicking on the "Reset DB" link in the navigation bar at the top of the website. The associated URL will call an SQL Stored Procedure that will drop all tables, recreate all tables, and insert the sample data into all tables. |