News_Contents

idTitleContentNews_TypeVolume_ID
(→ Volumes.id)
1First OpinionThis is an opinion piece...Opinion Piece1
2Second FeatureAnother feature article...Feature Article1
3Third OpinionYet another opinion piece...Opinion Piece2
4Fourth FeatureMore on features...Feature Article2
5Mixed BagA mix of news types...Miscellaneous3

Authors

idName
1John Doe
2Jane Smith
3Alice Johnson
4Bob Brown
5Charlie White

Articles

idAuthor_IDPublished_Date
(→ Authors.id)
112022-01-01
222022-02-01
332022-03-01
442022-04-01
552022-05-01

Volumes

idIssue_Number
101
202
303
404
505

Publications

idVolume_IDPublisher_Name
(→ Volumes.id)
11Newspaper A
22Newspaper B
33Newspaper C
44Newspaper D
55Newspaper E