       / 

     8

      Silverrun,    6  7,     
,  ,  Delphi.     
    Silverrun,    ,    
 ,   Borland. 
           " ".   
      /  
.    Rental Management System,   
 RENTMAN.   ,    6  "  
  /"    7  "  
 /",         
     /.   
         
/   Windows.       ,  
      (.. ,    
).        ,   
   Windows-  /. 
        RENTMAN,     
 ,         
.           
  RENTMAN. ,     
     /  
    .  ,   
,          
      .  ,   
 , ,   ,   ,   
 . 
          . 
            
  ,     . 
           /. 
       ,     
 . 
          /  
 . 
          6,      
  . 
          . 
         ,   
  . 
             
     . 
            
 . 
           . 

    158  II.   


     ,         
 . 
     . 
     . 
     . 
     . 
     . 
            ,  , , 
   .       
  RENTMAN      " ". 
       ,    ,  
  Delphi.    ,     
        
  . 
      ,     RENTMAN,   
   6 (     ).  
,         ,   
      6. 

      
    ,    ,    
  ,    6.     
  ,    6,    
,      -.  ,  
  ,         
   RENTMAN. 

      ,   6        
     Allodium Properties.    
        
 ,     .   
        , 
   6.         
  ,     . 

       

         ,      . 
 ,      6,   .  
     ,    
 ,   .    
,   ,  ,  
  ,      . 
    ,        , 
   : 
       (,      
  ,       ).  
,    RENTMAN    : 
" RENTMAN    ". 

       

      ,     . 
   ,      
.         
.      ,    
     . 
          ,     
 .   6      . 

     8.    / 159 


     RENTMAN    . 
          . 
          . 
         . 
            . 
       ,    
     ,     . 

           

      6        , 
     ,   
   RENTMAN.   ,      
 ,      ( 
    ,    
        ). 
          
     ,    6. 

        

           
     ,    
  .         
   . 
    1.    ,   
  . 
    2.  "-",   . 
    3.     ,   
    . 
         ,    
,    6.      
  .        
   ,     
.     ,   
 ,   .  . 8.1  
     ,   
   6. 
            . 
    1.   ,  ,   . 
    2.     . 
    3.   ,       
  . 
       ,      
   ,    .  
         
 . 
              ? 
          ? 
         ? 
       ? 
          ? 
           . 
     ,   ,      . 
              . 

    160  II.   


    . 8.1.      

      ,       
  ,      , 
    .      
 ,       , , 
   . 
           ,    . 
             
         
  . 
          ,    
 . 
          ,   
  . 
             

       ,     , 
 . 
           . 
             
RENTMAN?   . 
         . 
          . 
           . 
              ,    
   . 
             ? 
          ? 
         ? 
       ? 
          ? 

     8.    / 
    6   Delphi 3   / 161 


           , 
    . 
     ,   ,       
 . 
              . 
           . 
     ,  ,   :   
  ,      . 
                
 . 
              
   . 
               . 
               
   . 
     ,       6,    
 ,     .  
 Silverrun-BPM   ,  ,    
. 8.2. 

     
       ,        
 .     ,    6. 
     Silverrun-BPM   LEASE.BPM    
  File=>Clone     .   
 . ,  ,    ,  
  MAINT.BPM.  ,      LEASE.BPM 
  ,      .  
       
File=>Save As.       ,   
     (,  ,  
 ..). 

    . 8.2.      

    162  II.   


      ,      ,   
    ,    6.   
EMPLOYEE     ,     
,       .     
   Alladium,    , 
    RENTMAN.    
 WORDER,        . 
            
, , ,     ,      6. 
      ,       
    . ,    " 
        
RENTMAN?",  ,       EMPLOYEE 
 WORDER      ,   
      . 
     ,     ,      
,        .    
      .    
       ER-  
  .        
.      Project=>Data Structures, 
             
