'Database Project with PHP, JavaScript, XML

This project contains about 9 pages that need to be implemented to display stock market information after collecting and storing data into BDStock database.

Some of tables? already exist in database? and receiving data from remote web sites. More tables are needed to complete this project, but make sure that they all follow data integrity and relational database model.

?

Most of current pages are programmed by PHP, Flash, and Java Script. You can use? either programming languages or scripts, please discuss with me the benefit of using other languages. These pages are dynamic content updated by itself running scripts time to time.

Make sure, index graphs are dynamic during trading hour, it should update graphs as trading starts until market closes.

## Deliverables

Data will be stored in daily basis to BDstock Database. There are 9 pages need works to display the content.

1.? ? Intraday data: (<[url removed, login to view]> )

Investor can choose group of stocks or all stocks to watch real time trading. Time will be displayed as soon as it updates.

1.? ? ID 2. Stock Symbol? 3 Last Trading Price? 4. DayHigh? 5. DayLow? 6. Today’s closing price? 7. Yesterday closing price? 8.? Change? 9. % change? 10. # of Trades? 11. Volume? 12. Value

<[url removed, login to view]>

? <[url removed, login to view]>

**? 2.****? ? ? ? ? ? ? ? ? ? ** **52 Week price: (****<[url removed, login to view]>****)**

Following information need to be displayed on this page:

Second section: it will display Today’s price? ( 15.28 +[url removed, login to view] +0.07% ),? Open, Day High, Day Low, Volume, 52 Week High, 52 Week Low, Market capital, P/E, Shares Outstanding.

Third section: it will display last 10 years of dividends yields and earnings in the table like below.? Please check attached file.

? ? **3.? ? ? ? ? Personal Portfolio Table: [url removed, login to view]**

Net worth will determine portfolio gains or losses. One can have multiple portfolio but one portfolio ID. Net worth button will calculate and add multiple portfolios gain or loss status. To modify portfolio there need to be options implemented such as Add, Edit, Remove, Net worth, Number of Portfolio.? Maybe, a graph displays based on gains and losses.

If no account is setup then direct to account page.

Creating A Portfolio: Portfolio Table1:

Entity: 1. Portfolio ID (PK)? 2. Account Number ? (PK)? 3. Date? 4. Name of Investor

Portfolio Table 2:

1. Portfolio ID 2. Portfolio Name 3. Stock Symbol? 4. Total Shares 5. Purchase Price . 6. Date of Purchase 7. Brokerage Fee? 8. Delete

?

If portfolio exists that will display as investors login to to this site.

Portfolio Value: this would be adding total values of portfolios with current market price.

Entity:? 1. Portfolio Name? (PK ) 1. ? Stock Symbol? 2. Quantity? 3. Cost/share? 4. Fee? 5. Last Price? ? 6. Change? 7. % Change? 8. Total Cost? 9. Market Value 10. Gain/Loss? 11. % Gain/Loss

?

Net Worth: (total number of portfolios value )

?

Multiple Portfolios Value:

Entity: 1. Purchase Value? ? 2. Market Value? 3. Profit/Loss? 4. % Percent Profit/Loss? 5. Graph with gain and loss combination

4.? ? ? ? ? Buy/Sell Recommendation Table (upgrade/downgrade) : [url removed, login to view]

?

Specific investors or institution will recommend stocks either buy or sell or hold. Inserting Recommendation:

From drop down option select Upgrade or Downgrade with 3 or 6 or 12 months of period.

Login to Account first, otherwise direct to Account page and create profile information:

?

Table Structure:

Table? Entity:? 1. Profile ID ( PK) 2. Account Number 3. Name of Analyst or Institution? 4. Profile Description? 5. Company's Name 6. Symbol? ? 6. Start Date? 7. Start Price? ? 8. Upgrade From? 9. Upgrade To? 10. Target Price? 11. Time Frame ( 3, 6, 9, 12 Month )? 12. Analyst? Ranking

?

Upgrade Button/Downgrade Button:

?

Upgrade from ( Neutral, Hold, Market Perform, Sell, Under Weight,? Strong Buy, Strong Sell, Under perform, Overweight, Out Perform, Buy )

?

Upgrade To (Neutral, Hold, Market Perform, Sell, Under Weight,? Strong Buy, Strong Sell, Under perform, Overweight, Out Perform, Buy, Strong Sell )

?

5.? ? ? ? ? Creating Account: [url removed, login to view]

?

To process account setup, system will automatically send user name and password with account number and term of service to register’s email address for verifying email address. Once they receive email and a page link they need to sign back on to validate the account status. Until the account has been validated account won’t be ready to use.

?

Table Entity:? Step1:

1.? ? ? ? ? ? Account Number (PK)? 2. Name (PK)? a.? Last Name? ? b. First Name? 3. Date of Birth (PK)? 5. Email Address? 6.? Password? ? 7. Confirmed Password? ? 8. Home Address? ? ? 9.? City? 10. Country? 11. Zip Code? ? ?

Step 2: 12. Gender? ( Male/Female )? 13.? Membership For ( None, Newsletter, Personal Portfolio, Online Trading,? Blogs, Buy-Sell-Recommend ) 14. Annual Income? in Taka? ? 15. Investment Experience (1,3, 5 years)? 16.? Total Transaction in Last Year in Taka?

? 2. Account Table 2.

? ? ? ? ? ? ? ? ? ? ? 1. Account Number 2. Current Account Access for? 3. Add More

?

6.? ? ? ? ? ? ? IPO performance:

? Table will be provided, but make sure this page updates data from database. [url removed, login to view]

Entity: 1. Stock symbol (PK) ? 2. Company’s name ? 3. App open date? ? 4. App close date ? 5. Face Value 6. Offer w Bonus? ? 6. 1st Day close price in 2nd market? ? ? ? 8. Current price? ? 9. ? % return of profit? ? 10. Business sector 11. Underwriter

Investors can select year from drop down that will bring list of IPOs performance overview

| **Overview of past IPOs Performance, ? 2008** |

? They should be able to select different year from this drop down.

| **

** **Comp Name** | | **IPO Open-Close Date** | | **Business sector** | | **Underwriter** | | **Face Value** | | **Offer/w Bonus Price** | | **1stDay Close Price** | | **Today's Price** | | **% Gains or Loss** |

**? **

**7.? ? ? ? ? ? ? Current? IPOs list:** [**[url removed, login to view]**][1]

This will keep track all new IPOs are coming in primary market as IPOs and their application opening, closing date of applying for IPOs with prospectus information. Most likely it needs a table. ? Data can be feed from <[url removed, login to view]>

and <[url removed, login to view]>

IPO performance page will have three sections:

1. IPOs Lottery Result box

2. List of IPOs draft Prospectus are submitted to be approved by SEC

3. List of current IPOs are approved by SEC and

Get Data: <[url removed, login to view]>

Get data from <[url removed, login to view]>?

?

8. Main default page: [[url removed, login to view]][2]

The content currently exists on this page need to be updated automatically from BDStock Database especially most active, DSE index graphs.

Engineering Java JavaScript MySQL Oracle PHP Project Management Software Architecture Software Testing Web Hosting Website Management Website Testing XML XSLT

Project ID: #3798384

About the project