DataCity models a typical job posting platform with the added benefit of candidates leaving precise reviews to add objectivity and transparency to the interview process for software and data engineering roles.

This product displays how this can be accomplished with certain parties, such as Human Resources and Hiring Managers, having access to particular features of the product while at the same time providing job seekers an advantage by having the ability to view other candidates’ experiences.

ER Diagram

ER Diagram

Close

Relational Model

Relational Model

Close

Use Cases & SQL Statements

• Job Entity
• Resume Entity
• Candidate Entity

Job Entity

Post New Job Delete Job Update Job Salary Find minimum and maximum salary from the posted jobs Find jobs for which resumes have been received.

Actor: Human Resources

Steps

1. User clicks on the "Post New Job" button.
2. New Job page is displayed with fields to be filled.

Insert SQL Statement

Actor: Human Resources

Steps

1. User clicks on the "Remove Job Posting" button.
2. Data on the job is displayed to the user. User removes jobs for which resumes have not been received.
3. Users will be asked to confirm the removal.
4. When confirmed the data related to it will be removed.

Delete SQL Statement

Actor: Human Resources

Steps

1. User clicks on the "Edit Job" button.
2. Job Posting data is displayed.
3. Users will be able to change the Job Salary.
4. Users will be asked to confirm after changing the data.
5. New changes to data will be displayed to the user.

Update SQL Statement

Actor: Job seeker

Steps

1. User accesses database
2. Job Postings data are displayed.
3. User filters jobs according to salary specifying minimum and maximum as filters.
4. The 2 specific jobs with min and max salary are displayed.

Aggregate SQL Statement

Actor: Human Resources

Steps

1. User accesses database to display jobs.
2. User clicks on button to filter jobs.
3. User checks filter for jobs that have been already applied to. User submits query.
4. Jobs that have been applied to with a resume are displayed.

Join SQL Statement

Close