Data Structure=>Composition.    EMPLOYEE   . 
    
    Employee Number 
    Employee Name 
    
       WORDER   . 
    
    WOrder Number 
    WOrder Start Date 
    WOrder End Date 
    WOrder Employee Number 
    WOrder Property Number 
    WODetail Line Number 
    WODetail Description 
    Work Type Code 
    Work Type Description 
    Work Type Task Duration 
    WOrder Comments 
    
       ,     
,   . 
    1.   Silverrun-BPM    
Presentation=>Palettes=>Data Structures,     
. 
    2.            
Data Structures Palette   . 
    3.   Data Structures Palette   ,   
,    .  ,    
     ,    
   -. 

      

              
 ER-.      ,  
  File=>Save.       ,     MAINT.BPM. 
     ,      ,   
   ,   "-",  
     Silverrun-ERX.    
  ,         
,    ERX.      . 
    1.    Util=>WRM Dictionary.    
Silverrun-BPM         
Silverrun.      WRM Dictionary,     
Silverrun-BPM    WRM Dictionary. 
    2.    ,    WRM Dictionary=>Update 
WRM Dictionary. 

     8.    / 163 

    3.          Update,  
    Save (),   ,   
   .       
          
 .         , 
   . 
    4.   WRM Dictionary=>Save WRM Dictionary As   
 MAINT.WRM      ,    
    Silverrun-ERX. 
    5.       WRM Dictionary. 
          ,      , 
      ER-    
 .   Silverrun    Silverrun-ERX. 

      "-" 

       Silverrun-ERX   
       .  
Silverrun-ERX        
,      .   
         , 
     ""      
    ER-.  CASE-  
       . 
    -,       
"-"        . 
 Silverrun-RDM    ,   
  Silverrun-BPM  ,      Silverrun-ERX. 
          
Silverrun-ERX      .   
,    .     
  ER-       
     . 

           

       ,     
 ,   ER-      
 Silverrun-ERX.     . 
    1.    Util=>WRM Dictionary,    
Silverrun-ERX       Silverrun. 
    2.    WRM Dictionary=>Open WRM Dictionary   
     MAINT.WRM,   Silverrun-BPM. 
    3.    WRM Dictionary=>Update a Model,    
      Update   , 
     .     , 
     ,    , 
   Yes.      ,  
    ,     .  
        ER-. 
   ,    . 
    4.       WRM Dictionary. 
              
     .     
   ,       
ER-.  ,      , 
  . 
    1.    Presentation=>Palettes=>Component: SR Store,  
  ,      
   . 
    2.    LEASE  PROPERTY,      
    ,    
          . 

    164  II.   


    3.  ,       , 
  ,        .  
       .  , 
   ,     , 
     . 
    4.      Component: SR Store.  . 8.3 
   ER-,     . 

    . 8.3.  "- "     


      

     ,      ,  
  ER-.     Silverrun-ERX  
  . 
    1.    Expert=>Expert Mode,    
Silverrun-ERX   ,      
  (,   ). 
    2.    Expert=>Normalize Model,   
.       ,   
,    Yes. 
    3.  ,       ,  
      Analyze Attribute Names. 
    4.      ,     
  .    ,    Yes. 
          ,   
  Silverrun-ERX. ,   
,       . 
  ,      .    
,   . 8.4. 
     ,       : WODetail  
Work Type.  ,        
  ,        
         .   
    ,    4 "",  
   Work Type. 

     8.    / 165 


    . 8.4.    "-"    

      ,      Silverrun-ERX 
    . ,     
  . ,      
 WORDER  WORKTYPE.  WORKTYPE      
  ,          
 .   ,   
,  .      
 . 
    1.      WORDER  WORKTYPE,    
<Delete>.      . 
    2.   -       
  SilverrunERX (  , 
     ),    
   WODETAIL  WORKTYPE.     
   .    ,   
         
.        . 
             TENANT. 
        
 Silverrun-ERX       
,     .    
        TENANT    
,      ,    TENANT 
   LEASE, a  LEASE    
PROPERTY.      PROPERTY  LEASE   
    ,    .  
  TENANT   . 
      ,          
  ,      ,  
     .      
  TENANT  .        
    <Delete> (. 8.5). 

    166  II.   


    . 8.5.       TENANT 


      

             
     .   
         
  .    ,   
      .   
  . 
    1.    Expert=>Verify Connectivities,   
  ,         
     . 
    2.    All Connectivities    Verify 
