.


:




:

































 

 

 

 





()

1 -

staffNo sName position salary branchNo
SKh1   B001
SK2 .   B005
SS1   B003
SKh2   B001
SKh3   B001
SK1   B005
SK3   B007
SS2 .   B003

2 -

branchNo bAddress postcode
B001 , ., 35  
B005 , ., 8  
B003 , ., 1  
B007 , ., 7  

3 - _

staffNo sName position salary branchNo bAddress
SKh1   B001 , ., 35
SK2 .   B005 , ., 8
SS1   B003 , ., 1
SKh2   B001 , ., 35
SKh3   B001 , ., 35
SK1   B005 , ., 8
SK3   B007 , ., 7
SS2 .   B003 , ., 1

4 - _

clientNo cName propertyNo pAddress rentStar rentFinish rent ownerNo oName
CR76 PG4 , ., 9, .11 01.02.2008 01.09.   040
    PG16 , ., 3, .7 10.04.2008 10.10.   093
CR56 PG4 , ., 9, .11 01.10.2008 01.10.   040
    PG36 , .23 , 3, .27 01.12.2008 01.12.   093
    PG16 , ., 3, .7 10.11.2008 10.11.   093

5 - _

clientNo propertyNo cName pAddress rentStar rentFinish rent ownerNo oName
CR76 PG4 , ., 9, .11 01.02.2008 01.09.   040
CR76 PG16 , ., 3, .7 10.04.2008 10.10.   093
CR56 PG4 , ., 9, .11 01.10.2008 01.10.   040
CR56 PG36 , .23 , 3, .27 01.12.2008 01.12.   093
CR56 PG16 , ., 3, .7 10.11.2008 10.11.   093

6 - __

clientNo propertyNo pAddress rentStar rentFinish rent ownerNo oName
CR76 PG4 , ., 9, .11 01.02.2008 01.02.   040
CR76 PG16 , ., 3, .7 11.12.2008 11.12.   093
CR56 PG4 , ., 8, .3 15.05.2008 31.12.   040
CR56 PG36 , .23 , 3, .27 01.12.2008 01.12.   093
CR56 PG16 , ., 3, .8 03.12.2008 31.12.   093

7 -

clientNo cName
CR76
CR56

8 -

clientNo cName
CR76
CR56

9 -

clientNo propertyNo rentStar rentFinish
CR76 PG4 01.02.2008 01.02.2009
CR76 PG16 11.12.2008 11.12.2009
CR56 PG4 15.05.2008 31.12.2009
CR56 PG36 01.12.2008 01.12.2009
CR56 PG16 03.12.2008 31.12.2009

10 - _

propertyNo pAddress rent ownerNo oName
PG4 , ., 9, .11   040
PG16 , ., 3, .7   093
PG36 , .23 , 3, .27   093

11 - _

propertyNo pAddress rent ownerNo
PG4 , ., 9, .11   040
PG16 , ., 3, .7   093
PG36 , .23 , 3, .27   093

12 -

ownerNo oName
040
093

13 -

clientNo cName
CR76
CR56

14 -

clientNo propertyNo rentStar rentFinish
CR76 PG4 01.02.2008 01.02.2009
CR76 PG16 11.12.2008 11.12.2009
CR56 PG4 15.05.2008 31.12.2009
CR56 PG36 01.12.2008 01.12.2009
CR56 PG16 03.12.2008 31.12.2009

15 - _

propertyNo pAddress rent ownerNo
PG4 , ., 9, .11   040
PG16 , ., 3, .7   093
PG36 , .23 , 3, .27   093

16 -

ownerNo oName
040
093

17 - _

pnum pname dnum volume
  1    
  1    
  1    
  2    
  2    
  3    

18 -

pnum pname
  1
  2
  3

19 -

pnum dnum volume
     
     
     
     
     
     

20 - _

branchNo cName oName
B003
B003
B003
B003

21 - _

branchNo cNames
B003
B003

22 - _

branchNo oName
B003
B003

23 - __ 4

propertyNo ItemDescription supplierNo
PG4 S1
PG4 S2
PG16 S2
PG16 S1
PG36 S3

24 - _

propertyNo ItemDescription
PG4
PG4
PG16
PG16
PG36

25 - _

ItemDescription supplierNo
S1
S2
S2
S1
S3

26 - _

propertyNo supplierNo
PG4 S1
PG4 S2
PG16 S2
PG16 S1
PG36 S3

 

 

. 5.

 





:


: 2016-12-17; !; : 266 |


:

:

: , .
==> ...

1332 - | 938 -


© 2015-2024 lektsii.org - -

: 0.016 .