EquipmentTypes

idTypeName
1DSLR Camera
2Mirrorless Camera
3Drone

NewsPhotographers

idFirstNameLastNameBirthDateNationality
(→ Countries.CountryName)
1JohnSmith1980-06-23USA
2JaneDoe1978-05-12Canada
3AliceBrown1992-03-15UK

Videographers

idFirstNameLastNameBirthDateNationality
(→ Countries.CountryName)
1MikeJohnson1990-04-01Australia
2DavidWilson1985-02-05Germany
3EmmaJackson1994-08-29France

VisualJournalism

idContentIDDescriptionVisualTypeEquipmentTypeId
(→ Contents.id)(→ EquipmentTypes.id)
11This is a news photography content.Photo1
22Another news photography content.Photo2
33A videography content about politics.Video1
44Some other videography content.Video3

EquipmentUsed

idVisualJournalismIdEquipmentTypeIdSerialNumberPurchaseYear
(→ VisualJournalism.id)(→ EquipmentTypes.id)
111ABC1232018
221DEF4562019
331GHI7892020
443JKL0122021

Contents

idTitlePublishDateAuthorId
(→ Authors.id)
1Breaking News: Election Results2022-01-011
2World Cup Final Match Highlights2022-07-152
3Climate Change Conference Summary2022-11-013
4Tech Innovations of The Year2022-12-014

Authors

idFirstNameLastNameBirthDateCountryName
(→ Countries.CountryName)
1TomHanks1962-07-09USA
2JulieAndrews1935-10-01UK
3GeorgeClooney1961-05-06USA
4AngelinaJolie1975-05-04USA
5LeonardoDiCaprio1974-11-11USA

Countries

CountryName
USA
UK
Australia
Germany
France