Connectivities  ,   for selected relationships  
,    Verify. 
    3.       , 
   .    Silverrun-ERX 
         . 
      . 8.1. 

     8.1.   ,    

    												 

    In general is it necessary for a "WORDER" to have an "EMPLOYEE" to exist?	Yes 
    In general can one "WORDER" have many "EMPLOYEE"?					No 
    In general is it necessary for an "EMPLOYEE" to have a "WORDER" to exist?	No 
    In general can one "EMPLOYEE" have many "WORDER"?					Yes 
    In general is it necessary for a "WORDER" to have a "WODETAIL" to exist?	No 
    In general can one "WORDER" have many "WODETAIL"?					Yes 
    In general is it necessary for a "WODETAIL" to have a "WORDER" to exist?	Yes 
    

     8.    / 167 


     . 8.1 

    													 

    In general can one "WODETAIL" have many "WORDER"?						No 
    In general is it necessary for a "CALL" to have a "WORDER" to exist?		No 
    In general can one "CALL" have many "WORDER"?						No 
    In general is it necessary for a "WORDER" to have a "CALL" to exist?		No 
    In general can one "WORDER" have many "CALL"?						Yes 
    In general is it necessary for a "WORKTYPE" to have a "WODETAIL" to exist? 	No 
    In general can one "WORKTYPE" have many "WODETAIL"?					Yes 
    In general is it necessary for a "WODETAIL" to have a "WORKTYPE" to exist?	Yes 
    In general can one "WODETAIL" have many "WORKTYPE"?					No 

     ,       ,   
 Silverrun-ERX       
.    ,      
WORDER  WODETAIL   (. 8.6). 

    . 8.6.       


       

           ,    
       .   
  ,     , 
  . 
    1.    Expert=>Search for Identifiers,   
  . 

    168  II.   


    2. ,        for 
selected entities,     Search. 
     ,     ,   
 ,        
.  ,   . 8.2   
  ,    ,    
 Continue.         
 ,    Id.       
 . 

     8.2.   ER- 

    	 

    CALL		Call Number 
    EMPLOYEE	Employee Number 
    WODETAIL	WORDER identifier, WODetail Line Number 
    WORDER		WOrder Number 
    WORKTYPE	Work Type Code 

          WODETAIL.  
      ,  ,   
.      ,    
 WODetail Line Number.   ,      
,          WODETAIL 
(,        1).    
      .    
  WORDER.       
  ,       WODETAIL. 
 , WODETAIL  ,   WORDER,    
    WORDER.  Silverrun-ERX 
       
    . 
      ,    Silverrun-ERX 
   WORDER   WODetail Line Number  
,     WODETAIL.  , 
            
   .       
.   Silverrun-RDM   SQL,  
   ,         
     WORDER.   
 WORDER        WODETAIL   
  WODETAIL,       
   .  ,    WORDER 
     ,      
  WODETAIL.       . 

     . 8.7  ,   . 


      

       ER-  .   
       ,   
Silverrun-RDM.     . 
    1.    File=>Save,      
(  MAINT.ERX).        
   Model=>Model Description.  . 8.8   
  . 
    2.   Silverrun-ERX    Silverrun ERX-RDM. 
     ,    
Silverrun-ERX,  ,    Silverrun-RDM. 

     8.    /                         169 


    . 8.7.        

    . 8.8.     "-" 


    170  II.   


    3.    Silverrun ERX-RDM,    
File=>Transform ERX->RDM. 
    4.  ,  ER-,      
  .     MAINT.ERX. 
    5.        ,  
    MAINT.RDM.      
 Silverrun-RDM. 
    6.   Silverrun ERX-RDM   Silverrun-RDM. 

        

    ,   "-"     , 
  SilverrunRDM,       
 .       
   .      
 (, )    (, ). 
     SQL,    
 ,      .  
   ,        
 RENTMAN        .   
 RENTMAN     InterBase. 

         

    ,   ,      
  (LDM  Logical Data Model)     
