| 第一正規化 |
|
|
|
|
|
|
|
|
|
|
|
|
TRANSLATOR |
WORKS
FOR |
LANGUAGE |
|
|
TRAN_ID |
TRAN_NAME |
TRAN_ADD |
TRAN_PHONE |
CMP_ID |
CMP_NAME |
LAN_NUM |
LAN_ID |
LAN_NAME |
|
|
1 |
A |
111 1st |
555-555-5555 |
10 |
XYZ |
1 |
10 |
SPANISH |
|
|
1 |
A |
111 1st |
555-555-5555 |
10 |
XYZ |
2 |
20 |
FRENCH |
|
|
2 |
B |
112 1st |
555-555-5556 |
10 |
XYZ |
1 |
20 |
FRENCH |
|
|
2 |
B |
112 1st |
555-555-5556 |
10 |
XYZ |
2 |
50 |
ARABIC |
|
|
3 |
C |
113 1st |
555-555-5557 |
20 |
XXX |
1 |
30 |
PERSIAN |
|
|
3 |
C |
113 1st |
555-555-5557 |
20 |
XXX |
2 |
40 |
GERMAN |
|
|
4 |
D |
114 1st |
555-555-5558 |
20 |
XXX |
1 |
30 |
PERSIAN |
|
|
5 |
E |
115 1st |
555-555-5559 |
30 |
WWW |
1 |
20 |
FRENCH |
|
|
5 |
E |
115 1st |
555-555-5559 |
30 |
WWW |
2 |
50 |
ARABIC |
|
|
6 |
F |
116 1st |
555-555-5560 |
30 |
WWW |
1 |
10 |
SPANISH |
|
|
7 |
G |
117 1st |
555-555-5561 |
10 |
XYZ |
1 |
20 |
FRENCH |
|
|
7 |
G |
117 1st |
555-555-5561 |
10 |
XYZ |
2 |
10 |
SPANISH |
|
|
7 |
G |
117 1st |
555-555-5561 |
10 |
XYZ |
3 |
40 |
GERMAN |
|
|
8 |
H |
118 1st |
555-555-5562 |
20 |
XXX |
1 |
30 |
PERSIAN |
|
|
9 |
I |
119 1st |
555-555-5563 |
10 |
XYZ |
1 |
30 |
PERSIAN |
|
|
10 |
J |
120 1st |
555-555-5564 |
30 |
WWW |
1 |
40 |
GERMAN |
|
|
10 |
J |
120 1st |
555-555-5564 |
30 |
WWW |
2 |
50 |
ARABIC |
|
|
10 |
J |
120 1st |
555-555-5564 |
30 |
WWW |
3 |
30 |
PERSIAN |
|
|
| 第二正規化 |
|
|
TRAN_ID |
TRAN_NAME |
TRAN_ADD |
TRAN_PHONE |
CMP_ID |
CMP_NAME |
|
TRAN_ID |
LAN_NUM |
LAN_ID |
LAN_NAME |
|
1 |
A |
111 1st |
555-555-5555 |
10 |
XYZ |
|
1 |
1 |
10 |
SPANISH |
|
2 |
B |
112 1st |
555-555-5556 |
10 |
XYZ |
|
1 |
2 |
20 |
FRENCH |
|
3 |
C |
113 1st |
555-555-5557 |
20 |
XXX |
|
2 |
1 |
20 |
FRENCH |
|
4 |
D |
114 1st |
555-555-5558 |
20 |
XXX |
|
2 |
2 |
50 |
ARABIC |
|
5 |
E |
115 1st |
555-555-5559 |
30 |
WWW |
|
3 |
1 |
30 |
PERSIAN |
|
6 |
F |
116 1st |
555-555-5560 |
30 |
WWW |
|
3 |
2 |
40 |
GERMAN |
|
7 |
G |
117 1st |
555-555-5561 |
10 |
XYZ |
|
4 |
1 |
30 |
PERSIAN |
|
8 |
H |
118 1st |
555-555-5562 |
20 |
XXX |
|
5 |
1 |
20 |
FRENCH |
|
9 |
I |
119 1st |
555-555-5563 |
10 |
XYZ |
|
5 |
2 |
50 |
ARABIC |
|
10 |
J |
120 1st |
555-555-5564 |
30 |
WWW |
|
6 |
1 |
10 |
SPANISH |
|
7 |
1 |
20 |
FRENCH |
|
7 |
2 |
10 |
SPANISH |
|
7 |
3 |
40 |
GERMAN |
|
8 |
1 |
30 |
PERSIAN |
|
9 |
1 |
30 |
PERSIAN |
|
10 |
1 |
40 |
GERMAN |
|
10 |
2 |
50 |
ARABIC |
|
10 |
3 |
30 |
PERSIAN |
|
| 第三正規化 |
|
|
TRAN_ID |
TRAN_NAME |
TRAN_ADD |
TRAN_PHONE |
CMP_ID |
|
|
1 |
A |
111 1st |
555-555-5555 |
10 |
|
|
2 |
B |
112 1st |
555-555-5556 |
10 |
|
|
3 |
C |
113 1st |
555-555-5557 |
20 |
|
|
4 |
D |
114 1st |
555-555-5558 |
20 |
|
|
5 |
E |
115 1st |
555-555-5559 |
30 |
|
|
6 |
F |
116 1st |
555-555-5560 |
30 |
|
|
7 |
G |
117 1st |
555-555-5561 |
10 |
|
|
8 |
H |
118 1st |
555-555-5562 |
20 |
|
|
9 |
I |
119 1st |
555-555-5563 |
10 |
|
|
10 |
J |
120 1st |
555-555-5564 |
30 |
|
|
|
CMP_ID |
CMP_NAME |
|
TRAN_ID |
LAN_NUM |
LAN_ID |
LAN_NAME |
|
|
10 |
XYZ |
|
1 |
1 |
10 |
SPANISH |
|
|
20 |
XXX |
|
1 |
2 |
20 |
FRENCH |
|
|
30 |
WWW |
|
2 |
1 |
20 |
FRENCH |
|
|
2 |
2 |
50 |
ARABIC |
|
|
3 |
1 |
30 |
PERSIAN |
|
|
3 |
2 |
40 |
GERMAN |
|
|
4 |
1 |
30 |
PERSIAN |
|
|
5 |
1 |
20 |
FRENCH |
|
|
5 |
2 |
50 |
ARABIC |
|
|
6 |
1 |
10 |
SPANISH |
|
|
7 |
1 |
20 |
FRENCH |
|
|
7 |
2 |
10 |
SPANISH |
|
|
7 |
3 |
40 |
GERMAN |
|
|
8 |
1 |
30 |
PERSIAN |
|
|
9 |
1 |
30 |
PERSIAN |
|
|
10 |
1 |
40 |
GERMAN |
|
|
10 |
2 |
50 |
ARABIC |
|
|
10 |
3 |
30 |
PERSIAN |
|
|
|
|
|
|
|
|
|
|
|
|
|
