Degree

degreeIDtitlemajor
1Bachelor of ArtsInvestigative Journalism
2Master of ScienceData Journalism
3Doctor of PhilosophyMass Communication

Certificate

certificateIDnameissueDate
1Certified Data Analyst2021-06-15
2Advanced Reporting Skills2021-08-17
3Investigative Techniques2021-09-03
4Public Relations Management2021-10-08
5Crisis Communications2021-10-20

Investigative_Journalist

journalistIDfirstNamelastNamedegreeIDcertificateID
(→ Degree.degreeID)(→ Certificate.certificateID)
1JohnDoe11
2JaneSmith22
3EmilyJohnson33
4LisaBrown14
5ChrisGreen25

Article

articleIDheadlinecontentpublishedDatejournalistID
(→ Investigative_Journalist.journalistID)
1Political Scandals ExposedA detailed investigation into political scandals.2021-11-011
2Environmental Disasters AvertedAn investigative report on how environmental disasters were averted thanks to timely action.2021-11-102
3Healthcare System OverhauledExploring the changes in the healthcare system that have led to improved outcomes.2021-11-203
4Economic Recovery UnderwayHow economic recovery measures are helping businesses and individuals.2021-11-254
5Technology Advances Transforming SocietyThe impact of rapid technological advancements on society.2021-12-015

Source

sourceIDnametypecontactInfoarticleID
(→ Article.articleID)
1Government AgencyOfficial Reportswww.govagency.com/reports1
2Nonprofit OrganizationResearch Paperswww.nonprofitorg.org/papers2
3Local BusinessFinancial Statementswww.localbusiness.com/financials3
4International NGOAnnual Reportswww.internationalgov.org/annuals4
5Academic InstitutionStudies & Surveyswww.acadinst.edu/studies5