Scribd Logo
Upload

Welcome to Scribd!

  • 28 views

    Lesson 3

    Uploaded by

    Kemal Kacapor
    This lesson shows how to build preliminary repository entries in Visible Analyst software. It involves creating an entity relationship diagram with 3 entities - Jobs, Clients, and Job Status. Descriptions and lists of attributes are then added to the repository for each entity.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Lesson 3

    Uploaded by

    Kemal Kacapor
    28 views6 pages
    This lesson shows how to build preliminary repository entries in Visible Analyst software. It involves creating an entity relationship diagram with 3 entities - Jobs, Clients, and Job Status. Descriptions and lists of attributes are then added to the repository for each entity.

    Original Title

    lesson 3

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This lesson shows how to build preliminary repository entries in Visible Analyst software. It involves creating an entity relationship diagram with 3 entities - Jobs, Clients, and Job Status. Descriptions and lists of attributes are then added to the repository for each entity.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    28 views6 pages

    Lesson 3

    Uploaded by

    Kemal Kacapor
    This lesson shows how to build preliminary repository entries in Visible Analyst software. It involves creating an entity relationship diagram with 3 entities - Jobs, Clients, and Job Status. Descriptions and lists of attributes are then added to the repository for each entity.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 6

    Lesson 3: Building Repository Entries in Visible® Analyst

    This lesson accompanies Chapter 4

    As sometimes happens in the systems analysis phase, you have just discovered some information about
    the Glassmaster Job Status system that you are not quite ready to use. However, you want to get this
    information recorded in the Visible® Analyst repository so it will be available when you need it. In this
    lesson, we assume that you conducted several interviews with Glassmaster employees, and you have
    developed lists of some data elements that you think will be needed in the new system. Therefore,
    although we have not quite reached the data modeling chapter of our textbook (chapter 6), we will go
    ahead and record the facts we have learned about the system’s repository now.

    We cannot enter the facts about the data elements directly in Visible® Analyst. The software requires
    that we create a diagram with objects on it and then add information about the objects. So, we will
    create a preliminary entity relationship diagram, add three entities that represent the main objects we
    have discovered that we keep will track of, and then add the lists of data elements. We will postpone
    dealing with other more formal aspects of data modeling to Lessons 5 and 7.

    Lesson 3 Tasks:

    Task 1: Create a preliminary entity relationship diagram.

    Open the GLASSMASTERS project. Close the Zachman Framework window if necessary.

    Select New Diagram from the File menu. Choose Entity Relationship from the list of diagram types.
    Accept the default settings and click OK.

    Using the Entity symbol from the toolbar, add three entities to the diagram.

    Name the entities Jobs, Clients, and Job Status.


    Save the new diagram as Job Status ERD.

    Task 2: Describe each data entity in the repository.

    Now we will add the repository entries for each data entity in the diagram.

    Select the Jobs entity, then select Repository from the main menu, then select Define. Type in the
    following in the Description box: “This contains data about each job that has been created to fulfill a
    client’s commission.”

    Click on the symbol to bring up a form that will allow you to enter each attribute as follows.
    Enter each attribute name under the Global Name/Type column as shown here.

    Job ID
    Job Description
    Date Contract Signed
    Date Promised
    Actual Start Date
    Actual Finish Date
    Job Price
    When you have entered all seven attributes, click OK to return to the Define Item screen. We will not
    define the Type, Length, and Null characteristics of each attribute now; this information will be added to
    the repository in a future lesson.

    Your completed repository entry should look like this:


    Save your work and exit from the Define Item dialog box.

    Repeat this process for the Clients entity and the Job Status entity. The entity description and attributes
    you should include for each of these entities is listed here:

    Client Entity Job Status Entity


    Description: This entity contains Description: This entity contains facts
    facts about the client who that describe the job’s status through
    commissioned the job. the production process.
    Client ID Job Status ID
    Company Name Final Design Status
    Contact Name Final Design Pct Complete
    Address Fabrication Status
    City Fabrication Pct Complete
    State Finishing Status
    Zipcode Finishing Pct Complete
    Contact Phone Date/time Last Update
    Contact Email Initials Last Update
    When you are finished, you should see a list of attributes associated with each entity in the Define Item
    dialog box that looks like these examples. Note that not all attributes can be viewed in the dialog box at
    one time.
    Once you have created and save these entries, you have completed Lesson 3.

    Roberta M. Roth
    © 2019 John Wiley & Sons. All Rights Reserved

    You might also like