| AuthorID | FirstName | LastName | EmailAddress |
|---|---|---|---|
| 1 | John | Doe | johndoe@example.com |
| 2 | Jane | Smith | janesmith@example.com |
| ArticleID | Title | Content | PublishDate | ViewCount |
|---|---|---|---|---|
| 1 | Article One | This is the content of article one. | 2024-02-19 14:58:28 | 100 |
| 2 | Article Two | Content of article two goes here. | 2024-02-19 14:58:28 | 80 |
| PublisherID | Name | WebsiteURL | FoundedYear |
|---|---|---|---|
| 1 | Publication A | https://www.publicationa.com | 2000 |
| 2 | Publication B | https://www.publicationb.com | 2001 |
| OperationID | OperationYears | OperationMonths | MediaOutlet | Revenue | Expenses | ProfitMargin |
|---|---|---|---|---|---|---|
| 1 | 10 | 12 | Newspaper X | 100000.0 | 75000.0 | 0.0 |
| 2 | 5 | 6 | Radio Y | 50000.0 | 30000.0 | 0.0 |
| ReaderID | FullName | EmailAddress | RegistrationDate |
|---|---|---|---|
| 1 | Alice Johnson | alicejohnson@example.com | 2024-02-19 14:58:28 |
| 2 | Bob Smith | bobsmit@example.net | 2024-02-19 14:58:28 |
| SubscriptionID | ReaderID | PublisherID | StartDate | EndDate | Price |
|---|---|---|---|---|---|
| (→ Readers.ReaderID) | (→ Publications.PublisherID) | ||||
| 1 | 1 | 1 | 2024-02-19 14:58:28 | None | 9.99 |
| 2 | 2 | 2 | 2024-02-19 14:58:28 | None | 12.99 |