Magazines
id | name |
1 | Good Housekeeping |
2 | National Geographic |
3 | Time |
4 | Forbes |
5 | The Economist |
AdvertisingRevenues
id | mag_id | revenue |
| (→ Magazines.id) | |
1 | 1 | 20000.0 |
2 | 2 | 30000.0 |
3 | 3 | 25000.0 |
4 | 4 | 35000.0 |
5 | 5 | 40000.0 |
SubscriptionFees
id | mag_id | fee |
| (→ Magazines.id) | |
1 | 1 | 100.0 |
2 | 2 | 120.0 |
3 | 3 | 90.0 |
4 | 4 | 130.0 |
5 | 5 | 160.0 |
MagazineDetails
id | mag_name | ad_revenue | sub_fees |
| (→ Magazines.name) | (→ AdvertisingRevenues.revenue) | (→ SubscriptionFees.fee) |
1 | Good Housekeeping | 20000.0 | 100.0 |
2 | National Geographic | 30000.0 | 120.0 |
3 | Time | 25000.0 | 90.0 |
4 | Forbes | 35000.0 | 130.0 |
5 | The Economist | 40000.0 | 160.0 |