Welcome to the repository for The College Data Management System project! This project showcases my skills and knowledge as I continue my journey to become a successful data engineer.
The College Data Management System is a comprehensive case study that simulates a data management solution for an imaginary college. It encompasses various steps and technologies, including database design, SQL implementation, data population, PL/SQL, Bash scripting, and Java application development.
- Database Design: Created an Entity Relationship Diagram (ERD) to design the database schema.
- SQL Implementation: Developed the database tables using Oracle SQL.
- Data Population: Generated realistic data using Python scripting to populate the database effectively.
- PL/SQL: Implemented functions, procedures, and triggers to enhance database functionality.
- Bash Script: Developed a Bash script to monitor disk usage and perform monthly full backups of the database.
- Java Application: Built a comprehensive desktop application using Java, featuring student enrollment, grading, data visualization, and more.
To explore the project in detail, please refer to the following documents:
To get started with the project, follow these steps:
- Clone the repository:
git clone https://github.com/your-username/your-repo.git - Set up the database by executing the SQL scripts.
- Run the Python script to populate the database with realistic data.
- Execute the Bash script to monitor disk usage and perform backups.
- Launch the Java application to interact with the College Data Management System.
I welcome any feedback or suggestions regarding the project. If you'd like to contribute, please feel free to submit a pull request. Let's learn and grow together!
This project is licensed under the MIT License.