| ID | Office_Address | City |
|---|---|---|
| 1 | 123 Main St | New York |
| 2 | 456 Elm St | Los Angeles |
| 3 | 789 Oak St | Chicago |
| 4 | 012 Pine St | Miami |
| 5 | 321 Fir St | Boston |
| ID | Name |
|---|---|
| 1 | Engineering |
| 2 | Marketing |
| 3 | Human Resources |
| 4 | Finance |
| 5 | IT |
| ID | Position_Title | Description | Duration |
|---|---|---|---|
| 1 | Software Engineering Intern | Help develop software applications. | 12 |
| 2 | Graphic Design Intern | Create visual designs for marketing materials. | 12 |
| 3 | HR Intern | Assist with recruitment and onboarding processes. | 12 |
| 4 | Financial Analyst Intern | Analyze financial data and support decision-making. | 12 |
| 5 | Network Engineer Intern | Support network infrastructure and troubleshoot issues. | 12 |
| ID | First_Name | Last_Name | Phone_Number | Hire_Date | |
|---|---|---|---|---|---|
| 1 | John | Doe | john.doe@example.com | +1 234-567-8901 | 2024-02-19 12:27:01 |
| 2 | Jane | Smith | jane.smith@example.com | +1 345-678-9012 | 2024-02-19 12:27:01 |
| 3 | Alice | Johnson | alice.johnson@example.com | +1 456-789-0123 | 2024-02-19 12:27:01 |
| 4 | Bob | Williams | bob.williams@example.com | +1 567-890-1234 | 2024-02-19 12:27:01 |
| 5 | Emma | Brown | emma.brown@example.com | +1 678-901-2345 | 2024-02-19 12:27:01 |
| ID | Title | Description | Required_Skills | Salary | Application_Deadline | Office_ID | Departments_ID | Internships_ID |
|---|---|---|---|---|---|---|---|---|
| (→ Office.ID) | (→ Department.ID) | (→ Internship_Position.ID) | ||||||
| 1 | Software Developer | Design, code, and maintain software systems. | JavaScript, HTML, CSS | 80000.0 | 2023-05-31 23:59:59 | 1 | 1 | None |
| 2 | Digital Marketing Specialist | Plan and execute digital marketing campaigns. | SEO, SEM, Social Media | 60000.0 | 2023-05-31 23:59:59 | 2 | 2 | None |
| 3 | Recruiter | Source, screen, and interview candidates. | Applicant Tracking Systems | 50000.0 | 2023-05-31 23:59:59 | 3 | 3 | None |
| 4 | Accountant | Prepare financial reports and analyze data. | Excel, QuickBooks | 65000.0 | 2023-05-31 23:59:59 | 4 | 4 | None |
| 5 | System Administrator | Install, configure, and maintain computer systems. | Linux, Windows Server | 70000.0 | 2023-05-31 23:59:59 | 5 | 5 | None |
| ID | Full_name | Phone_number | Resume_url | Date_applied | Job_posting_id | |
|---|---|---|---|---|---|---|
| (→ Job_Posting.ID) | ||||||
| 1 | John Doe | johndoe@email.com | +1 234-567-8901 | https://www.example.com/resume-john-doe | 2024-02-19 12:27:01 | 1 |
| 2 | Jane Smith | janesmith@email.com | +1 345-678-9012 | https://www.example.com/resume-jane-smith | 2024-02-19 12:27:01 | 2 |
| 3 | Alice Johnson | alicejohnson@email.com | +1 456-789-0123 | https://www.example.com/resume-alice-johnson | 2024-02-19 12:27:01 | 3 |
| 4 | Bob Williams | bobwilliams@email.com | +1 567-890-1234 | https://www.example.com/resume-bob-williams | 2024-02-19 12:27:01 | 4 |
| 5 | Emma Brown | emmabrown@email.com | +1 678-901-2345 | https://www.example.com/resume-emma-brown | 2024-02-19 12:27:01 | 5 |