| ID | Name | Age | Experience |
|---|---|---|---|
| 1 | John Doe | 30 | 2 years |
| 2 | Jane Smith | 28 | 3 years |
| 3 | Michael Johnson | 40 | 6 years |
| 4 | Linda Williams | 35 | 7 years |
| 5 | David Brown | 29 | 5 years |
| ID | Name | Age | PublicationsCount |
|---|---|---|---|
| 1 | Robert White | 32 | 10 |
| 2 | Emily Black | 29 | 8 |
| 3 | Kevin Green | 45 | 12 |
| 4 | Laura Blue | 37 | 9 |
| 5 | Chris Red | 33 | 7 |
| LanguageID | LanguageName |
|---|---|
| 1 | English |
| 2 | French |
| 3 | German |
| 4 | Spanish |
| 5 | Italian |
| JournalistID | EditorID | LanguageID | ProficiencyLevel |
|---|---|---|---|
| (→ Journalists.ID) | (→ Editors.ID) | (→ Languages.LanguageID) | |
| 1 | 1 | 1 | Fluent |
| 2 | 2 | 2 | Intermediate |
| 3 | 3 | 3 | Native |
| 4 | 4 | 4 | Advanced |
| 5 | 5 | 5 | Beginner |
| PostID | Title | Description | Deadline |
|---|---|---|---|
| 1 | Breaking News Reporter | Report on breaking news stories. | 2023-04-01 |
| 2 | Feature Writer | Write in-depth articles and features. | 2023-04-15 |
| 3 | Investigative Journalist | Conduct investigative journalism. | 2023-04-30 |
| 4 | News Anchor | Anchor daily news broadcasts. | 2023-05-10 |
| 5 | Reporter | Cover local events and write reports. | 2023-05-15 |
| AssignmentID | PostID | JournalistID | EditorID |
|---|---|---|---|
| (→ Posts.PostID) | (→ Journalists.ID) | (→ Editors.ID) | |
| 1 | 1 | 1 | 1 |
| 2 | 2 | 2 | 2 |
| 3 | 3 | 3 | 3 |
| 4 | 4 | 4 | 4 |
| 5 | 5 | 5 | 5 |