Description

—
DATABASE USED IN MULTIPLE QUESTIONS
The following is a relational database used in multiple questions on this exam.
POLITICIAN PName Gender Age Office Country Region
Donald Trump Male 76 President United States null
Boris Johnson Male 58 Prime Minister United Kingdom null
Angela Merkel Female 68 Chancellor Germany null
Maneka Gandhi Female 70 MP India Pilibhit
Varun Gandhi Male 40 MP India Sultanpur
COUNTRY CName Continent GDP Population LitRate LifeExp
United States North America 553399441 271031325 96 68
Canada North America 81944919 18990131 99 73
IS RELATED Politician1 Politician2 Type
Maneka Gandhi Varun Gandhi Mother
Varun Gandhi Maneka Gandhi Son
BORDERS Country1 Country2
United States Canada
Canada United States
VISITED PName Country
Donald Trump Saudi Arabia
Boris Johnson South Africa
You can assume that the relations BORDERS and IS RELATED are symmetric (i.e. all pairs listed in both directions as shown below).
You can assume that only current elected officials are listed in the POLITICIAN and IS RELATED relations.
For asymmetric relationships such as father/daughter/uncle/nephew in the IS RELATED relation, the person matching the named role comes first (e.g. Maneka Gandhi is the mother of Varun Gandhi, and Varun Gandhi is the son).
GDP means Gross Domestic Product.
CITY CName Population Country Region Mayor PrimaryZipCode
Baltimore 530000 United States Maryland Brandon Scott 21201
Philadelphia 2300000 United States Pennsylvania Jim Kenney 19101