Examples of Database Relations 1

646 Views


Files Customer Master and Customer_Details

This is the final structure:

    File name. . . . : Customer MAster            
                                                  
 ? Field                    Type      Ocr  Et Ksq 
                                                  
   Customer ID               CDE           K    1 
   Customer Detail           CDE           A      


    File name. . . . : Customer_Details           
                                                  
 ? Field                    Type      Ocr  Et Ksq 
                                                  
   UP_Cust_id                CDE           K    1 
   UP_Cust_Name              TXT           A      
   UP_Cust_Address           CDE           A      
   UP_Cust_DOB               D8#           A      
   UP_Phone_No               NBR           A      
   UP_Mail_id                CDE           A      


    File name. . . . : Customer_Login             
                                                  
 ? Field                    Type      Ocr  Et Ksq 
                                                  
   UP_Cust_id                CDE           K    1 
   Password_Up               CDE           A      
                                                  
   FIL downer                    Known by         FLD o id               
   FIL downer                    Has              FLD o name 
            
   FIL dpro details              Owned by         FIL dproduct 
          
   FIL dproduct                  Known by         FLD pr id              
   FIL dproduct                  Refers to        FIL downer             
   FIL dproduct                  Has              FLD pr name            
   FIL dproduct                  Has              FLD pr type            
   FIL dproduct                  Has              FLD pr active    


File Structures:
  
                                                  
    File name. . . . : downer                    
                                                 
 ? Field                    Type      Ocr  Et Ksq
                                                 
   o id                      CDE           K    1
   o name                    CDE           A     
                                                 
    File name. . . . : dpro details              
                                                 
 ? Field                    Type      Ocr  Et Ksq
                                                 
   pr id                     CDE           K    1


    File name. . . . : dproduct                   
                                                  
 ? Field                    Type      Ocr  Et Ksq 
                                                  
   pr id                     CDE           K    1 
   o id               029169 CDE REF       A      
   o name                    CDE           V      
   pr name                   CDE           A      
   pr type                   CDE           A      
   pr active                 STS           A    
                                                               
    FIL DT0001                    Known by       1 FLD aa_project ID      
    FIL DT0001                    Qualified by   2 FLD BDistance          
          For: old                          Sharing: *PREVIOUS            
    FIL DT0001                    Refers to        FIL emp         

   FIL emp                       Known by         FLD Employee    
   FIL emp                       Refers to        FIL dno         
   FIL emp                       Has              FLD edoj        
   FIL emp                       Has              FLD emgr        
   FIL emp                       Has              FLD esal        
   FIL emp                       Has              FLD ename       

    File name. . . . : DT0001                    
                                                 
 ? Field                    Type      Ocr  Et Ksq
                                                 
   aa_project ID             CDE           K    1
   BDistance                 QTY           K    2
   Employee                  CDE           A     
   edoj                      DT#           V     
   emgr                      CDE           V     
   esal                      NBR           V     
   ename                     TXT           V     
   dtfld2                    NBR           A     
   Alt Ins Flag              STS           A     
   aa_Role Desc              TXT           A     

    File name. . . . : emp                        
                                                  
 ? Field                    Type      Ocr  Et Ksq 
                                                  
   Employee                  CDE           K    1 
   edoj                      DT#           A      
   emgr                      CDE           A      
   esal                      NBR           A      
   ename                     TXT           A      
                                                        

 

Post Comments