← Back to Projects

Veterinary Database Management System

Coding
Veterinary Database Management System

Overview

A database management system for veterinary clinics that handles pet records, owner records, vet records, and breed information.

Our team featured three CMU students who worked on creating the database schema and implementing the necessary procedures. We designed and implemented a relational database for an imaginary veterinary clinic using SQL. The system had four entities - vet, pet, owner, breed - and included keys, constraints, and some example queries.

It supports operations such as creating, retrieving, searching, and deleting records. The system is built using SQL and PL/SQL for efficient data management and querying.

Technologies Used

SQLPL/SQL