The new database table is required to keep track of national country currencies.

    1      --
    2      -- This SQL script created by somusar/SoProMach[tm]
    3      --
    4      
    5      create table country (
    6          countryname               varchar(40)    not null,
    7          currency                  varchar(40)    not null,
    8          constraint pk_country     primary key    (countryname)
    9      )
   10      ;
   11      
	       

The changes caused by adding field currency can be seen on lines 25-33, 36, 46-48, 58-60.

    1      /*
    2       * This Java class generated by somusar/SoProMach[tm].
    3       */
    4      
    5      package com.somusar.entdemo.location;
    6      
    7      /**
    8       *   Class Country:
    9       *
   10       *   A national country.
   11       */
   12      
   13      
   14      public class Country {
   15      
   16          // Map enum 'Country' onto an int with a set of values
   17          public final int USA                = 0; // USA
   18          public final int CANADA             = 1; // Canada
   19          public final int JAPAN              = 2; // Japan
   20          public final int FRANCE             = 3; // France
   21          public final int UK                 = 4; // UK
   22          public final int ESPANA             = 5; // Espaņa
   23          public final int INDIA              = 6; // India
   24      
   25          // Map enum 'Currency' onto an int with a set of values
   26          public final int US_DOLLAR          = 0; // US dollar
   27          public final int CND_DOLLAR         = 1; // Canadian dollar
   28          public final int YEN                = 2; // Yen
   29          public final int FRENCH_FRANC       = 3; // French franc
   30          public final int UK_POUND           = 4; // UK pound
   31          public final int PESETA             = 5; // Peseta
   32          public final int RUPIA              = 6; // Rupia
   33          public final int EURO               = 7; // Euro
   34      
   35          private int          countryName;        // enum 'Country'
   36          private int          currency;           // enum 'Currency'
   37          
   38          /*
   39           *   Get methods
   40           */
   41      
   42          public int getCountryName() {
   43              return countryName;
   44          }
   45      
   46          public int getCurrency() {
   47              return currency;
   48          }
   49      
   50          /*
   51           *   Set methods
   52           */
   53      
   54          public void setCountryName( int countryName ) {
   55              this.countryName = countryName;
   56          }
   57      
   58          public void setCurrency( int currency ) {
   59              this.currency = currency;
   60          }
   61      
   62      }
	       

Entity person_info, that formerly embedded country, has now a link to it. The related changes can be seen on lines 37, 54-57, 74-77.

    1      #ifndef __PersonInfo__
    2      #define __PersonInfo__
    3      
    4      /*
    5       *   -----------------------------------------------------------------
    6       *   Class PersonInfo
    7       *
    8       *   Private information, to be kept distinct from employee 
    9       *   info.
   10       *   -----------------------------------------------------------------
   11       * 
   12       *   [This header generated by somusar/SoProMach[tm].]
   13       */
   14      
   15      
   16      
   17      #ifndef __dummy_classes__
   18      #   define __dummy_classes__
   19      
   20      /* Dummy declarations, just for compiling.  */
   21      class Collection { char s[100]; };
   22      class Object     { char s[100]; };
   23      
   24      #endif
   25      
   26      #include <String.h>
   27      
   28      #include "location/Country.h"
   29      #include "Image.h"
   30      
   31      class PersonInfo {
   32      
   33      private:
   34      
   35          int          age;                // 18-120; would fit in a uint8
   36          String       ssn;                
   37          int          nationalityCountryName;        // relationship to Country
   38          Image        photo;              
   39      
   40      public:
   41      
   42          /*
   43           *   Get methods
   44           */
   45      
   46          int getAge() {
   47              return age;
   48          }
   49      
   50          String getSsn() {
   51              return ssn;
   52          }
   53      
   54          int getNationalityCountryName() {
   55              return nationalityCountryName;
   56          }
   57      
   58          Image getPhoto() {
   59              return photo;
   60          }
   61      
   62          /*
   63           *   Set methods
   64           */
   65      
   66          void setAge( int age ) {
   67              this->age = age;
   68          }
   69      
   70          void setSsn( String ssn ) {
   71              this->ssn = ssn;
   72          }
   73      
   74          void setNationalityCountryName( int nationalityCountryName ) {
   75              this->nationalityCountryName = nationalityCountryName;
   76          }
   77      
   78          void setPhoto( Image photo ) {
   79              this->photo = photo;
   80          }
   81      
   82      };
   83      
   84      #endif /* __PersonInfo__ */