For my first-year Computer Science module on databases, I designed and implemented a business solution using phpMyAdmin for a fictitious employment agency.
- 20 Fully Normalised Entities: Storing information on applicants, employers, and job applications.
- SQL Views: Created for business requirements, including application feedback.
- Java Application: Used for database interaction.
- Note: The application will not work for you as it requires being run on a specific network. Nonetheless, I've included it for reference.
- Comprehensive Documentation: Detailed documentation is provided.
An overview of the Applications table
The structure of the JobSeekers table
The JobSeekerApplicationStatus view
A snippet from the Java Database Connection
- To ensure that you don't lose your work, create an empty database.
- Follow this tutorial for step-by-step instructions on how to import my database (
schema.sql).
-
Data Dictionary
Stores the database's metadata. -
ER Diagram
Features descriptions of the relationships between the entities in my database. -
SQL Views Queries and Java Database Connection
Outlines the views and queries used for my database, detailing how the Java database connection was established, including example functions.