Description of Sample Application and Outline of Steps in ERROS Application Creation

ERROS Application Creation Example

Video Shop

Defining the ERROS Database Extensions to the ERROS Business Model

The ERROS Business Model is stored in two parts - that provided as part of the ERROS Application Creation System and user additions to that base. These do not affect the ERROS base definitions.

The specification implies that two entity types are required -

1. Customers

2. Video tapes

An ERROS entity type, User personal and business name, which stores all existing contact names, both personal and business, already exists and can be usedfor customers, as either a person or a business could rent a tape. This existing definition can therefore be re-used.

Two of the required attributes for User personal and business name already are already defined -

name and/or number
telephone number, speech

The definitions of these attributes are appropriate for the new application and therefore can be re-used. Only video(s) currently rented needs defining as a new user defined attribute and then as an additional attribute of User personal and business name.

Video tape is a new entity type, not previously defined in ERROS, so this must be created, together with two attributes -

name and/or number
currently rented to

The attribute video(s) currently rented of the entity type User personal and business name is a relationship with the entity type Video Tape and this relationship can be expressed in the following semantic network diagram -

where currently rented to is the inverse of video(s) currently rented.

These changes to the database definitions are stored in the ERROS database, in which, when the application creation process is complete, the user data for the application will also be stored. Since the database has a complete audit trail and is journalled, with commitment control in use, all the database definition changes are recorded in that audit trail. Traditional application creation methods involve programming and there is normally no audit trail for changes made to programs.

Creating the new Application

A new record called Video Shop is put in the entity type ERROS Application. This is then related to the entity types required -

User Personal and Business Name
Video tape

The entity type User Personal and Business Name has the attribute name and number put, as the identifying attribute, in its first level menu. This determines the identifiers that will be available to operators. The following attributes are defined in its second level menu, accessible only after a record has been retrieved.

video(s) currently rented
telephone number,speech.

The entity type Video tape has name and/or number put, as the identifying attribute, in its first level menu and currently rented to in its second level menu.

Initial menus are then created for the application. One new term, Videos, is put in the ERROS thesaurus and then used as a menu name. The other menu name chosen customers already exists in the thesaurus. The application is now nearly complete.

The fourth stage is to grant authority to use the application and then test it. Testing will only consist of putting in two or three records in each part of the database and visually checking the results. As no programs have been generated, no program testing is required. The test is simply to ensure that the database definition extensions were correct. If they are not, it should be very obvious during testing.

As a final stage, once the application has been tested and approved by the end user, some HELP information could be put in the already structured ERROS HELP database. This is an integral part of the overall ERROS database. (ROLL up for MORE)

No special back up procedures need to be created for the new application as no new database files or tables have been created.

Although this sample application is obviously very simplistic in the number of functions and types of data that it makes available, in many other respects, it is very sophisticated and has powerful features such as browsing that allow an operator to browse through his database. Thus he can look up a telephone number, then find who is (or are) at that telephone number and then find out what tapes if any the person is currently renting. Equally the operator could look up a particular tape (by name or number) and then immediately find out who was renting that tape, and then their telephone number and also what other tapes they were renting. The specification did not mention that there could be multiple copies of each tape. Yet the application can handle the same title being rented to more than one customer at a time and the customers renting more than one tape at a time as ERROS allows "many to many" relationships by default.

No decision needs to be made in the system design process about the maximum number of tapes that can be rented by any customer at any time as ERROS, by default, allows repeating attributes. You can restrict the number later if the user requests this.

The specification made no mention of the need to know the date on which a tape was rented. Although this is a feature that needs to be added, the information can be found by pressing/clicking just one function key after selecting the particular tape and customer combination as the audit trail automatically shows when the information was added to the database, and, providing this was done at the time the customer rented the tape, the date (and time) on which the tape was rented will be the date and time the information was entered.

No mention was made in the specification of file sizes. There was no need for the application creator to ask that question as the new application will allow the entry of 1 billion customers and 1 billion tapes (the practical limitation will be disk space) and, in theory at least, each customer could rent a copy of each of the 1 billion tapes!

Thus the application can be used and meets the specification. It may only provide the most basic needs for an information system, but it has very high reliability and rapid performance (normally sub second response times even on the slowest AS/400 model, the B10). It has only taken a very few minutes to create. When the user starts to operate the application, he will soon learn at least some of its limitations and then he can make requests for enhancements. Most or all of those enhancements can be made whilst the application is being used. It will be such a short time since he made his original request that he should remember why he wanted particular features or perhaps why he did not request features that he now realises are important.

The specification should have mentioned the importance of the rental date, and that there will be multiple copies of most tapes, each with its own individual number. It should also have mentioned that the shop will also sell Video tapes outright and that rental stock must be handled in a different way from stock for sale. As applications created using ERROS are open ended, these points can now be corrected.

All the screens that you need to see and change when using the ERROS Business Modeller to define the ERROS Database Extensions are shown in this document. They are all real screens dumps in HTML, taken when operating the Business Modeller using the AS/400 Workstation Gateway. The only changes to them were to remove the IP address of the server used. Two (?) screens that were not saved originally were added later.

