id | Name | Format | Distributor | FoundedDate |
---|---|---|---|---|
(→ Distributors.Name) | ||||
1 | The Times | Broadsheet | Sainsbury's | 1785-01-01 |
2 | The Sun | Tabloid | Sainsbury's | 1964-03-17 |
3 | Mail on Sunday | Compact | Tesco | 1982-01-01 |
4 | Guardian Unlimited | Berliner | Tesco | 1999-01-01 |
5 | Financial Times | Tabloid | Direct delivery | 1888-01-01 |
id | Name | Address | PhoneNumber | EmailAddress |
---|---|---|---|---|
1 | Sainsbury's | 123 High St | +44 1234567890 | distribution@sainburys.com |
2 | Tesco | 456 Low St | +44 0987654321 | distribution@tesco.com |
id | Title | Content | PublicationDate | NewspaperId | AuthorId | CategoryId |
---|---|---|---|---|---|---|
(→ Newspapers.id) | (→ Authors.id) | (→ ArticleCategories.id) | ||||
1 | UK Election Results | Here are the results of the latest UK election. | 2021-10-01 | 2 | 1 | 1 |
2 | Stock Market Rises | The stock market experienced significant gains today. | 2021-10-01 | 3 | 2 | 2 |
id | FirstName | LastName | Birthdate |
---|---|---|---|
1 | John | Smith | 1960-01-01 |
2 | Jane | Doe | 1975-05-01 |
id | CategoryName | Description |
---|---|---|
1 | Politics | News about governmental activities |
2 | Economy | Business news and analysis |