Wednesday, February 1, 2012

wanna swim

If you order your cheap essays from our custom writing service you will receive a perfectly written assignment on wanna swim. What we need from you is to provide us with your detailed paper instructions for our experienced writers to follow all of your specific writing requirements. Specify your order details, state the exact number of pages required and our custom writing professionals will deliver the best quality wanna swim paper right on time.

Out staff of freelance writers includes over 120 experts proficient in wanna swim, therefore you can rest assured that your assignment will be handled by only top rated specialists. Order your wanna swim paper at affordable prices with LivePaperHelp.com!












Presented by


Cheap Custom Essays on wanna swim

essay writing service



Hebah Medhat


Mohammed Shaaban


Mona Sayed





Index


Topic Page Number


Acknowledgment


Introduction 4-5


Tools Used To Build The Site 6


References 6


Database 7-16


Designing The Pages 17-


Points Of Consideration


Conclusion 4


Acknowledgment


We are grateful to the many people who helped us with this project in one way or another, we would like to acknowledge all these who offered constructive comments and ideas.





These include


1. Mr. Abdel Megeed (Inform Manager)


. Mr. Sameh Farouk (Project Supervisor)


. Mr. Mohammed Abdel Monem (Coordinator)


4. Dr. Haitham Hanafy (Assistant Executive Manager at The Egyptian Kuwaiti Securities Brokerage)


Last but not least we gratefully acknowledge our parents for their constant encouragement through all the phases of our project.





Introduction


The main idea that we wanted to present by accomplishing the e-Broker site was to make a site specialized in the brokerage services aimed for beginners or experienced individuals.


The site is divided up into two parts; the first part includes the following


· General information about the Egyptian stock market.


· The privatization program


· General Info about all sectors of investment in the stock market


· Registration Form


The second part of the site is only available to users who are registered within the site no fees for exchange, which means that our services are free of charge, but the whole point of making the services unavailable to unregistered users, is to collect data about these users who are interested in our services, their geographical background and everything that can tell us why they are interested in our site.


The services provided in the second part of the site are


· Sector Search users can search for any sector that they are interested in investing at, in each sector there are a list of all the companies listed with in this sector.


· Company Search users can search for a particular company that they are interested in investing at, and all auxiliary information e.g. (Balance Sheet, Income Statement, Financial Performance, Stock Performance, Cash Flow Statement, Company Profile) will be provided about this particular company the users have searched for.


· Stock Search users can search for a specific stock using its Reuter code, the following data will be given to the user (Last G.A Date, Par Value, Date Offered, F.Y End)


· Comparison This is the service that is considered new to all present sites that exist on the Egyptian market, this service enables the users to compare between two companies if they are hesitant about investing on each one of them, our comparison is based on facts and numbers and not tips.


· Wap(Wireless Application Protocol) Another new service that has been included on the site to compete with the latest trends of technology is the ability to access the site via the mobile phones .





Tools Used to Build This Site


· Access Database


· Front Page for the Design of Pages


· Active Server Pages (ASP)


· Nokia 610 Simulator


· Nokia WAP Toolkit


References


· www.dynamichtml.com


· Kompass


· www.fpg.com


· www.activeserverpages.com


Phase one


Creating the Database


In order to create the database we had to know the entities that we have in hand and the kind of relationship that they will have with each other.


Identify the primary key to ensure data integrity.





The following Illustrates the Database schema





· All the bold fields are the primary keys of each table.


The following diagrams will represent each table with its fields and it’s properties


Balance Sheet Table


Field Name Data Type


BLNC_ID AutoNumber


CMP_ID Number


YEAR Text


FXD_ASTS Text


CONST Text


LNG_INVT Text


INVTRS Text


D_ASTS Text


SHRT_INVST Text


CSH_BNK Text


T_C_ASTS Text


T_PROV Text


S_T_DBT Text


O_CRD Text


T_CUR_LBLT Text


WRKG_CAPT Text


INVT_FINAN Text


P_CPT Text


RSV_RET_ERNGS Text


T_STCKH_EQUITY Text


L_TRM_DBT Text


T_INST Text


Company Profile


Field Name Data type


CMP_NAME Text


CMP_ADDRESS Text


CMP_EMPLOYS Text


CMP_HISTRY Memo


SECTOR_ID Number


CMP_CHAIRMAN Text


CMP_ACTIVITY Memo


CMP_SUBRS Memo


CMP_LGFRM Memo


CMP_ID AutoNumber


Cash Flow Statement


Field Name Data type


CSH_FLW_ID AutoNumber


CMP_ID Number


YEAR Text


