-
Book Overview & Buying
-
Table Of Contents
Google Web Toolkit 2 Application Development Cookbook
By :
In this recipe, we are going to create the Employee table with the foreign key attribute, namely, BranchId.
Open the MySQL Query Browser and create the employee table, as we did in the preceding recipe.
![]() |
Select the Foreign Keys tab.
Press the + (plus) symbol at the bottom.
Enter FK_Employee_Branch_BranchId as the Foreign Key Name.
![]() |
Click on OK.
Select Branch from the Ref. Table.
Select Restrict from the On Delete combo box.
Select Cascade from the On Update combo box.
Click on Apply Changes | Execute.
![]() |
Click on Close.
In this same way, all the other tables have to be created.
Create all the tables as shown in the following screenshots in this section. Alternatively, you can download the SQL script from the Packt website to create all the tables instantly. To use the script, follow the Restoring the database recipe.
Table Name: stock
![]() |
Table Name: supplier
![]() |
Table Name: customer
![]() |
Table...
Change the font size
Change margin width
Change background colour





