Operations : ABC Investments is an authorized share, stock and finance broker firm in Ahmedabad. It has been in business for over a decade. The firm buys or sells scrips for its clients. The organization has two managers, three accountants, one computer operator, five floor operators in the stock market and two clerks. The firm has six authorized sub- brokers. These sub-brokers may in turn have their own unauthorized sub-brokers. There are around 100 to 200 authorized or main brokers and over thousand sub-brokers in Ahmedabad The firm has a Pentium-II with a Inkjet printer. It uses a software package from Mastek costing around Rs.50.000 which is designed specifically for Stock Market Operations. Any client who wishes to do spot trading with the firm (wherein delivery of certificate and payment of cash is in most cases carried out at the end of the day) may specify the transaction he wishes the firm to undertake or the fimm may advise him on a profitable transaction. The client contacts the firm personally or by telephone at the start of the day and places his orders specifying the scrip and quantity and whether he wishes to buy or sell. The firm records these in the order book manually. A record of the stock it already holds is also maintained. This stock is the leftover from earlier transactions. After deducting this quantity from the orders, the sub-brokers and the floor operators of the firm are given the remaining amount for which they should transact in the Stock Market during the day. At the end of the day the sub-brokers consolidate the transactions carried out in the stock exchange and the current rates for all scrips are updated. The firm issues a CONTRACT FORM for the customers whose orders could be carried out that day. For every order a separate contract form is issued. The CONTRACT FORM specifies the Notes: 1. Material prepared from a class room discussion note. 2. The sub-brokers are just like other customers to the firm. They too get CONTRACT FORMS for the scrips they deal in and receive billing reports and settle with the firm every 15 days. type of transaction i.e. buy or sell, quantity, rate, name of the customer and name of the scrip (Exhibit - 1). If the quantity is less than the ordered, the customer is asked over telephone at the end of the day whether he wishes the remaining order to be placed for the next day. These CONTRACT FORMS are then mailed to the client. The firm handles on an average 40 to 50 CONTRACT FORMS daily. On receipt of the CONTRACT FORM the client sends an ACKNOWL- EDGMENT SLIP to the firm confirming his receipt of the CONTRACT FORM. This form is the legal evidence of the deal in case of any dispute thereafter. The firm generates a separate billing report for each customer every fifteen days. Exhibit-II shows a sample report. In this report both the sell and buy transactions during last 15 days for each scrip are mentioned specifying the date, quantity and rate of each of the transaction and the cash difference between the total amount of buy and sell. The difference is then settled between the client and the firm. The firm also generates a general scripwise report of all transactions it carried out during the last 15 days. Exhibit- II shows a sample report. Data Processing : In the following an analysis and steps required to computerize the operations at ABC Investments are presented. S.No. Operation Input Data 1. Customer places orders for Customer name Order file buy/sell Scrip name Quantity Date 2. Transactions in market File 3. Contract File Contract forms on basis of Customer name transactions Scrip name Quantity Rate Date Database files and the fields are as follows: Input files: 1. Cust 1. 2. 3. 4. Customer name Customer code Address Telephone number 2. Stock 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Scrip name Scrip code Opening Closing Prevclose Highrate Lowrate Todayrate Buyqty Sellqty 3. Order 1. 2. 3. 4. 5. 6. 7. 8. Order No Customer code Scrip code Buyqty Sellqty Buyalloc Sellalloc Date 4. Buysell 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Scrip code Opening Closing Prevclose Highrate Lowrate Todayrate Buyqty Sellqty Date Output files : 1. Currcont 1. 2. 3. 4. 5. 6. 7. Order No Customer code Scrip code Buyqty Sellqty Rate Date 2. Contfile 1. 2. 3. 4. 5. 6. Customer code Scrip code Buyqty Sellqty Rate Date 3. Genfile 1. 2. 3. 4. 5. Scrip code Buyqty Sellqty Rate Date Following is the detailed description of each report: 1. Contract Form: Frequency of generation Daily Fields Customer name and address, Scrip name. Buyquantity, Sellquantity, Rate and Date Generated from Currcont Cust Stock 2. Billing Report Frequency of generation Fortnightly Fields Customer name, Scrip name, Buyquantity, Sellquantity, Rate, Amount, and Date of each transaction, Buy Amount and Sell Amount, Difference of two Amounts Generated from Currcont Cust Stock 3. General Report: Frequency of generation Fortnightly Fields Scripname. Buyquantity, Sellquantity, Rate. Amount and Date Generated from Genfile Name : Scrip Name Exhibit-I: Contract Form Date : Bought/Sold Quantity Rate Exhibit - II : Billing Report Name : Bought Quantity Amount Scrip Rate Date Sold Quantity Amount Total Buy Amount Total Sell Amount Difference to be settled Exhibit - III: General Report BuyQty SellQty Date Scrip Rate Amount File Design: The files used in the system can be classified as: Master files CUST and STOCK Transaction files ORDER and BUYSELL Intermediate file ORDTOT Output files CURRCONT, CONTFILE and GENFILE Report format files CONT, BILL and SCRIP File Description : Master Files : Master files are created and maintained to hold almost permanent data. 1. CUST This file contains information of all customers. Field 1. 2. 3. 4. Field Name CUSTNAME CUSTCODE CUSTADD CUSTPHONE Type Character Character Character Character Width 25 4 30 10 2. STOCK This file contains the information of all the scrips. Field 1. 2. 3. 4. 5. 6. 7 8. 9. 10 Field Name SCRIPNAME SCRIPCODE OPENING CLOSING PREVCLOSE HIGHRATE LOWRATE TODAYRATE BUYQTY SELLQTY Type Character Character Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Width 15 4 10 10 10 10 10 10 10 10 Transaction files: These files contain transaction data. 1. ORDER This file contains current day's orders. Width 10 4 Field Field Name 1. ORDNO 2. CUSTCODE 3. SCRIPCODE 4. BUYORD 5. SELLORD 6. BUYALLOC SELLALLOC 8. DATE Type Numeric Character Character Numeric Numeric Numeric Numeric Date 4 10 10 8 8 8 2. BUYSELL : This file contains today's buy and sell details. Field 1. 2. 3. 4. 5. 6. 7. Field Name SCRIPCODE OPENING CLOSING PREVCLOSE HIGHRATE LOWRATE TODAYRATE BUYQTY SELLQTY DATE Type Character Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Date Width 4 10 10 10 10 10 10 10 10 8 9 10. Intermediate file : This file is used to hold intermediate data before generating the output files. This file is used to hold the scripwise quantity to be bought and sold for current day. 1.ORDTOT: Field 1. 2. 3. Field Name SCRIPCODE BUYQTY SELLQTY Type Character Numeric Numeric Width 4 10 10 Output files: These files hold data before generating reports. 1.CURRCONT: This file is used to hold all current day's buy and sell orders for all customers. Field 1. 2. 3. 4. 5. 6. 7. Field Name ORDNO CUSTCODE SCRIPCODE BUYQTY SELLQTY RATE DATE Type Numeric Character Character Numeric Numeric Numeric Date Width 10 4 4 10 10 10 8 2.CONTFILE: This file contains each buy and sell details for all customers for period of 15 days. Field 1. 2. 3 4. 5. 6. Field Name CUSTCODE SCRIPCODE BUYQTY SELLQTY RATE DATE Type Character Character Numeric Numeric Numeric Date Width 4 4 10 10 10 8 3.GENFILE: This file contains scripwise buy sell over the period of 15 days. Field Field Name 1 SCRIPCODE 2. BUYQTY 3 SELLQTY 4. RATE 5. DATE Type Character Numeric Numeric Numeric Date Width 4 10 10 10 8 Report format files : Report format files CONT, BILL and SCRIP are created to hold report formats in generating the contract forms, billing report and scripwise general report respectively. You are required to develop : a systems flow chart for the exercise the file structures, data records and the program command files in any language. Operations : ABC Investments is an authorized share, stock and finance broker firm in Ahmedabad. It has been in business for over a decade. The firm buys or sells scrips for its clients. The organization has two managers, three accountants, one computer operator, five floor operators in the stock market and two clerks. The firm has six authorized sub- brokers. These sub-brokers may in turn have their own unauthorized sub-brokers. There are around 100 to 200 authorized or main brokers and over thousand sub-brokers in Ahmedabad The firm has a Pentium-II with a Inkjet printer. It uses a software package from Mastek costing around Rs.50.000 which is designed specifically for Stock Market Operations. Any client who wishes to do spot trading with the firm (wherein delivery of certificate and payment of cash is in most cases carried out at the end of the day) may specify the transaction he wishes the firm to undertake or the fimm may advise him on a profitable transaction. The client contacts the firm personally or by telephone at the start of the day and places his orders specifying the scrip and quantity and whether he wishes to buy or sell. The firm records these in the order book manually. A record of the stock it already holds is also maintained. This stock is the leftover from earlier transactions. After deducting this quantity from the orders, the sub-brokers and the floor operators of the firm are given the remaining amount for which they should transact in the Stock Market during the day. At the end of the day the sub-brokers consolidate the transactions carried out in the stock exchange and the current rates for all scrips are updated. The firm issues a CONTRACT FORM for the customers whose orders could be carried out that day. For every order a separate contract form is issued. The CONTRACT FORM specifies the Notes: 1. Material prepared from a class room discussion note. 2. The sub-brokers are just like other customers to the firm. They too get CONTRACT FORMS for the scrips they deal in and receive billing reports and settle with the firm every 15 days. type of transaction i.e. buy or sell, quantity, rate, name of the customer and name of the scrip (Exhibit - 1). If the quantity is less than the ordered, the customer is asked over telephone at the end of the day whether he wishes the remaining order to be placed for the next day. These CONTRACT FORMS are then mailed to the client. The firm handles on an average 40 to 50 CONTRACT FORMS daily. On receipt of the CONTRACT FORM the client sends an ACKNOWL- EDGMENT SLIP to the firm confirming his receipt of the CONTRACT FORM. This form is the legal evidence of the deal in case of any dispute thereafter. The firm generates a separate billing report for each customer every fifteen days. Exhibit-II shows a sample report. In this report both the sell and buy transactions during last 15 days for each scrip are mentioned specifying the date, quantity and rate of each of the transaction and the cash difference between the total amount of buy and sell. The difference is then settled between the client and the firm. The firm also generates a general scripwise report of all transactions it carried out during the last 15 days. Exhibit- II shows a sample report. Data Processing : In the following an analysis and steps required to computerize the operations at ABC Investments are presented. S.No. Operation Input Data 1. Customer places orders for Customer name Order file buy/sell Scrip name Quantity Date 2. Transactions in market File 3. Contract File Contract forms on basis of Customer name transactions Scrip name Quantity Rate Date Database files and the fields are as follows: Input files: 1. Cust 1. 2. 3. 4. Customer name Customer code Address Telephone number 2. Stock 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Scrip name Scrip code Opening Closing Prevclose Highrate Lowrate Todayrate Buyqty Sellqty 3. Order 1. 2. 3. 4. 5. 6. 7. 8. Order No Customer code Scrip code Buyqty Sellqty Buyalloc Sellalloc Date 4. Buysell 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. Scrip code Opening Closing Prevclose Highrate Lowrate Todayrate Buyqty Sellqty Date Output files : 1. Currcont 1. 2. 3. 4. 5. 6. 7. Order No Customer code Scrip code Buyqty Sellqty Rate Date 2. Contfile 1. 2. 3. 4. 5. 6. Customer code Scrip code Buyqty Sellqty Rate Date 3. Genfile 1. 2. 3. 4. 5. Scrip code Buyqty Sellqty Rate Date Following is the detailed description of each report: 1. Contract Form: Frequency of generation Daily Fields Customer name and address, Scrip name. Buyquantity, Sellquantity, Rate and Date Generated from Currcont Cust Stock 2. Billing Report Frequency of generation Fortnightly Fields Customer name, Scrip name, Buyquantity, Sellquantity, Rate, Amount, and Date of each transaction, Buy Amount and Sell Amount, Difference of two Amounts Generated from Currcont Cust Stock 3. General Report: Frequency of generation Fortnightly Fields Scripname. Buyquantity, Sellquantity, Rate. Amount and Date Generated from Genfile Name : Scrip Name Exhibit-I: Contract Form Date : Bought/Sold Quantity Rate Exhibit - II : Billing Report Name : Bought Quantity Amount Scrip Rate Date Sold Quantity Amount Total Buy Amount Total Sell Amount Difference to be settled Exhibit - III: General Report BuyQty SellQty Date Scrip Rate Amount File Design: The files used in the system can be classified as: Master files CUST and STOCK Transaction files ORDER and BUYSELL Intermediate file ORDTOT Output files CURRCONT, CONTFILE and GENFILE Report format files CONT, BILL and SCRIP File Description : Master Files : Master files are created and maintained to hold almost permanent data. 1. CUST This file contains information of all customers. Field 1. 2. 3. 4. Field Name CUSTNAME CUSTCODE CUSTADD CUSTPHONE Type Character Character Character Character Width 25 4 30 10 2. STOCK This file contains the information of all the scrips. Field 1. 2. 3. 4. 5. 6. 7 8. 9. 10 Field Name SCRIPNAME SCRIPCODE OPENING CLOSING PREVCLOSE HIGHRATE LOWRATE TODAYRATE BUYQTY SELLQTY Type Character Character Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Width 15 4 10 10 10 10 10 10 10 10 Transaction files: These files contain transaction data. 1. ORDER This file contains current day's orders. Width 10 4 Field Field Name 1. ORDNO 2. CUSTCODE 3. SCRIPCODE 4. BUYORD 5. SELLORD 6. BUYALLOC SELLALLOC 8. DATE Type Numeric Character Character Numeric Numeric Numeric Numeric Date 4 10 10 8 8 8 2. BUYSELL : This file contains today's buy and sell details. Field 1. 2. 3. 4. 5. 6. 7. Field Name SCRIPCODE OPENING CLOSING PREVCLOSE HIGHRATE LOWRATE TODAYRATE BUYQTY SELLQTY DATE Type Character Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Date Width 4 10 10 10 10 10 10 10 10 8 9 10. Intermediate file : This file is used to hold intermediate data before generating the output files. This file is used to hold the scripwise quantity to be bought and sold for current day. 1.ORDTOT: Field 1. 2. 3. Field Name SCRIPCODE BUYQTY SELLQTY Type Character Numeric Numeric Width 4 10 10 Output files: These files hold data before generating reports. 1.CURRCONT: This file is used to hold all current day's buy and sell orders for all customers. Field 1. 2. 3. 4. 5. 6. 7. Field Name ORDNO CUSTCODE SCRIPCODE BUYQTY SELLQTY RATE DATE Type Numeric Character Character Numeric Numeric Numeric Date Width 10 4 4 10 10 10 8 2.CONTFILE: This file contains each buy and sell details for all customers for period of 15 days. Field 1. 2. 3 4. 5. 6. Field Name CUSTCODE SCRIPCODE BUYQTY SELLQTY RATE DATE Type Character Character Numeric Numeric Numeric Date Width 4 4 10 10 10 8 3.GENFILE: This file contains scripwise buy sell over the period of 15 days. Field Field Name 1 SCRIPCODE 2. BUYQTY 3 SELLQTY 4. RATE 5. DATE Type Character Numeric Numeric Numeric Date Width 4 10 10 10 8 Report format files : Report format files CONT, BILL and SCRIP are created to hold report formats in generating the contract forms, billing report and scripwise general report respectively. You are required to develop : a systems flow chart for the exercise the file structures, data records and the program command files in any language