You will notice how ERROS continually changes the prompts it displays to assist operators and how the list of available function keys changes dynamically as you move from screen to screen and as your authority changes.

1 Defining the ERROS Database Extensions

The ERROS Business Modeller is used to define the database extensions required for the application.

The main steps are -

1.1 Starting the ERROS Business Modeller Application

1.2 Create the new User Entity Type A(Video Tape). Before creating a new user entity type, you should always check that an appropriate ERROS defined entity type does not already exist. However, Video tape is not an ERROS entity type and thus must be created as a user entity type.

1.3 Relate the new Entity Type A(Video Tape to its Identifying Attribute. The user has not specified what this is, but it seems reasonable to assume that this would be Name and/or number.

1.4 Create New Attribute of Entity type A(currently rented to) for the new entity type. Before creating a new user attribute, you should ensure that it does not already exist as an ERROS defined attribute. When you have completed this stage, you have defined the new attribute, but will not define the entity type of which it is an attribute until the next stage.

1.5. Relate the New Attribute currently rented to to the Entity Type A Video Tape so that it is now an attribute of that entity type.

1.6 Create the New User Attribute video(s) currently rented for the ERROS entity type User Personal and Business Name.

1.7 Relate the new attribute video(s) currently rented to to the ERROS entity type User Personal and Business Name.

1.8 Define the Relationship between the entity type User Personal and Business Name and the entity typeVideo Tape.

When completed these seven steps, you have completed all necessary changes to the business model.

In other words, you have defined all the extensions to the existing data definitions that are required for your application.

ERROS Application Creation Example

Video Shop

Defining the ERROS Database Extensions to the ERROS Business Model

The ERROS Business Model is stored in two parts - that provided as part of the ERROS Application Creation System and user additions to that base. These do not affect the ERROS base definitions.

The specification implies that two entity types are required -

1. Customers

2. Video tapes

Two of the required attributes for User personal and business name already are already defined -

name and/or number
telephone number, speech

Video tape is a new entity type, not previously defined in ERROS, so this must be created, together with two attributes -

name and/or number
currently rented to

where currently rented to is the inverse of video(s) currently rented.

Creating the new Application

A new record called Video Shop is put in the entity type ERROS Application. This is then related to the entity types required -

User Personal and Business Name
Video tape

video(s) currently rented
telephone number,speech.

The entity type Video tape has name and/or number put, as the identifying attribute, in its first level menu and currently rented to in its second level menu.

No special back up procedures need to be created for the new application as no new database files or tables have been created.

1 Defining the ERROS Database Extensions

The ERROS Business Modeller is used to define the database extensions required for the application.

The main steps are -

1.1 Starting the ERROS Business Modeller Application

1.3 Relate the new Entity Type A(Video Tape to its Identifying Attribute. The user has not specified what this is, but it seems reasonable to assume that this would be Name and/or number.

1.5. Relate the New Attribute currently rented to to the Entity Type A Video Tape so that it is now an attribute of that entity type.

1.6 Create the New User Attribute video(s) currently rented for the ERROS entity type User Personal and Business Name.

1.7 Relate the new attribute video(s) currently rented to to the ERROS entity type User Personal and Business Name.

1.8 Define the Relationship between the entity type User Personal and Business Name and the entity typeVideo Tape.

When completed these seven steps, you have completed all necessary changes to the business model.

In other words, you have defined all the extensions to the existing data definitions that are required for your application.

ERROS Application Creation Example

Video Shop

Using the ERROS Business Modeller to define the Database Definitions

If you are not signed on, then obtain your user Id. and Password from your AS/400 administrator, sign on, start the ERROS Business Modeller Application. If you are not authorised to the ERROS Business Modeller, you will need to get authority from your ERROS coordinator.
Follow the following steps.

1.1 Using the ERROS Business Modeller Application

1.1.1 The ERROS Business Modeller is used to define the database extensions required for the application.

When you have started the ERROS Business Modeller, ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               ERROS Business Modeller                                          
               initial menu
               
 CHOOSE    attribute name              
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 User defined repository                            
   2 User defined entity types and attributes           
   3 ERROS defined entity types and attributes          
F13=REPORT F15=Tasks F17=Personal F23=Messages                 22/07/98 08:38 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.1.2. This is the initial menu for the ERROS Business Modeller application. From the initial menu select user defined repository by typing the number to its left and pressing ENTER (you will see that ERROS prompts you - if you look at the line below the data input lines). The user defined repository, user defined terms, is where ALL user terms that define your data and applications are stored.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 REQUEST                               
 Type request (e.g. record name or other ID) and press ENTER (for FASTPATH, type . then * or ID and ENTER)
 
Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:38 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.2. Create the new User Entity Type Video Tape (Entity Type A)

Before creating a new user entity type, you should always check that an appropriate ERROS defined entity type does not already exist. However, Video tape is not an ERROS entity type and thus must be created as a user entity type. This can be done with the following steps -

1.2.1. Key, as a User defined term, in the name of the new User entity type

Video tape

from your ERROS Diagram and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 REQUEST                               
E00170 Not found - press F9 to add the above record 
(for FASTPATH, type . then * or ID and ENTER)
 
F9=CREATE Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:39 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

As ERROS has not heard of the term before, it displays a message to tell you that it has not found the record.

1.2.2. Press F9, as instructed, to add the term to the repository (if it had already existed, you would type the number to its left, press ENTER and got to step 4).

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 CREATE                                
                                                                               
              
                                                                22/07/98 08:39
 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.2.3. This shows that ERROS is about to CREATE the term (the word CREATE is displayed to the left of and below the main typing box). As prompted (in red at the bottom of the screen), press ENTER to confirm that you wish to create the term.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 Selected                              
 Record with unique ID. added. Press ENTER to add further details (for FASTPATH, type . then * or ID and ENTER)
 
   1 Video tape                                                       
F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:40 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS confirms that it has added the term Video tape to the repository of user defined terms. This must now be defined as a User entity type.

1.2.4. As prompted, press ENTER to add further details.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     Video tape
               is a
                                                                                
               Business modeller definition entity type                         
               name
               
 CHOOSE                                
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 User attribute                                     
   2 User entity type                                   
                                                               22/07/98 08:40 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

The only attribute in the menu for user defined term(s) in the ERROS Business Modeller is is a so ERROS automatically selects this, as there is no choice. Is a is defined as a relationship and only two terms are valid (the choice is defined in the ERROS Neural Database).

1.2.5. The term you are adding is a User entity type. Select that option by typing the number to its left (2), and press ENTER.

ERROS will display the following screen.


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate from   Business modeller definition entity type
               user defined term(s)
               name                                                             
               Video tape                                                       
               is a
      Our Data 
 CREATE                                
                                                                               
                                                           Screen   1 of   1
 Is this a Primary OR a Secondary entity type?  P/S
 NOTE: The type will be Secondary if the entities (records) to be put in the
       entity type already exist in another entity type.
       For secondary entity types, the identifying attribute must be specified
       as a relationship.
            
                                                                22/07/98 08:41
 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.2.6. Without changing the default value of "P", press ENTER, as prompted, to confirm that you wish to create Video tape as a new user entity type.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               user defined term(s)
               name                                                             
               Video tape                                                       
               is a
      Our Data 
 Selected                              
 Relationship created. Press ENTER to add further details. (for FASTPATH, type . then * or ID and ENTER)
 
   1 User entity type                                   
F18=NAVIGATE F9=CREATE F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:43 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

This shows that you have now created the new user entity type Video tape, although you have not yet defined the attributes for this. In ERROS, you can define attributes after you have created the entity type, and can add further attributes at any time, without having to shut down and re-organise the database, and without being concerned with the impact of the additional attributes on existing applications. With traditional databases, you cannot create a new file until you have defined all the fields. Adding new fields to existing traditional files is not so simple, and every traditional application that uses such files will have to be changed, even if the new field is not required in those applications.

1.3 Relate Entity Type A (Video tape) to its Identifying Attribute

1.3.1. The next step is to relate the user entity type just created to its attribute(s). The first attribute is the identifying attribute; in this case, name and/or number. This is already defined as an ERROS defined attribute, so you can re-use that definition (using the inbuilt object-oriented capabilities of the ERROS Neural Database).

Press ENTER to add further details, as prompted.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               User entity type
               Video tape
               is a                                                             
               User entity type
               
 CHOOSE                                
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 attribute(s) include                               
   2 attribute(s) with which directly related           
   3 related entity type data stored                    
   4 user application(s) in which used                  
F13=REPORT F15=Tasks F17=Personal F23=Messages                 22/07/98 08:43 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

As you have now defined Video tape as a User entity type, it automatically inherits the attributes defined for User entity types and displays those available in the ERROS Business Modeller application.

1.3.2 From the list of these displayed, select attribute(s) include by typing the number to its left and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     Video tape
               attribute(s) include
                                                                                
                                                                                
               
 CHOOSE    name or description         
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 Attribute¬(ERROS defined)                          
   2 User attribute¬(USER defined)                      
                                                               22/07/98 08:44 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS shows you at the top of the screen that you are about to relate the attribute you choose to the user entity type Video tape under its attribute attribute(s) include. You can select either an ERROS defined attribute or a User defined attribute. The first attribute to add is the identifying attribute. This was specified by the user as name and number. This is a very common way of identifying records and already exists as an ERROS defined attribute, whose definition you can re-use with the new user entity type that you have created.

1.3.3 Since you wish to re-use an existing ERROS defined attribute, select Attribute (ERROS defined) by typing the number to its left and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     Video tape
               attribute(s) include
                                                                                
               Attribute                                                        
               name and/or number
               
 CHOOSE                                
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
(Page Down for more)
   1 action                                             
   2 action/response                                    
   3 address                                            
   4 address of                                         
   5 address text                                       
Page_Down                                                      22/07/98 08:44 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

This displays, in alphabetic sequence, the first few ERROS defined attributes. These might already be attributes of several entity types, both ERROS defined and user defined, but that is of no concern here.

1.3.4 Type the word

name

and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     Video tape
               attribute(s) include
                                                                                
               Attribute                                                        
               name and/or number
               
 CHOOSE                                
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 name                                               
   2 name and/or number                                 
   3 name and/or number or date                         
   4 name and/or ten character identifier               
   5 name of person to be telephoned                    
   6 name of person who telephoned                      
   7 name(s) include                                    
Page_Down 22/07/98 08:45 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS displays a list of attributes beginning name .....

1.3.5 Select the one you require (name and/or number) by typing the number to its left and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate from   Attribute¬(ERROS defined)
               User entity type                                                 
               Video tape                                                       
               attribute(s) include
      Our Data 
 CREATE                                
                                                                               
 Relationship, Surrogate & Security definitions            Screen   1 of   1
 Is this attribute the PRIME identifier of the Entity Type?  (Y/N)
 NOTE: If this is the prime identifier of a secondary entity type, then this
       attribute must be defined here as a relationship.
 Will the attribute be used to store Relationships?          (Y/N)
    If Yes, Rel. definition             Definition version 
            Related record ID.  Related rec'd stored under 
     Recursive Relationships?  
    When relating, Clear attr.            Clear surr. data     Rel. surog. 
 DATA Identifiers -  Surrogate  (^/C/R)    by Entity type?  (^/Y)
 SECURITY                             List?  Y/N
            
 F10 for other parameters                                       22/07/98 08:45 
 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

ERROS is about to create the relationship - that is to define name and/or number as an attribute of the User entity type Video tape.

1.3.6 Accept the defaults for this relationship (including the "Y" that indicates that this is the "PRIME identifier of the Entity type" ) by pressing ENTER (as prompted in red).

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     Video tape
               attribute(s) include
                                                                                
               Attribute                                                        
               name and/or number
               
 CHOOSE                                
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 name and/or number or date                         
   2 name and/or ten character identifier               
   3 name of person to be telephoned                    
   4 name of person who telephoned                      
   5 name(s) include                                    
                                                               22/07/98 08:46 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS has returned you to the list of ERROS defined attributes in case you wish to re-use any more.

1.3.7 As you do not, in this example, wish to re-use any more, press F3 to return.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               User entity type                                                 
               Video tape                                                       
               attribute(s) include
      Our Data 
 Selected                              
 To accept, press ENTER; else type new ID & ENTER; or F9 to add (for FASTPATH, type . then * or ID and ENTER)
 
   1 name and/or number                                 
ENTER/OK F18=NAVIGATE F9=CREATE F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:46 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS shows that you have now defined the attribute name and/or number as the identifying attribute for the new user entity type that you have just created. As its name implies, this consists of two fields, and, since it is an identifying attribute, the records will be indexed and accessible by both name and number. Thus users will be able to display the Video tapes in name or number sequence without the need to sort the records, even though no AS/400 logical files are used in ERROS.

1.3.8 Press F3 to return to the user defined terms screen.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 REQUEST                               
E00036 No further records found 
(for FASTPATH, type . then * or ID and ENTER)
 
Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:46 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS has returned to the ERROS defined entity type user defined term(s) and looks for any further records with the identifier that you last typed in here (Video tape). As there are no more records (the one you created was the first), it issues a message to that effect.

1.4 Create New Attribute of Entity Type A

The next step is to create the new attribute currently rented to (NOTE: Before creating a new user attribute, you should ensure that it does not already exist as an ERROS defined attribute).

1.4.1 Type in the name from the top of your ERROS diagram as the attribute of user entity type A, in this example

currently rented to

and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 REQUEST                               
E00170 Not found - press F9 to add the above record 
(for FASTPATH, type . then * or ID and ENTER)
 
F9=CREATE Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:47 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.4.2. Press F9, as instructed, to add the new term to the User repository (if it had already existed, you would type the number to its left and press ENTER and go to step 1.4.4).

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 CREATE                                
                                                                               
              
                                                                22/07/98 08:47
 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.4.3 This shows that you are about to CREATE a new user defined term of currently rented to. Press ENTER to confirm (as prompted in red).

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 Selected                              
 Record with unique ID. added. Press ENTER to add further details (for FASTPATH, type . then * or ID and ENTER)
 
   1 currently rented to                                              
F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:48 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

This shows that ERROS has added the new user defined term currently rented to.

1.4.4 As instructed, press ENTER to add further details.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     currently rented to
               is a
                                                                                
               Business modeller definition entity type                         
               name
               
 CHOOSE                                
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 User attribute                                     
   2 User entity type                                   
                                                               22/07/98 08:48 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.4.5 As before, you have the choice of defining the new User defined term as a user attribute or as a User entity type.

This time, the term you are adding is a user attribute, so select that option (by typing the number to its left) and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 COPY   from   Business modeller definition entity type
               user defined term(s)
               name                                                             
               currently rented to                                              
               is a
      Our Data 
 CREATE                                
                                                                               
 Relationship, Surrogate & Security definitions            Screen   1 of   1
 Is this attribute the PRIME identifier of the Entity Type?  (Y/N)
 NOTE: If this is the prime identifier of a secondary entity type, then this
       attribute must be defined here as a relationship.
 Will the attribute be used to store Relationships?          (Y/N)
    If Yes, Rel. definition             Definition version 
            Related record ID.  Related rec'd stored under 
     Recursive Relationships?  
    When relating, Clear attr.            Clear surr. data     Rel. surog. 
 DATA Identifiers -  Surrogate  (^/C/R)    by Entity type?  (^/Y)
 SECURITY                             List?  Y/N
            
 F10 for other parameters                                       22/07/98 08:49 
 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

ERROS displays the first screen of default attributes for the attribute currently rented to.

1.4.6 In this instance you will need to change the value for DATA Identifiers - Surrogate (currently "C") to "R" by overtyping the current value, then press ENTER to make the change.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               user defined term(s)
               name                                                             
               currently rented to                                              
               is a
      Our Data 
 Selected                              
 Relationship created. Press ENTER to add further details. (for FASTPATH, type . then * or ID and ENTER)
 
   1 User attribute                                     
F18=NAVIGATE F9=CREATE F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:50 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS confirms that you have now created currently rented to as a new User attribute. At this stage, you have not defined that it is an attribute of the user entity type Video tape.

1.4.7 As instructed, press ENTER to add further details.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               User attribute
               currently rented to
               is a                                                             
               User attribute
               
 CHOOSE                                
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 user defined entity type of which attribute        
   2 entity type(s) related defined by attribute        
F13=REPORT F15=Tasks F17=Personal F23=Messages                 22/07/98 08:50 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

You have created a new attribute definition but must now define the entity type to which it applies.

1.5 Relate the New Attribute to Entity Type A

1.5.1 Select user defined entity type of which attribute by typing the number to its left and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               User attribute                                                   
               currently rented to                                              
               user defined entity type of which attribute
      Our Data 
 REQUEST                               
E00047 No records in table - press F9 to create relationship 
(for FASTPATH, type . then * or ID and ENTER)
 
F9=CREATE Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:51 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS shows that, as you might expect, the user attribute currently rented to is not defined as an attribute of any particular entity type at this point.

1.5.2 Press F9 to create a relationship with the entity type of which you wish it to be an attribute.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     currently rented to
               user defined entity type of which attribute
                                                                                
                                                                                
               
 CHOOSE    name or description         
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 Entity type¬ERROS defined                          
   2 User entity type¬USER defined                      
                                                               22/07/98 08:51 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.5.3 Currently rented to is to be defined as an attribute of a User entity type so select this by typing the number to its left and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     currently rented to
               user defined entity type of which attribute
                                                                                
               User entity type                                                 
               name and/or number
      Our Data 
 Selected                               # 
 To accept, press ENTER; else type new ID & press ENTER (for FASTPATH, type . then * or ID and ENTER)
 
   1 Video tape                                         #100000263 
ENTER/OK                                                       22/07/98 08:52 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS displays the current list of User entity types, which, at this point consists of just one, Video tape.

1.5.4 Press ENTER to accept this (if there is more than one, type the number to its left and then press ENTER).

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate from   User entity type¬USER defined
               User attribute                                                   
               currently rented to                                              
               user defined entity type of which attribute
      Our Data 
 CREATE                                
                                                                               
 Relationship, Surrogate & Security definitions            Screen   1 of   1
 Is this attribute the PRIME identifier of the Entity Type?  (Y/N)
 NOTE: If this is the prime identifier of a secondary entity type, then this
       attribute must be defined here as a relationship.
 Will the attribute be used to store Relationships?          (Y/N)
    If Yes, Rel. definition             Definition version 
            Related record ID.  Related rec'd stored under 
     Recursive Relationships?  
    When relating, Clear attr.            Clear surr. data     Rel. surog. 
 DATA Identifiers -  Surrogate  (^/C/R)    by Entity type?  (^/Y)
 SECURITY                             List?  Y/N
            
 F10 for other parameters                                       22/07/98 08:52 
 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.5.5 Press ENTER to accept the default values, and so create the relationship between entity type A (Video tape and its attribute curretnly rented to as shown on your ERROS diagram.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               User attribute                                                   
               currently rented to                                              
               user defined entity type of which attribute
      Our Data 
 Selected                              
 Relationship created. (for FASTPATH, type . then * or ID and ENTER)
 
   1 Video tape                                         
F9=CREATE F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:53 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

This shows that ERROS has now added currently rented to to the list of attributes for the user entity type Video tape. You have now defined the new user entity type Video tape and its attributes.

1.5.6 Press F3 to retuned to the User defined terms screen.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 REQUEST                               
E00036 No further records found 
(for FASTPATH, type . then * or ID and ENTER)
 
Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:53 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.6 Create the New User Attribute of Entity Type B

The next stage is to define the new attribute video(s) currently rented for the existing ERROS entity type, User Personal and Business name.

1.6.1 Type in the full name of the new, inverse. attribute (i.e. attribute of user entity type B) shown at the bottom of your ERROS diagram. This is video(s) currently rented.


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 REQUEST                               
E00170 Not found - press F9 to add the above record 
(for FASTPATH, type . then * or ID and ENTER)
 
F9=CREATE Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:54 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.6.2 As ERROS does not find the term that you entered, it issues a message and instructs you to press F9 to add the term, so do this.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 CREATE                                
                                                                               
              
                                                                22/07/98 08:54
 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.6.3 This shows that you are about to CREATE a new user defined term of currently rented to. Press ENTER to confirm (as prompted in red) that you wish to add the term to the user repository.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
                                                                                
               user defined term(s)                                             
               name
      Our Data 
 Selected                              
 Record with unique ID. added. Press ENTER to add further details (for FASTPATH, type . then * or ID and ENTER)
 
   1 video(s) currently rented                                        
F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:55 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

This shows that ERROS has added the new user defined term videos currently rented.

1.6.4. As instructed, press ENTER to add further details.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     video(s) currently rented
               is a
                                                                                
               Business modeller definition entity type                         
               name
               
 CHOOSE                                
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 User attribute                                     
   2 User entity type                                   
                                                               22/07/98 08:55 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.6.5 As before, you have the choice of defining the new User defined term as a user attribute or as a User entity type. This time, the term you are adding is again a user attribute, so select that option (by typing the number to its left) and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 COPY   from   Business modeller definition entity type
               user defined term(s)
               name                                                             
               video(s) currently rented                                        
               is a
      Our Data 
 CREATE                                
                                                                               
 Relationship, Surrogate & Security definitions            Screen   1 of   1
  Is this attribute the PRIME identifier of the Entity Type?  (Y/N)
 NOTE: If this is the prime identifier of a secondary entity type, then this
       attribute must be defined here as a relationship.
 Will the attribute be used to store Relationships?          (Y/N)
    If Yes, Rel. definition             Definition version 
            Related record ID.  Related rec'd stored under 
     Recursive Relationships?  
    When relating, Clear attr.            Clear surr. data     Rel. surog. 
 DATA Identifiers -  Surrogate  (^/C/R)    by Entity type?  (^/Y)
 SECURITY                             List?  Y/N
            
 F10 for other parameters                                       22/07/98 08:56 
 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.6.6 You do not need to change any of the default values here, so press ENTER to accept them and to confirm that you wish to add the record.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               user defined term(s)
               name                                                             
               video(s) currently rented                                        
               is a
      Our Data 
 Selected                              
 Relationship created. Press ENTER to add further details. (for FASTPATH, type . then * or ID and ENTER)
 
   1 User attribute                                     
F18=NAVIGATE F9=CREATE F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:56 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS confirms that you have now created video(s) currently rented as a new User attribute.

1.6.7 As instructed, press ENTER to add further details.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               User attribute
               video(s) currently rented
               is a                                                             
               User attribute
               
 CHOOSE                                
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 user defined entity type of which attribute        
   2 entity type(s) related defined by attribute        
F13=REPORT F15=Tasks F17=Personal F23=Messages                 22/07/98 08:56 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

You have created a new attribute definition but must now define the entity type to which it applies. ERROS now displays the attributes of user attributes available in the ERROS Business Modeller that you currently operating.

1.7 Relate the New Attribute to Entity Type B

1.7.1 Select user defined entity type of which attribute by typing the number to its left and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
               User attribute                                                   
               video(s) currently rented                                        
               user defined entity type of which attribute
      Our Data 
 REQUEST                               
E00047 No records in table - press F9 to create relationship 
(for FASTPATH, type . then * or ID and ENTER)
 
F9=CREATE Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:57 
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS shows that, as you might expect, the user attribute video(s) currently rented is not defined as an attribute of any particular entity type at this point.

1.7.2 Press F9 to create a relationship with the entity type of which you wish it to be an attribute.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     video(s) currently rented
               user defined entity type of which attribute
                                                                                
                                                                                
               
 CHOOSE    name or description         
 Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
   1 Entity type¬ERROS defined                          
   2 User entity type¬USER defined                      
                                                               22/07/98 08:57 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.7.3 Video(s) currently rented is to be defined as an attribute of a Entity type-ERROS defined so select this by typing the number to its left and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     video(s) currently rented
               user defined entity type of which attribute
                                                                                
               Entity type                                                      
               name and/or number
               
 REQUEST                                # 
 Type request (e.g. record name or other ID) and press ENTER (for FASTPATH, type . then * or ID and ENTER)
 
Page_UP Page_Down                                              22/07/98 08:58 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS provides access to the list of ERROS defined entity types, so that you can select the one that you want.

1.7.4 Type

User per*

and press ENTER.

ERROS will display the following screen -


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate TO     video(s) currently rented
               user defined entity type of which attribute
                                                                                
               Entity type                                                      
               name and/or number
               
 Selected                               # 
 To accept, press ENTER; else type new ID & press ENTER (for FASTPATH, type . then * or ID and ENTER)
 
   1 User personal and business name                    #      100 
ENTER/OK Page_Down 22/07/98 08:58 
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS finds one entity type User personal and business name that fits the request and displays this.

1.7.5 Press ENTER to accept this.

ERROS will display the following screen.


AS/400 Workstation Gateway


 ERROS Business Modeller   Rob Dixon                  ERROS plc                
 Relate from   Entity type¬ERROS defined
               User attribute                                                   
               video(s) currently rented                                        
               user defined entity type of which attribute
      Our Data 
 CREATE                                
                                                                               
 Relationship, Surrogate & Security definitions            Screen   1 of   1
 Is this attribute the PRIME identifier of the Entity Type?  (Y/N)
 NOTE: If this is the prime identifier of a secondary entity type, then this
       attribute must be defined here as a relationship.
 Will the attribute be used to store Relationships?          (Y/N)
    If Yes, Rel. definition             Definition version 
            Related record ID.  Related rec'd stored under 
     Recursive Relationships?  
    When relating, Clear attr.            Clear surr. data     Rel. surog. 
 DATA Identifiers -  Surrogate  (^/C/R)    by Entity type?  (^/Y)
 SECURITY                             List?  Y/N
            
 F10 for other parameters                                       22/07/98 08:58 
 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.7.6 Press ENTER to accept the default values and to confirm that you wish to add video(s) currently rented as an attribute of the ERROS defined entity type User personal and business name.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc User attribute video(s) currently rented user defined entity type of which attribute Our Data Selected Relationship created. (for FASTPATH, type . then * or ID and ENTER)

1 User personal and business name
F9=CREATE F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:59
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

This shows that you have now defined a new attribute (video(s) currently rented) for the existing entity type B (User personal and business name).
1.8 Define the Relationship between Entity types A and B

1.8.1. The next step is to define the relationship between the two entity types in your application. Press F12 to add further details.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc User attribute video(s) currently rented entity type(s) related defined by attribute Our Data REQUEST
E00047 No records in table - press F9 to create relationship
(for FASTPATH, type . then * or ID and ENTER)

F9=CREATE Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 08:59
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.8.2 Press F9 to create the relationship with user entity type.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate TO video(s) currently rented entity type(s) related defined by attribute CHOOSE name or description Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
1 Entity type¬ERROS defined
2 User entity type¬USER defined
22/07/98 09:00
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.8.4 Select user entity type by typing the number to its left and press ENTER.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate TO video(s) currently rented entity type(s) related defined by attribute User entity type name and/or number Our Data REQUEST #
P00004 Select Entity Type (primary?) to store inverse relationship
(for FASTPATH, type . then * or ID and ENTER)

Page_UP Page_Down 22/07/98 09:00
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

# The prompt P00004 indicates that the entity you choose should probably be a primary entity type.
1.8.5 Key in the full name(or part name followed by an *) of entity type A
Video tape
and press ENTER.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate TO video(s) currently rented entity type(s) related defined by attribute User entity type name and/or number Our Data Selected #
P00004 Select Entity Type (primary?) to store inverse relationship
(for FASTPATH, type . then * or ID and ENTER)

1 Video tape #100000263
Page_Down 22/07/98 09:01
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.8.6 Press ENTER to accept (if there is more than one record, type the number to the left of the one you require and press ENTER).
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc COPY from User entity type¬USER defined User attribute video(s) currently rented entity type(s) related defined by attribute Our Data CREATE Screen 1 of 1 Is this a Primary OR a Secondary entity type? P/S NOTE: The type will be Secondary if the entities (records) to be put in the entity type already exist in another entity type. For secondary entity types, the identifying attribute must be specified as a relationship. 22/07/98 09:01 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.8.7 Press ENTER to confirm the addition of the relationship.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc User attribute video(s) currently rented entity type(s) related defined by attribute Our Data Selected Relationship created. Press ENTER to add further details. (for FASTPATH, type . then * or ID and ENTER)

1 Video tape
F18=NAVIGATE F9=CREATE F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 09:02
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

This shows that you have defined the attribute video(s) currently rented as a relationship with the entity type Video tape.
1.8.8 Press ENTER (as prompted) to add further information.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc video(s) currently rented entity type(s) related defined by attribute Video tape attribute of above as inverse Our Data REQUEST
E00047 No records in table - press F9 to create relationship
(for FASTPATH, type . then * or ID and ENTER)

F9=CREATE Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 09:02
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.8.9 Press F9 (as prompted) to add the inverse relationship.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate TO Video tape attribute of above as inverse User entity type Video tape #100000263 attribute(s) include Our Data CHOOSE Type No. of record (or ID) & ENTER; F9 to add (for FASTPATH, type . then * or ID and ENTER)
1 currently rented to
2 name and/or number
F18=NAVIGATE F9=CREATE F10=Change F11=Delete 22/07/98 09:02
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS displays a list of the attributes that you have defined for entity type A (Video tape).
1.8.10 Select the attribute of entity type A that is at the top of your ERROS diagram currently rented to and press ENTER (note: this will not be the identifying attribute e.g. not name).
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate from User entity type video(s) currently rented User attribute User attribute attribute of above as inverse Our Data CREATE Relationship, Surrogate & Security definitions Screen 1 of 1 Is this attribute the PRIME identifier of the Entity Type? (Y/N) NOTE: If this is the prime identifier of a secondary entity type, then this attribute must be defined here as a relationship. Will the attribute be used to store Relationships? (Y/N) If Yes, Rel. definition Definition version Related record ID. Related rec'd stored under Related name Rel. ref. # Rel. surog. When relating, Clear attr. Clear surr. data DATA Identifiers - Surrogate (¬/C/R) by Entity type? (¬/Y) SECURITY List? Y/N F10 for other parameters 22/07/98 09:03 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.8.11 Press ENTER (as prompted) to accept the default values and to confirm to ERROS that you wish the relationship to be created.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc video(s) currently rented User attribute User attribute attribute of above as inverse Our Data Selected Relationship created. Press ENTER to add further details. (for FASTPATH, type . then * or ID and ENTER)

1 currently rented to
F18=NAVIGATE F9=CREATE F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 09:03
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS confirms that it has created the relationship and that, as in the ERROS diagram, currently rented to is the inverse of video(s) currently rented.
1.8.12 Press ENTER (as prompted) to add further details.
ERROS will display the following screen-

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc video(s) currently rented attribute of above as inverse currently rented to record(s) to be related stored under Our Data REQUEST
E00047 No records in table - press F9 to create relationship
(for FASTPATH, type . then * or ID and ENTER)

F9=CREATE Page_UP Page_Down F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 09:05
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.8.13 You must now tell ERROS where Video tape records are stored so that it will be able to find them when putting up the names of videos rented by customers. Press F9.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate TO currently rented to record(s) to be related stored under CHOOSE name or description Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
1 Entity type^ERROS defined
2 User entity type^USER defined
22/07/98 09:03
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh ]END=End_Task ]OFF=Sign_off

1.8.14 Select User entity type by typing the number to its left and press ENTER.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate TO currently rented to record(s) to be related stored under User entity type name and/or number Our Data REQUEST # Type request (e.g. record name or other ID) and press ENTER (for FASTPATH, type . then * or ID and ENTER)

Page_UP Page_Down 22/07/98 09:06
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.8.15 Type name (or part name followed immediately by an *) of entity type A
Video Tape
and press ENTER.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate TO currently rented to record(s) to be related stored under User entity type name and/or number Our Data Selected # To accept, press ENTER; else type new ID & press ENTER (for FASTPATH, type . then * or ID and ENTER)

1 Video tape #100000263
ENTER/OK Page_Down 22/07/98 09:06
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.8.16 Press ENTER (as prompted) to accept the record retrieved.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate from User entity type¬USER defined video(s) currently rented User attribute User attribute record(s) to be related stored under Our Data CREATE Screen 1 of 1 Is this a Primary OR a Secondary entity type? P/S NOTE: The type will be Secondary if the entities (records) to be put in the entity type already exist in another entity type. For secondary entity types, the identifying attribute must be specified as a relationship. 22/07/98 09:07 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.8.17 Press ENTER (as prompted) to accept the default value and to confirm that you want ERROS to add the relationship.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc video(s) currently rented User attribute User attribute record(s) to be related stored under Our Data Selected Relationship created. Press ENTER to add further details. (for FASTPATH, type . then * or ID and ENTER)

1 Video tape
F18=NAVIGATE F9=CREATE F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 09:07
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

ERROS shows that it has created the relationship.
1.8.18 Press ENTER to add further details.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate TO Video tape attribute containing record(s) to be related Entity type¬ERROS defined Entity type¬ERROS defined record(s) to be related stored under CHOOSE name or description Type No. of record (or full or partial record ID) & press ENTER (for FASTPATH, type . then * or ID and ENTER)
1 Attribute¬of entity type above
2 Entity type¬ERROS defined
3 User entity type
22/07/98 09:08
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.8.19 Select Attribute by typing the number to its left and press ENTER.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate TO Video tape attribute containing record(s) to be related Attribute¬of entity type above Video tape #100000263 attribute(s) include Our Data CHOOSE Type No. of record (or ID) & ENTER; F9 to add (for FASTPATH, type . then * or ID and ENTER)
1 currently rented to
2 name and/or number
F18=NAVIGATE F9=CREATE F10=Change F11=Delete 22/07/98 09:09
F2=MSG_Help F1=HelpF3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

1.8.20 ERROS displays the currently defined attributes of the related user entity type Video tape. Select the identifying atribute name and/or number by typing the number to its left and press ENTER.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc Relate from Entity type¬ERROS defined video(s) currently rented record(s) to be related stored under User attribute attribute containing record(s) to be related Our Data CREATE Screen 1 of 1 Are the record(s) that are stored under this attribute the one(s) to be related or copied? (Y/N) (If the response 'N' is given then ERROS will assume that the operator will select a record and use this to navigate to the record(s) that are to be related/copied) F10 for other parameters 22/07/98 09:09 F1=Help F12=Cancel F5=Refresh ENTER=CONFIRM

1.8.21 Press ENTER to accept the default value of "Y" and to confirm that you wish ERROS to create the relationship.
ERROS will display the following screen -

AS/400 Workstation Gateway

ERROS Business Modeller Rob Dixon ERROS plc video(s) currently rented record(s) to be related stored under User attribute attribute containing record(s) to be related Our Data Selected Relationship created. Press ENTER to add further details. (for FASTPATH, type . then * or ID and ENTER)

1 name and/or number
F18=NAVIGATE F9=CREATE F10=Change F11=Delete F13=REPORT F15=Tasks F17=Personal F23=Messages 22/07/98 09:09
F2=MSG_Help F1=Help F3=RETURN F12=Previous F5=Refresh !END=End_Task !OFF=Sign_off

This completes your business model.
In other words, you have defined all the extensions to the existing data definitions that are required for your application.
An experienced operator will complete the process so far in about 2 minutes. The whole process adds just 40 records to the ERROS database and no new files or programs are created.
1.8.22 Press F3 twice to return to the list of applications to which you are authorised. The next step is to create the application.