N_CSH_FRM_OPS Text


N_CSH_FRM_INST Text


N_CSH_FRM_FINAN Text


N_INC_CSH Text


CSH_BIGN_YR Text


CSH_END_YR Text


Financial Performance


Field Name Data type


FIN_PERF_ID AutoNumber


CMP_ID Number


YEAR Text


DPS Text


DIV_GRWTH Text


DIV_YLD Text


DIV_PO Text


EPS Text


PERATIO Text


PRICE_BOKVALUE Text


SALS_GROS Text


NET_EARNG_GROS Text


FIN_LVG Text


ROE Text


CRT_RATIO Text


Income Statement


Field Name Data type


INCM_STAT_ID AutoNumber


CMP_ID Number


YEAR Text


NET_SLS Text


O_COSTS Text


GRS_PRFT Text


A_G_EXP Text


FIN_EXP Text


PROV Text


TL_EXP Text


INVT_INCM Text


INT_INC Text


O_REV Text


TL_REV Text


NT_O_PRFT Text


NT_EXP_LOS Text


O_REV_GNS Text


PRFT_BFR_TXS Text


TXS Text


NT_PRFT_AFT_TXS Text


Sector


Field Name Data Type


SECTOR_ID AutoNumber


NAME Text


STATUS Text


URL Text


Stock Performance


Field Name Data Type


STCK_PERF_ID AutoNumber


CMP_ID Number


YEAR Text


STCK_ID Number


MARKET_CAP Text


SHRS_LSTD Text


SHRS_OUT Text


SHRS_TRD Text


TRD_VALUE Text


NO_OF_TRANS Text


Y_CLOSE Text


Y_HIGH Text


Y_LOW Text


Stock


Field Name Data Type


STCK_ID AutoNumber


REUTER Text


CMP_ID Number


LAST_GA_DATE Date/Time


PAR_VALUE Text


DATE_OFFERED Text


F_Y_END Text


SWIFT Text


Users


Field Name Data Type


USR_NAME Text


USR_PASS Text


FST_NAME Text


LST_NAME Text


TITLE Text


AGE Text


GENDER Text


MOB_NO Text


CNCT_TEL Text


FAX Text


EMAIL Text


INDUSTRY Text


OCCUPATION Text


ADDRESS Text


ID AutoNumber


Bank Balance Sheet


Field Name Data Type


B_BALNCE_ID AutoNumber


CMP_ID Number


YEAR Text


CASH_DUEL Text


T_BILLS Text


T_INVST Text


LOANS_OVR Text


NT_INST Text


OD_ASSETS Text


FXD_ASSETS Text


T_ASSETS Text


DT_BNKS Text


C_DEPSTS Text


OC_PROV Text


LTD Text


T_LIABLITIES Text


PAID_CPTL Text


R_R_EARNGS Text


STCK_HLDS Text


CONRA_ACCT Text


Bank Financial Performance


Field Name Data Type


B_FINAN_ID AutoNumber


CMP_ID Number


YEAR Text


DPS Text


DVD_GRWTH Text


DVD_YIELD Text


DVD_PAY Text


INTEREST Text


PFT_GWTH Text


ROE Text


ROA Text


EPS Text


PE_RATIO Text


PRICE_BOOK Text


TOTAL_LD Text


TOTAL_PL Text


TIER_1 Text


Bank Income Statement


Field Name Data Type


B_INCOME_STMT_ID AutoNumber


CMP_ID Number


YEAR Text


IE_LOANS Text


IE_BILLS Text


IE_PAID Text


NET_INT Text


FEES_COM Text


STCK_DIV Text


INVT_SLS_GNS Text


FGN_EXE_GNS Text


O_INCME Text


NET_O_INCME Text


ADMIN_GNRL_EXP Text


PROV Text


ACT_GNS Text


O_GNS Text


NT_PFT_TXS Text


TXS Text


NT_PFT_AFT_TXS Text


Phase Two


Designing the Pages


In this part I will insert an image of each page/screen that performs a certain task on the site, explaining it’s functionality and the script used to achieve this.


As explained earlier the site contains two sections, one that can be previewed by everyone, and the second part for the registered users.


Page Displayed For Everyone





notice that there is only one tab


Page Displayed For Registered Users





notice that there are two tabs


Online Services


Search


The Sector Search Page





Notes


This page will only be displayed for the registered users


Script Used


%@ Language=VBScript %


!-- #include file=logsession.asp --


html


head


titleSector Search/title


meta name=GENERATOR content=Microsoft FrontPage 4.0


meta name=ProgId content=FrontPage.Editor.Document


