## Degree

degreeID | title | major
--- | --- | ---
1 | Bachelor of Arts | Investigative Journalism
2 | Master of Science | Data Journalism
3 | Doctor of Philosophy | Mass Communication

## Certificate

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

## Investigative_Journalist

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

## Article

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

## Source

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