AuthorID | Name | Age | |
---|---|---|---|
1 | John Doe | johndoe@example.com | 28 |
2 | Jane Smith | janesmith@example.com | 35 |
3 | Emily Johnson | emilyjohnson@example.com | 27 |
4 | Michael Brown | michaelbrown@example.com | 31 |
5 | Kelly White | kellywhite@example.com | 29 |
ArticleID | Title | Content | Date | AuthorID |
---|---|---|---|---|
(→ Authors.AuthorID) | ||||
1 | The Importance of Journalism | Journalism has always been a crucial... | 2024-03-07 23:24:52 | 1 |
2 | The Future of Print Media | With the rise of digital media, print media is facing challenges... | 2024-03-07 23:24:52 | 2 |
3 | How Online Media is Changing Society | As online media becomes more prevalent, it is changing how society consumes information. | 2024-03-07 23:24:52 | 3 |
4 | Investigative Reporting Techniques | This article will discuss techniques used by investigative reporters... | 2024-03-07 23:24:52 | 4 |
5 | Ethics in Modern Journalism | This piece explores the ethical dilemmas faced by modern journalists... | 2024-03-07 23:24:52 | 5 |
ChannelID | PlatformType | AudienceSize | Revenue |
---|---|---|---|
1 | Print Media | 300000 | 1000000 |
2 | Print Media | 200000 | 600000 |
3 | Online Media | 300000 | 800000 |
4 | Online Media | 100000 | 400000 |
5 | Broadcast Media | 150000 | 1200000 |
ArticleID | ChannelID |
---|---|
(→ Articles.ArticleID) | (→ Distribution_Channels.ChannelID) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
ReaderID | FirstName | LastName | RegistrationDate |
---|---|---|---|
1 | John | Smith | 2024-03-07 23:24:52 |
2 | Jane | Brown | 2024-03-07 23:24:52 |
3 | Emily | White | 2024-03-07 23:24:52 |
4 | Mike | Green | 2024-03-07 23:24:52 |
5 | Kelly | Black | 2024-03-07 23:24:52 |
SubscriptionID | ReaderID | StartDate | EndDate |
---|---|---|---|
(→ Readers.ReaderID) | |||
1 | 1 | 2021-01-01 | None |
2 | 2 | 2021-02-01 | None |
3 | 3 | 2021-03-01 | None |
4 | 4 | 2021-04-01 | None |
5 | 5 | 2021-05-01 | None |