| CompanyID | Name | Location |
|---|---|---|
| 1 | ABC Corp. | New York |
| 2 | XYZ Inc. | San Francisco |
| RoleID | RoleName |
|---|---|
| 1 | Economist |
| 2 | Statistician |
| DataTypeID | DataTypeName |
|---|---|
| 1 | Demographics |
| 2 | Financial Analysis |
| JobID | Title | Description | PostedDate | CompanyID | ROLEID | DATAID |
|---|---|---|---|---|---|---|
| (→ Companies.CompanyID) | (→ Roles.RoleID) | (→ DataTypes.DataTypeID) | ||||
| 1 | Economic Analyst | Analyze economic data... | 2023-01-01 | 1 | 1 | 1 |
| 2 | Economic Analyst | Analyze economic data... | 2023-01-02 | 2 | 1 | 2 |
| 3 | Statistical Analyst | Analyze statistical data... | 2023-01-01 | 1 | 2 | 1 |
| 4 | Statistical Analyst | Analyze statistical data... | 2023-01-02 | 2 | 2 | 2 |
| ApplicantID | FirstName | LastName | |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| ApplicationID | ApplicantID | JobID | SubmissionDate | Status |
|---|---|---|---|---|
| (→ Applicants.ApplicantID) | (→ Jobs.JobID) | |||
| 1 | 1 | 1 | 2023-01-01 | Pending |
| 2 | 2 | 2 | 2023-01-02 | Pending |