PetsCare is a local pet clinic that provides a range of services including pet wellness, medical care, surgery, dental cleaning, grooming, and more. This project aims to improve the clinic's record-keeping efficiency by implementing a Relational Database Management System (RDBMS).
The primary objectives of this project are as follows:
- Design, develop, and implement an RDBMS for PetsCare clinic.
- Enable easy and efficient storage, querying, and management of patient records, appointment schedules, medical history, billing information, and other relevant data.
- Create a user-friendly and intuitive interface for the RDBMS.
The project includes the following deliverables:
- Requirements gathering and analysis to identify the specific needs and challenges of PetsCare clinic.
- Creation of the Entity Relationship Diagram (ERD) based on the requirements analysis.
- Conversion of the ERD to the Relational Model.
- Normalization of the Relational Model to ensure data consistency and minimize redundancy.
- Development of a user interface to enable easy and efficient data entry, querying, and management.
- Testing and quality assurance to ensure the system meets the requirements and is free of bugs and errors.
- Navigate to the client directory:
cd client - Install dependencies:
npm install
- Navigate to the backend directory:
cd backend - Install dependencies:
npm install
- Install MySQL.
- Create a schema named 'petscare' in MySQL.
- Import data from the Dump folder placed in 'database file'.
- Navigate to the client directory:
cd client - Start the frontend:
npm start
- Navigate to the backend directory:
cd backend - Start the backend:
npm start
Start MySQL to ensure the RDBMS is accessible.
Please note that additional configuration steps may be required depending on your environment and specific setup.