Summary

This chapter has defined a database structure that will be used to build the 3T application. We have connected to the MySQL server and executed a series of SQL statements to create and populate a set of tables. Each table uses autoincrement columns to allow MySQL to automatically manage and generate primary keys. Although the table structures are not complex, we have also identified possible enhancements that could be appropriate for enterprise use.

In Chapter 3, Reverse Engineering the Domain Layer with JPA, we will start our Java journey by reverse engineering our database to create a set of Java Persistence API (JPA) entities. Our JPA domain layer will become the data heart of our 3T application.