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 |