Understanding the database structure

If you don't have MySQL installed, head over to the MySQL link (https://dev.mysql.com/downloads/installer) to install it and populate it with the world database, if it is not already available. The appendix will also guide you on how to run the queries using MySQL Workbench and MySQL command-line tool. 

The world database schema is depicted in the following diagram:

The database schema is simple, containing three tables as follows:

  • city: List of cities mapped to the three character country coded in the country table.
  • country: List of countries where the primary key is the three character country code. ...

Get Spring 5.0 Projects now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.