Author: Harshit Bansal
Submission: Schema + Sample Data + Queries + Video Demo

• User registration and authentication (Users table)
• Separate profiles for job seekers and employers
• Resume upload metadata (Resumes table)
• Employers can create, update, delete job postings
• Job seekers can apply to jobs using uploaded resumes
• Employers can manage applications via status updates
• Employer dashboard to view postings and applications
• SQL queries for search and filtering by title, location, company, and skills

• Saved jobs (Saved_Jobs table)
• Notifications (Notifications table)
• Audit logs for actions (Audit_Log table)
• Auto-expiry of jobs via date comparison

Includes:

• 2 Job Seekers and 2 Employers
• 3 Job Postings
• 3 Applications
• Multiple resume entries
• Saved jobs, notifications, and logs

All INSERT statements are in queries.sql.

1. Run schema.sql to create the database tables.
2. Run queries.sql to populate with demo data and test features.
3. Review query results in your MySQL client to validate behavior.

Tested on MySQL v5.7+.

• A short video (under 10MB) demonstrates the schema execution and query results.
• The video file is submitted as part of this assignment.

Thank you for reviewing my project! ✨