link rel=stylesheet type=text/css href=../_themes/glob/glob1001.css


meta name=Microsoft Theme content=glob 1001, default


meta name=Microsoft Border content=t, default


/head


bodytable border=0 cellpadding=0 cellspacing=0 width=100%trtd


p align=centerfont size=6strongimg src=_derived/sector_search.htm_cmp_glob000_bnr.gif border=0 alt=Sector Search/strong/font/p


form method=POST action=select_sector.asp


table border=0 width=546 height=48


tr


td width=06 height=4


hSector Search Criteria/h


/td


td width=6 height=4/td


/tr


tr


td width=06 height=16 Enter Sector


Name /td


td width=6 height=16input type=text name=NAME size=7 tabindex=1/td


/tr


/table


p align=centerinput type=submit value=Submit name=B1input type=reset value=Reset name=B/p


/form


p align=center /p


/td/tr/tabletable border=0 cellpadding=0 cellspacing=0 width=100%


tr


/tr/table


/body


/html


The Company Search Page





Script Used


%@ Language=VBScript %


!-- #include file=logsession.asp --


html


%


Dim Conn


Dim RS


Set Conn = Server.CreateObject(ADODB.Connection)


Conn.Open DSN=EBROKER


Set RS = Conn.Execute(SELECT SECTOR_ID AS ID, NAME FROM SECTOR)


%


head


titleCompany Search/title


meta name=GENERATOR content=Microsoft FrontPage 4.0


meta name=ProgId content=FrontPage.Editor.Document


link rel=stylesheet type=text/css href=../_themes/glob/glob1001.css


meta name=Microsoft Theme content=glob 1001, default


meta name=Microsoft Border content=t, default


/head


bodytable border=0 cellpadding=0 cellspacing=0 width=100%trtd


p align=centerfont size=6strongimg src=_derived/company_search.htm_cmp_glob000_bnr.gif width=501 height=76 border=0 alt=Company Search/strong/font/p


p align=center /p


/td/tr/tabletable border=0 cellpadding=0 cellspacing=0 width=100%trtd valign=top width=1%


p /p


p /p


p /p


/tdtd valign=top width=4/tdtd valign=top msnavigation


form method=POST action=select_company.asp


table border=0 width=100%


tr


td width=50%


hSelect Search Criteria/h


/td


td width=50%/td


/tr


tr


td width=50%Company Sector/td


td width=50%


select size=1 name=SECTOR_ID


option selected value=0Choose a sector/option


%


DO WHILE NOT RS.EOF


%


option value=%= RS(ID)%%= RS(NAME)%/option


%


RS.MOVENEXT


LOOP


%





/select


/td


/tr


tr


td width=50%Company Name/td


td width=50%input type=text name=CMP_NAME size=0/td


/tr


tr


td width=50%Stock Reuter Code/td


td width=50%input type=text name=STOCK size=0/td


/tr


/table


p align=centerinput type=submit value=Submit name=B1input type=reset value=Reset name=B/p


/form





/td/tr/table /body


/html


%


RS.Close()


Conn.Close()


%


The Stock Search Page





Script Used


%@ Language=VBScript %


!-- #include file=logsession.asp --


html


%


Dim Conn


Dim RS


Set Conn = Server.CreateObject(ADODB.Connection)


Conn.Open DSN=EBROKER


Set RS = Conn.Execute(SELECT SECTOR_ID AS ID, NAME FROM SECTOR)


%


head


titleStock Search/title


meta name=GENERATOR content=Microsoft FrontPage 4.0


meta name=ProgId content=FrontPage.Editor.Document


link rel=stylesheet type=text/css href=../_themes/glob/glob1001.css


meta name=Microsoft Theme content=glob 1001, default


meta name=Microsoft Border content=t, default


/head


bodytable border=0 cellpadding=0 cellspacing=0 width=100%trtd


p align=centerfont size=6strongimg src=_derived/stock_search.htm_cmp_glob000_bnr.gif width=501 height=76 border=0 alt=Stock Search/strong/font/p


p align=center /p


/td/tr/table


form method=POST action=select_result.asp


table border=0 width=100%


tr


td width=50%


hSelect Search Criteria/h


/td


td width=50%/td


/tr


tr


td width=50%Sector/td


td width=50%


select size=1 name=SECTOR_ID


option selected value=0Choose a sector/option


%


DO WHILE NOT RS.EOF


%


option value=%= RS(ID)%%= RS(NAME)%/option


%


RS.MOVENEXT


LOOP


%





/select


/td


/tr


tr


td width=50%Company Name/td


td width=50%input type=text name=CMP_NAME size=0/td


