Page 217 - Contributed Paper Session (CPS) - Volume 3

CPS1997 Rawia Wagih Abd ElMagid ElSayed R. et al.

Figure (1) - the flow structural database

3. Result
1. Using Microsoft Excel (2010) to delete any duplication of data with
sorting data according to the government code, activity group and
establishment name/ label, example is showmen in Figure (2).
2. After deleting any duplicate from the previous step, we create unique
code for each establishment using oracle developer 10g.

Name of govern
Act_
gov_
Address establishment economy code name ment serial
activity
(label) code
33 a Ramssus EL Gowhara for Mobilization 10 cairo 1 3862
st. international of Tea
industries
33 a Ramssus EL Gowhara for Biscuit 10 cairo 1 2918
st. food industries

8 st 6 october EL SHARKIA for Manufacture 10 cairo 1 9858
in gasr el swez the confectionery of food
industry Couvrtina products
8 st 6 october EL SHARKIA for Chocolate 10 cairo 1 3773
the confectionery
industry Couvrtina
46 Abdel EL_Arab for Food - Manufacture 10 cairo 1 9863
Khalak Tharwat Groppi of food
st. products
46 Abdel EL_Arab for Food - dessert 10 cairo 1 3826
Khalak Tharwat Groppi
st.
Figure (2) - database of establishment frame

206 | I S I W S C 2 0 1 9