,           
.          
   RENTMAN.        
LDM   ,   LDM  . 
     ,  Silverrun-RDM  ,  
    .      
       ,  
 . 
    1.     ,   ,  
 Silverrun-RDM  . 
    2.    Open   Silverrun-RDM   
 MAINT.RDM,   Silverrun ERX-RDM. 
    3.    ,    ,   
   Silverrun-RDM.    Yes. 
    4.      .    Avail. Target 
Sys.       INTBAS=>INTBAS41.TYP,   
   .         
   Silverrun-RDM   InterBase   
4.1,        Silverrun-RDM. 
    5.    Schema=>Schema Description,    
Relational Data Model for Maintenance Process    . 
    6.    Open        
,    ,   .     
 LEASE.RDM. 
    7.    Util=>lntegrate,    
  SilverrunRDM. 
    8.    Schema Integration     
   (Source Schema),      
  (Dest. Schema).    Integrate. 
    9.    ,       
    .       
    ,   . 
    10.    Integration Report    Save 
(),        
 . 
    11.    Target systems      
InterBase     . 

     8.    / 171 


    12.    Tables    Link by Name,  
      .      
 CALL.    ,   . 
    13.    Connectors    ,   
    ,   .   
        . 
    14.   ,  LDM  ,    
  ,     . , 
      ,    
  ,      . 
    15.    Schema=>Schema Description    
   Relational Data Model.     
    . 
    16.      RENTMAN.RDM (   
MAINT.RDM).          
  RENTMAN.  . 8.9     . 

    . 8.9.      RENTMAN 

             
   Silverrun.        
   CASE-.         Silverrun,  
    ,     
,     . 
             CALL. 
     CALL    PROPERTY,    
     WORDER.  ,    
   . 
     CALL     Property Number,   
   .       
,    Allodium     
    .    
 CALL  PROPERTY        , 
  ,   .    ,     
        Property Number  
  .       

    172  II.   


  CALL,   Property Number (  Coded 
Name  Domain   ,    . 8.10)    
 Delete.       Table Columns, 
   . 

    . 8.10.   Property Number   CALL 

     WORDER     WOrder Property Number.  
  ,      CALL.      
    WORDER  PROPERTY     
Silvermn-RDM Connector. 

      

      LDM        
     RENTMAN.    
  ,    .     
      .     
,    -  ,   . 8.10. 
     : WORDER, WODETAIL, 
WORKTYPE  EMPLOYEE.         
:  ,  ,       
.     Silverrun-RDM   
 SQL. 
              
 ,  . 8.3. 

      
    ,     ,   Description   
CALL, WODETAIL  WORKTYPE  .        
    ,        
    .      
          
   .     
           
,   . 

     8.    / 173 

          TComments  
  WOrder Comments  WORDER.  LDM  
       ,      
  ,     . 

     8.3.         

							   		
								 					 
														 NULL 

EMPLOYEE	Employee Number	INTEGER	-		-					     
		Employee Name	CHARACTER	30		-					 
WORDER	WOrder Number	INTEGER	-		-					 
		WOrder Start 	DATE		-		-					 
		Date	
		WOrder End Date	DATE		-		-					 
		WOrder Comments	TComments	-		-					 
WODETAIL	WODetail Line 	INTEGER	-				-			 
		Number
		WODetail 		CHARACTER	30		-					 
		Description
WORKTYPE	Work Type Code	INTEGER	-		-		-			 
		Work Type 		CHARACTER	30		-					 
		Description
		Work Type Task	DECIMAL	5		2					 
		Duration
    
       
    
             
    .       
,      .  
Silverrun-RDM  ,       
   ,   .  ,  
         
 .    SQL,     
    ,  ,    
       .   
        
   Silverrun-RDM     Presentation=>Displayed 
Descriptor.  ,    ,  
 . 
    1.    Schema=>Generate Coded Names. 
    2.    Coded Names Generation    Specify  
  Maximum Length  Nb. of characters used from the beginning 
