|
|
|
|
|
wanna swim
|
|
|
Presented by: Hebah Medhat Mohammed Shaaban Mona Sayed Index Topic Page Number Acknowledgment 3 Introduction 4-5 Tools Used To Build The Site 6 References 6 Database 7-16 Designing The Pages 17-32 Points Of Consideration 33 Conclusion 34 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) 2. Mr. Sameh Farouk (Project Supervisor) 3. 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 6210 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.
|
|
|
|
Still Can't Find What Your Looking For? Then Try a Essay Search!
|