/tr


tr


td width=50%Stock Reuter Code/td


td width=50%input type=text name=STOCK size=0/td


/tr


/table


p align=centerinput type=submit value=Submit name=B1input type=reset value=Reset name=B/p


/form


/body


/html


%


RS.CLOSE


Conn.Close


%


Comparison


The Compare Company Page





Script Used


%@ Language=VBScript %


!-- #include file=logsession.asp --


html


%


Dim Conn


Dim RS


Set Conn = Server.CreateObject(ADODB.Connection)


Conn.Open DSN=EBROKER


Set RS = Conn.Execute(SELECT CMP_ID AS ID, CMP_NAME AS NAME FROM CMP_PROFILE)


%


SCRIPT Language=JavaScript


function doSub()


{


if (document.form1.CMP_A.value == 0)


{


alert(Please Choose Company A);


return;


}


else if (document.form1.CMP_B.value == 0)


{


alert(Please Choose Company B);


return;


}


else if (document.form1.CHOICE.value == 0)


{


alert(Please Choose A Criteria);


return;


}


else if (document.form1.YEAR.value == 0)


{


alert(Please Choose Year);


return;


}


else


{


document.form1.action = result.asp;


document.form1.submit();


}


}


/SCRIPT


head


titleCompare Companies/title


meta name=GENERATOR content=Microsoft FrontPage 4.0


meta name=ProgId content=FrontPage.Editor.Document


link rel=stylesheet type=text/css href=../_themes/glob/glob1001.css


meta name=Microsoft Theme content=glob 1001, default


meta name=Microsoft Border content=t, default


/head


bodytable border=0 cellpadding=0 cellspacing=0 width=100%trtd


p align=centerfont size=6strongimg src=_derived/compare_companies.htm_cmp_glob000_bnr.gif width=501 height=76 border=0 alt=Compare Companies/strong/font/p


p align=center /p


/td/tr/table


%


IF NOT RS.EOF AND NOT RS.BOF THEN


RS.MoveFirst


%


form method=POST name=form1


table border=0 width=100%


tr


td width=%/td


td width=8% align=center


h4uCompany A/u/h4


/td


td width=5% align=center


h4uCompany B/u/h4


/td


td width=5%/td


/tr


tr


td width=%/td


td width=8%select size=1 name=CMP_A tabindex=1


option selected value=0<Choose Company A>/option


%


DO WHILE NOT RS.EOF


%


option value=%= RS(ID)%%= RS(NAME)%/option


%


RS.MOVENEXT


LOOP


RS.MoveFirst


%





/select/td


td width=5%select size=1 name=CMP_B tabindex=


option selected value=0<Choose Company B>/option


%


DO WHILE NOT RS.EOF


%


option value=%= RS(ID)%%= RS(NAME)%/option


%


RS.MOVENEXT


LOOP


%


/select/td


td width=5%/td


/tr


tr


td width=%


h4Criteria/h4


/td


td width=5% colspan= align=leftselect size=1 name=CHOICE tabindex=


option selected value=0<Select Criteria>/option


option value=1Cash Flow Statement/option


option value=Stock Performance/option


option value=Financial Performance/option


option value=4Income Statement/option


option value=5Balance Sheet/option


/select/td


td width=5%/td


/tr


%


Set RS = Conn.Execute(SELECT DISTINCT YEAR FROM CSH_FLW_STAT)


%


tr


td width=%


h4Year /h4


/td


td width=5% align=left colspan=select size=1 name=YEAR tabindex=4


option selected value=0<Select Year>/option


%


IF NOT RS.EOF AND NOT RS.BOF THEN


DO WHILE NOT RS.EOF


%


option value=%= RS(YEAR)%%= RS(YEAR)%/option


%


RS.MOVENEXT


LOOP


End If


%


/select/td


td width=5%/td


/tr


tr


td width=%/td


td width=8%/td


td width=5%/td


td width=5%/td


/tr


tr


td width=%/td


td width=5% align=center colspan=input type=button


value=Compare Now! name=B tabindex=5 onClick=doSub();/td


td width=5%/td


/tr


/table


/form


%


End If


%


/body


/html


%


RS.CLOSE


Conn.Close


%


The Compare Stocks Page





Script Used


%@ Language=VBScript %


!-- #include file=logsession.asp --


html


head


titleCompare Stocks/title


meta name=GENERATOR content=Microsoft FrontPage 4.0


meta name=ProgId content=FrontPage.Editor.Document


link rel=stylesheet type=text/css href=../_themes/glob/glob1001.css


meta name=Microsoft Theme content=glob 1001, default


