Relationships - Customer Class
Add a new Class into the 'DEMO' system, called 'CUSTOMER', with 1 key part. Set the following attributes and derivations:
Attribute: CUSTOMER
Type: INT
Derivation: IF(CUSTOMER)THEN(CUSTOMER)ELSE(UNIQUE(DEMO_CUSTOMER_CUSTOMER))
Attribute: NAME
Type: CHAR[60]
Attribute: POSTCODE
Type: INT
Attribute: STATE
Type: CHAR[3]
Derivation: UPCASE(STATE)
| previous | next |
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 |