of each word in the name  30.     
     InterBase,  30    
 .     3  30 ,  
        . 
    3.          , 
     Coded Names Generation.    Generate. 
        ,      
  .  ,      
 ,         Table Columns. 
            
,     WORDER, WODETAIL, EMPLOYEE  
WORKTYPE.          
 ,   ,    

    	174       II. 
	 KVDR 

.         
  Silverrun-ERX,     .  
WODetail_Description   ,  Description,   
WODetail_Line_Nurriber   ,      
 .  ,     ,  
   .       
      ,     
    . 

        

     ,       Silverrun-ERX,  
    .   ,   
     ER   , 
        WORDER  PROPERTY.  
,    Allodium Properties    
      ,  . 
  ,        CALL,  
     . ,   
   ,     
      .     
  ,      - . 
             .  
     Angular Connector   
 Silverrun-RDM,      PROPERTY     
 WORDER.          
    (. 8.11).  ,    
,   Silverrun-RDM,     
  .     , 
  ,      , ,  
  . 

    . 8.11.       Angular Connector 


       

             
  .      
     ,  Silverrun-RDM  
        . 

     8.    / 175 

         
     .    
       ( )  
,       .  
     . 
    1.    Schema=>Foreign Keys=>Generate. 
    2.        Generate. 
    3.    Save (),    , 
        . 
           .  
     ,    
   FK (. 8.12). 

    . 8.12.      

        .    
 SQL,    ,    . 

       

       SQL      
   .      
   Silverrun-RDM. 
    1.    Schema=>Verify Integrity. 
    2.         Maximum 
Level of Verification     Verify. 
    3.        (verify),  
  Save (). 
    4.        .   
- ,         . 
    5.        ,  
 Silverrun-RDM,    Util=>View a Text File   
  (  Verify),      Open (). 

    176                           II.   


     DDL 

             
    DDL,     
   .   Silverrun     
  SQL,        
  . 
      CREATE TABLE     ,  
Silverrun-RDM      CONNECT    
  ,      . Silverrun-RDM  
       ,    
       DDL.  , 
 CONNECT,  RDM,     
  .     ,   . 
    1.    Schema=>Schema Description,   
  Schema Description. 
    2.   Coded Name       InterBase,  
     .    
