Mgt 4322 - Home   Spring 2010   Email to Dr. Lyons     PatLyons Home
[ Calendar10:10 | PortWebsite | StuWebs  | Port1 | 2 | 3 | 4 | 5 | 6 | Showcase | Presentation ]
[ Ch 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 || AppDatabase | Ex1 | 2 | 3 | 4 | 5 | 6 | 7 ]
[ HW 1| 2 | 3 | 4 | | Career1| 2 | 3 ] [ SJU | TCB | CareerCtr | StuInfo | CareerLinks ] [ SJU Closing ] [H1N1SelfAssessment]

  Database Exercise 1 - Establish Database Requirements

  1. First Draft of Systems Analysis for Prototype - use your Job Opportunity Summary from Career Exercise 2 to establish the information requirements for a prototype database for that Job Opportunity.

    1. To do this, right click this link and use the SaveTargetAs option to download my MS Word document, Db1SysAnalysis1.doc (32KB). Save this file on your H: drive here at SJU or on your hard drive at home.

    2. In Section I of Db1SysAnalysis1.doc, copy and paste from your Job Opportunity Summary of Career Exercise 2 sufficient information about your job opportunity in order to establish the information requirements for your prototype database.  Notice how I copied only one responsibility.  However, this is sufficient to specify the resulting database.

    3. In Section II, specify the desired reports.

      1. Full Transaction File Report - a report of all the contents of your Transaction File.  You just specify the data items (fields) to be included in the report and how it is sorted.

      2. Full Personnel File Report - a report of the five associates working for you sorted by associate ID.  It is appropriate to have just the first name, last name, and years of experience of each associate.
         

  2. Second Draft of Systems Analysis for Prototype - use your First Draft of Systems Analysis for Prototype to further clarify the information requirements for your prototype.

    1. To do this, right click this link and use the SaveTargetAs option to download my MS Word document, Db1SysAnalysis2.doc (36KB). Save this file on your H: drive here at SJU or on your hard drive at home.

    2. For Sections I, II.A, and B, incorporate any comments from the First Draft of Systems Analysis.

    3. For Section II.C, specify a meaningful exception criteria that would be helpful to you in your future job.  Have at least three different data items (fields).  Have exception criteria of the form:
                (Condition1 and Condition2) or
                (Condition3 and Condition4).

    4. For Section III,  specify the required files needed to create the above reports.

      1. Transaction file - this file contains the information about the transactions you are managing.
        The Client File given below is a partial listing of the status of the clients that the manager of 5 Intelligence Associates at Thomson may have.
        Your transaction file         record must have at least 8 fields.
        You specify only the data item names (not values).

        Client
        ID

        Client
        Company

        Assoc.
        ID

        Stock
        Activity

        Stock
        Volume

        News
        Stock

        Market
        Drivers

        Institution
        Activity

        Tech
        Analysis

        100

        Merrill Tie

        12

        -10.0%

        1,000,000

        Unfavorable

        Down

        Sell

        Negative

        101

        J.T. Morgan

        14

        -8.0%

        1,600,000

        Favorable

        Down

        Hold

        Positive

        102

        Lehman Sisters

        16

        -4.0%

        1,800,000

        Unfavorable

        Down

        Sell

        Negative

        103

        German Bank

        18

        3.0%

        500,000

        Neutral

        Down

        Buy

        Neutral

        104

        Deer Stearns

        20

        -7.0%

        300,000

        Unfavorable

        Down

        Sell

        Negative

        105

        Second Boston

        18

        -9.0%

        250,000

        Unfavorable

        Down

        Sell

        Negative

         

      2. Personnel file - this file contains information about the people who are conducting the transactions in the first file.  The Associate File given below contains the necessary information about the associates who are conducting analyses for the firms in the above Client File.
        Your personnel file record must have at least 4 fields.
        You specify only the data item names (not values).
        You may specify the first name, last name, and years of experience of each associate.

        Associate ID

        First Name

        Last Name

        Years Experience

        12

        Erica

        Boyce

        4.00

        14

        Jerry

        Kemp

        1.50

        16

        Joseph

        Baynes

        1.50

        18

        George

        Dyer

        3.20

        20

        Laura

        Ryan

        0.80

         

  3. Final Document of Systems Design for Prototype - use your Second Draft of Systems Analysis for Prototype to further clarify the information requirements for your prototype.

    1. To do this, right click this link and use the SaveTargetAs option to download my MS Word document, Db1SysDesign.doc (35KB). Save this file on your H: drive here at SJU or on your hard drive at home.

    2. For Sections I, II.A-C, and III.A-B, incorporate any comments from the Second Draft of Systems Analysis.

    3. For Section II.D, specify the Full Report of Transaction File joined with Personnel File - explained in Database Exercise 6.

    4. For Section II.E, specify the Exception Report of Transaction File joined with Personnel File - explained in Database Exercise 7.
       

  4. Requirements

    1. First Draft of Systems Analysis for Prototype - bring paper copy and copy on flash drive to demo to the class.  May be collected at the professor's discretion.

    2. Second Draft of Systems Analysis for Prototype - bring paper copy and copy on flash drive to demo to the class.  May be collected at the professor's discretion.

    3. Final Document of Systems Design for Prototype - bring paper copy and copy on flash drive to demo to the class.  May be collected at the professor's discretion.  The Final Document is completed with Database Exercise 7.

    4. For all the above, you will be graded on:

      1. The appropriateness of the reports to the responsibilities of the Job Opportunity of Career Exercise 2, and

      2. The consistency of the files with the information required to produce the reports.

                                  (This page was last edited on January 18, 2010 .)