February 2019
Intermediate to advanced
442 pages
11h 46m
English
Content preview from Spring 5.0 Projects
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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. ...