()
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.