Book Image

Building Applications with Spring 5 and Vue.js 2

By : James J. Ye
Book Image

Building Applications with Spring 5 and Vue.js 2

By: James J. Ye

Overview of this book

Building Applications with Spring 5 and Vue.js 2, with its practical approach, helps you become a full-stack web developer. As well as knowing how to write frontend and backend code, a developer has to tackle all problems encountered in the application development life cycle – starting from the simple idea of an application, to the UI and technical designs, and all the way to implementation, testing, production deployment, and monitoring. With the help of this book, you'll get to grips with Spring 5 and Vue.js 2 as you learn how to develop a web application. From the initial structuring to full deployment, you’ll be guided at every step of developing a web application from scratch with Vue.js 2 and Spring 5. You’ll learn how to create different components of your application as you progress through each chapter, followed by exploring different tools in these frameworks to expedite your development cycle. By the end of this book, you’ll have gained a complete understanding of the key design patterns and best practices that underpin professional full-stack web development.
Table of Contents (23 chapters)
Title Page
Copyright and Credits
Dedication
About Packt
Contributors
Preface
Index

Physical data modeling for RDBMS


In this stage, we will convert the logical data model into the physical data model of the target RDBMS. As mentioned, we will use MySQL and will create the physical data model using MySQL Workbench.

Here is what we are going to do:

  • Create a table for each entity.
  • Create a column for each attribute. Besides the name, we will define columns type, length, nullability, and default value.
  • Make primary keys auto increment.
  • Create indexes.

The naming convention

The naming convention of the physical data model has some differences with the naming convention of the logical data model:

  • We will use lowercase for tables, columns, and indexes, for example, the user table. And we will use underscore to connect multiple words, for example, the card_list table.
  • For foreign key definition, the key's name starts with fk_. The naming convention of the foreign keys is fk_<referencing table name>_<referenced table name>_<referencing field name>. For example, the foreign...