Author

idnameemail
1Alice Smithalice@example.com
2Bob Johnsonbob@example.com
3Charlie Browncharlie@example.com
4David Leedavid@example.com
5Eva Greeneva@example.com

Category

idtitledescription
1PoliticsLatest political events.
2CultureCultural happenings around the world.
3TechnologyThe latest tech trends.
4BusinessGlobal business news.
5EntertainmentHollywood gossip and entertainment news.

Publication

idnameaddress
1New York Times229 W 43rd St, New York, NY 10036, USA
2Washington Post1301 K Street NW, Washington, DC 20071, USA
3Wall Street JournalOne Market Plaza, San Francisco, CA 94105, USA
4Los Angeles Times202 W 1st St, Los Angeles, CA 90012, USA
5USA Today1 Tower Center Blvd, Secaucus, NJ 07094, USA

Article

idtitlecontentnews_content_typevolumedateauthor_idcategory_idpublication_id
(→ Author.id)(→ Category.id)(→ Publication.id)
1Opinion on BrexitThis is a piece about...Opinion Piece012024-03-07 23:50:16111
2Climate Change SolutionsA discussion about...Opinion Piece022024-03-07 23:50:16232
3Apple Launches iPhone 12Details of Apple’s new phone.Feature Article012024-03-07 23:50:16343
4Tesla’s Solar RoofInnovations by Tesla in solar energy.Feature Article032024-03-07 23:50:16454
5Stock Market RisesDetails of today’s stock market rise.News012024-03-07 23:50:16525
6Football Game ResultsResults of last night’s football game.Sports022024-03-07 23:50:16161