degreeID | title | major |
---|---|---|
1 | Bachelor of Arts | Investigative Journalism |
2 | Master of Science | Data Journalism |
3 | Doctor of Philosophy | Mass Communication |
certificateID | name | issueDate |
---|---|---|
1 | Certified Data Analyst | 2021-06-15 |
2 | Advanced Reporting Skills | 2021-08-17 |
3 | Investigative Techniques | 2021-09-03 |
4 | Public Relations Management | 2021-10-08 |
5 | Crisis Communications | 2021-10-20 |
journalistID | firstName | lastName | degreeID | certificateID |
---|---|---|---|---|
(→ Degree.degreeID) | (→ Certificate.certificateID) | |||
1 | John | Doe | 1 | 1 |
2 | Jane | Smith | 2 | 2 |
3 | Emily | Johnson | 3 | 3 |
4 | Lisa | Brown | 1 | 4 |
5 | Chris | Green | 2 | 5 |
articleID | headline | content | publishedDate | journalistID |
---|---|---|---|---|
(→ Investigative_Journalist.journalistID) | ||||
1 | Political Scandals Exposed | A detailed investigation into political scandals. | 2021-11-01 | 1 |
2 | Environmental Disasters Averted | An investigative report on how environmental disasters were averted thanks to timely action. | 2021-11-10 | 2 |
3 | Healthcare System Overhauled | Exploring the changes in the healthcare system that have led to improved outcomes. | 2021-11-20 | 3 |
4 | Economic Recovery Underway | How economic recovery measures are helping businesses and individuals. | 2021-11-25 | 4 |
5 | Technology Advances Transforming Society | The impact of rapid technological advancements on society. | 2021-12-01 | 5 |
sourceID | name | type | contactInfo | articleID |
---|---|---|---|---|
(→ Article.articleID) | ||||
1 | Government Agency | Official Reports | www.govagency.com/reports | 1 |
2 | Nonprofit Organization | Research Papers | www.nonprofitorg.org/papers | 2 |
3 | Local Business | Financial Statements | www.localbusiness.com/financials | 3 |
4 | International NGO | Annual Reports | www.internationalgov.org/annuals | 4 |
5 | Academic Institution | Studies & Surveys | www.acadinst.edu/studies | 5 |