:\DATA\RENTMAN\RENTMAN.GDB. 
    3.    ,    . 
    SQL.     . 
    1.    Schema=>Generate DDL. 
    2.          Coded Name. 
    3.    Generate. 
    4.        *.SQL   <Enter>.  
    SQL,      
    SQL.    RENTMAN.SQL    
 Save ().      SQL. 
             SQL.  
    Silverrun-RDM.   8.1  
  RENTMAN.SQL. 

     8.1.   DDL (     DDL 
 SQL),   Silverrun-RDM   
   RENTMAN 

    CONNECT ":\DATA\RENTMAN\RENTMAN.GDB" USER " " PASSWORD " "; 

    CREATE DOMAIN TAddition AS CHARACTER(20) NOT NULL CHECK 
    (VALUE IN ('Deerfield', 'Firewheel', 'Legacy Hills', 'Switzerland 
     Estates', 'Sherwood',  'Rockknoll')) ; 

    CREATE DOMAIN TAddress AS CHARACTER(30) NOT NULL; 

    CREATE DOMAIN TCity AS CHARACTER(30) NOT NULL CHECK (VALUE IN ('Oklahoma 
     City', 'Norman', 'Edmond', 'Dallas', 'Richardson', 'Piano')); 

    CREATE DOMAIN TComments AS VARCHAR(SO); 

    CREATE DOMAIN TPhone AS CHARACTER(12) NOT NULL; 

    CREATE DOMAIN TPropertyNo AS INTEGER NOT NULL; 

    CREATE DOMAIN TRent AS NUMERIC(5, 2) NOT NULL; 

    CREATE DOMAIN TRooms AS INTEGER NOT NULL CHECK (VALUE IN (0, 1, 2, 3, 4, 5)); 

    CREATE DOMAIN TSchoolDistrict AS CHARACTER(20) NOT NULL CHECK 
    (VALUE IN ('Putnam City', 'Oklahoma City', 'Richardson', 'Edmond', 'Garland', 'Dallas',
    'Piano')); 

    CREATE DOMAIN TState AS CHARACTER(2) NOT NULL CHECK 


     8.    / 177 


    (VALUE IN ('OK', 'TX'));

    CREATE DOMAIN TTenantNo AS INTEGER NOT NULL;

    CREATE DOMAIN TYesNo AS CHAR(l) NOT NULL CHECK
    (VALUE IN ('Y', 'N')) ;

    CREATE DOMAIN TZip AS CHARACTER(10) NOT NULL;

    CREATE TABLE EMPLOYEE ( 
      Employee_Number INTEGER NOT NULL, 
      Name CHARACTER(30) NOT NULL,
      PRIMARY KEY (Employee_Number)
    );
    
    CREATE TABLE PROPERTY (   
      Property_Number    TPropertyNo NOT NULL,
      Address            TAddress NOT NULL,
      City               TCity NOT NULL,
      State              TZip NOT NULL,
      Zip                TZip NOT NULL,
      Addition           TAddition NOT NULL,
      SchoolDistrict    TSchoolDistrict NOT NULL,
      Rent               TYesNo NOT NULL,
      Deposit            NUMERIC(5, 2) NOT NULL,
      LivingAreas        TRooms NOT NULL,
      BedRooms           TRooms NOT NULL,
      BathRooms          TRooms NOT NULL,
      GarageType         TRooms NOT NULL,
      CentralAir         TYesNo NOT NULL,
      CentralHeat        TYesNo NOT NULL,
      GasHeat            TYesNo NOT NULL,
      Refigerator        TYesNo NOT NULL,
      Range              TYesNo NOT NULL,
      Dishwasher         TYesNo NOT NULL,
      PrivacyFence       TYesNo NOT NULL,
      LastLawnDate       DATE,
      LastSprayDate      DATE,
      PRIMARY KEY (Property_Number)
    );

    CREATE TABLE TENANT (   
     Tenant_Number      TTenantNo NOT NULL,
     Name               CHARACTER(30) NOT NULL,
     Employer           CHAR(30) NOT NULL,
     EmployerAddress    TAddress NOT NULL,
     EmployerCity       TCity NOT NULL,
     EmployerState      TState NOT NULL,
     EmployerZip        TZip NOT NULL,
     HomePhone          TPhone NOT NULL,
     WorkPhone          TPhone NOT NULL,
     ICEPhone           TPhone NOT NULL,
     Comments           TComments,
     PRIMARY KEY (Tenant_Number)
   );

   CREATE TABLE WORKTYPE (   
    Work_Type_Code     INTEGER NOT NULL,
    Description        CHARACTER(30) NOT NULL,
    TaskDuration       DECIMAL(5, 2) NOT NULL,
    PRIMARY KEY (Work_Type_Code)
  );

  CREATE TABLE LEASE (   
   Lease_Number       INTEGER NOT NULL,



178  II.  


   BeginDate          DATE NOT NULL,
   EndDate            DATE NOT NULL,
   MovedInDate        DATE,
   MovedOutDate       DATE,
   Rent               TRent NOT NULL,
   PetDeposit         NUMERIC(5, 2),
   RentDueDay         SMALLINT NOT NULL,
   LawnService        TYesNo NOT NULL,
   Comments           TComments,
   Property_Number    TPropertyNo NOT NULL,
   Tenant_Number      TTenantNo NOT NULL,
   PRIMARY KEY (Lease_Number),
   CONSTRAINT FK_TENANT1
     FOREIGN KEY (TenantJMumber)
       REFERENCES TENANT,
   CONSTRAINT FK_PROPERTY2
     FOREIGN KEY (Property_Number)
       REFERENCES PROPERTY
  );

  CREATE TABLE WORDER (   
   WOrder_Mumber      INTEGER NOT NULL,
   StartDate          DATE NOT NULL,
   EndDate            DATE,
   Comments           TComments,
   Property_Number    TPropertyNo NOT NULL,
   Employee_Number    INTEGER NOT NULL,
   PRIMARY KEY (WOrderJMumber),
   CONSTRAINT FK_PROPERTY3
     FOREIGN KEY (Property_Number)
       REFERENCES PROPERTY,
   CONSTRAINT FK_EMPLOYEE4
     FOREIGN KEY (Employee_Number)
       REFERENCES EMPLOYEE
  );

  CREATE TABLE CALL (   
   Call_Number        INTEGER NOT NULL,
   CallDate           DATE NOT NULL,
   CallTime           CHARACTER(11) NOT NULL,
   Description        CHARACTER(30) NOT NULL,
   Property_Number    TPropertyNo,
   WOrder_Mumber      INTEGER,
   PRIMARY KEY (Call_Number),
   CONSTRAINT FK_PROPERTY5
     FOREIGN KEY (Property_Number)
       REFERENCES PROPERTY,
   CONSTRAINT FK_WORDER6
     FOREIGN KEY (WOrderJMumber)
       REFERENCES WORDER
  );

  CREATE TABLE WODETAIL (   
    WODetail_Line_Number INTEGER NOT NULL,
    Description          CHARACTER(30),
    Work_Type_Code       INTEGER NOT NULL,
    WOrder_Number        INTEGER NOT NULL,
    PRIMARY KEY (WOrder_Mumber, WODetail_LineJSIumber) ,
    CONSTRAINT FK_WORKTYPE7
      FOREIGN KEY (Work_Iype_Code)
        REFERENCES WORKTYPE,
    CONSTRAINT FK_WORDER8
      FOREIGN KEY (WOrder_Mumber)
        REFERENCES WORDER
  );


   8.    / 179

       ,       ,   
 CONNECT      .  
Delphi          
RENTMAN.SQL.  ,   CONNECT,  . 
CONNECT ":\DATA\RENTMAN\RENTMAN.GDB" USER "SYSDBA" PASSWORD "masterkey"; 
        Delphi. 

       

    ,       SQL,     
  RENTMAN.  ,       InterBase,  
      RENTMAN,   . 
    1.   InterBase,     .  , 
       .    
 InterBase Server 4.2,    InterBase 4.2.  
  Windows NT 4.0  Windows 95       
InterBase 4.2   Explorer ().    Windows NT 
3.51   InterBase 4.2      InterBase 
Server 4.2,   . 
    2.    ,      
,       .     
  C:\DATA\RENTMAN. 
    3.   InterBase windows ISQL     
File=>Create Database. 
    4.   Database Name        
,  C:\DATA\RENTMAN\RENTMAN.GDB.    
 ,    Coded Name   Schema 
Description  Silverrun-RDM. 
    5.         .  
   SYSDBA   masterkey.    . 
    6.    ,    .   
  ISQL        . 
        SQL,    Silverrun-RDM. 
    . 
    1.    ISQL    File=>Run an ISQL Script  
  ,    Silverrun-RDM. 
    2.    Open (),   . 
    3.          
   No ().       
     ISQL. 
    4.     ISQL     
 .     ISQL. 

      

    !       RENTMAN.    
,      RENTMAN,  
      
 /. 

       RENTMAN 

           ,     
 RENTMAN ,        
    -  .   
(      )    
         RENTMAN. 
,          
       . ,  
    ,      ,  , 
     .      
 TENANT, PROPERTY  LEASE. 

    180  II.   

           
        .  , 
12 "",  ,   RENTMAN    
     .  ,   
 ,  RENTMAN    - 
   . 
     ,         . 
,  ,      
,      ,  
   .  ,      
 ,      . 
  ,         
 .        
  ,   ,     
 ..         .    
, ,  ,        RENTMAN. 

     

             InterBase 
 /   RENTMAN.     
  ,        
,     .      
,    6,      
, ER-,        
 .          
 /. 

     ... 

            Delphi, 
      RENTMAN.   
     /  
   ,    . 

     8.    / 181 