Breaking_News

idEventDateSourceReporter
1Turkey–Syria Earthquakes2023-01-01 12:34:56ReutersJohn Smith
2Political Crisis in Europe2023-01-02 10:20:00BBCEmma Jones

News_Analysis

idEventAnalysisPublished_DateAuthor
1Turkey–Syria EarthquakesIn-depth analysis of the earthquake impact on both countries...2023-01-03 18:45:00Jane Doe
2Climate Change Impact on DisastersA comprehensive study on how climate change is contributing to natural disasters...2023-01-04 09:00:00Michael Brown

Journalists

idNameEmailDepartment
1Alice Johnsonalice@example.comWorld Affairs
2Robert Williamsrobert@example.comEnvironment

Articles

idTitleContentPublication_DateWriter_ID
(→ Journalists.id)
1The Rising Tension Between Two NationsAn article discussing the recent escalations between two nations...2023-01-01 17:00:001
2Saving the Coral ReefsA detailed guide on protecting coral reefs around the world...2023-01-02 12:00:002

Comments

idArticle_IdCommenter_NameTextPosted_At
(→ Articles.id)
11User1Great insight! Keep up the good work.2023-01-01 18:00:00
22User2Very informative article. I learned a lot about coral reef conservation.2023-01-02 14:00:00