1. Write a PL/SQL called DECLRE_STOCK which will be used when a companyh declares it is issuing shares. Sorry for no erd sort of hard to put up.

-Input parameters: compay_name, number of shares authoirzed, starting_price(in the designated currency), and currency name.

Check to ensure the company has not already been given a stock id.

if the company already has a stock id then do not perform any data changes otherwise the compny must be assigned a stock id (create sequence to generate new stock_ids) and the date of issue (current system date), number of shares authorized, the starting price and currency price id must be recorded.

2. Write a PL/SQL procedure called LIST_STOCK which will be used when tock is listed on a stock exchange.

Input parameters: stock_ex, stock_ex_id, stock_symbol.

The stock_id, stock_ex_id and stock symbol must be recoreded in the stock_listing table.

The starting price from comapny must be copies to the stock price list for the stock exchange. The current system time will be used for time_start and the time_end will be nul. The procedure must be able to convert currencies as needed.\

3. Write a PL/SQL procedure called SPLIT_STOCK.

input parameters: stock_id, split_factor

The split_factor must be greater than 1 and can be fractional. (The number of shares will be multiplied by the split_factor.)

The total shares outstanding cannot exceed the authorized amount. Your procedure should raise an application error if the split would cause the shares outstanding to exceed the shares authoirzed.

Every shareholder must receive( is buyer of) an additional "trade" equal to the additional shares to which they are entitled. For example, if the split_factor is 2 then each shareholder wil be entitled to an additional "trade" that is equal to the number of shares that they owned before the split. (Use the current_shareholder_shares view to determine the nuber of shares owned). These "trdes" will not take place at a stock exchange, the price total will be null, and there will be no brokers involved.

If you guys could help me with this please. I know this is hard with limited information and no erd but if you guys could give something close to the answer where i can just use erd in place.