meta name=Microsoft Border content=t, default


/head


%


Dim Conn


Dim RS


Set Conn = Server.CreateObject(ADODB.Connection)


Conn.Open DSN=EBROKER


Set RS = Conn.Execute(SELECT CMP_ID AS ID, CMP_NAME AS NAME FROM CMP_PROFILE)


%


SCRIPT Language=JavaScript


function doSub()


{


var test = false;


if ((document.form1.STOCK_A.value == 0) || (document.form1.STOCK_B.value == 0))


{


test = false;


}


else


{


test = true;


}


if (test == false)


{


if ((document.form1.CMP_A.value == 0) || (document.form1.CMP_B.value == 0))


{


test = false;


}


else


{


test = true;


}


}


if (test == true)


{


document.form1.action = result1.asp;


document.form1.submit();


}


else


{


alert(Please choose at criteria);


}


}


/SCRIPT


bodytable border=0 cellpadding=0 cellspacing=0 width=100%trtd


p align=centerfont size=6strongimg src=_derived/compare_stocks.htm_cmp_glob000_bnr.gif width=501 height=76 border=0 alt=Compare Stocks/strong/font/p


p align=center /p


/td/tr/table


%


IF NOT RS.EOF AND NOT RS.BOF THEN


RS.MoveFirst


%


form method=POST name=form1


table border=0 width=100%


tr


td width=0%


h4Compare by /h4


/td


td width=8% align=center


h4uCompany A/u/h4


/td


td width=5% align=center


h4uCompany B/u/h4


/td


/tr


tr


td width=0%/td


td width=8%select size=1 name=CMP_A tabindex=1


option selected value=0<Choose Company A>/option


%


DO WHILE NOT RS.EOF


%


option value=%= RS(ID)%%= RS(NAME)%/option


%


RS.MOVENEXT


LOOP


RS.MoveFirst


%





/select/td


td width=5%select size=1 name=CMP_B tabindex=


option selected value=0<Choose Company B>/option


%


DO WHILE NOT RS.EOF


%


option value=%= RS(ID)%%= RS(NAME)%/option


%


RS.MOVENEXT


LOOP


%


/select/td


/tr


%


Set RS = Conn.Execute(SELECT STCK_ID AS ID, REUTER AS NAME FROM STOCK)


IF NOT RS.EOF AND NOT RS.BOF THEN


RS.MoveFirst


%


tr


td width=0%


/td


td width=5% colspan= align=left /td


/tr


tr


td width=0%


h4/h4


/td


td width=5% colspan= align=left/td


/tr


tr


td width=0%


h4OR Reuter Code/h4


/td


td width=7% align=center


h4uStock A/u/h4


/td


td width=6% align=center


h4uStock B/u/h4


/td


/tr





tr


td width=0%/td


td width=8%


select size=1 name=STOCK_A


option selected value=0<Choose Stock A>/option


%


DO WHILE NOT RS.EOF


%


option value=%= RS(ID)%%= RS(NAME)%/option


%


RS.MOVENEXT


LOOP


RS.MoveFirst


%


/select


/td


td width=5%select size=1 name=STOCK_B


option selected value=0<Choose Stock B>/option


%


DO WHILE NOT RS.EOF


%


option value=%= RS(ID)%%= RS(NAME)%/option


%


RS.MOVENEXT


LOOP


%


/select/td


/tr


%


End If


%


tr


td width=0%/td


td width=8% /td


td width=5%/td


/tr


tr


td width=0%/td


td width=8%/td


td width=5%/td


/tr


tr


td width=0%/td


td width=5% align=center colspan=input type=button


value=Compare Now! name=B tabindex=5 onClick=doSub();/td


/tr


/table


/form


%


End If


%


/body


/html


Points of considerations


Because the site has not been published, the WAP services will be displayed via the Nokia Tool Kit along with the coordinator.


At the time of the presentation we will elaborate all necessary information about this service.


Conclusion


To conclude this documentation we will summarize the points discussed in this documentation.


§ Introduction


§ Designing the Database


§ Designing the Pages





Please note that this sample paper on wanna swim is for your review only. In order to eliminate any of the plagiarism issues, it is highly recommended that you do not use it for you own writing purposes. In case you experience difficulties with writing a well structured and accurately composed paper on wanna swim, we are here to assist you. Your cheap custom research papers on wanna swim will be written from scratch, so you do not have to worry about its originality.

Order your authentic assignment from LivePaperHelp.com and you will be amazed at how easy it is to complete a quality custom paper within the shortest time possible!



No comments:

Post a Comment

Note: Only a member of this blog may post a comment.