()
branchNo | street | city | postcode |
B001 | ., 35 | ||
B005 | ., 8 | ||
B003 | ., 1 | ||
B007 | ., 7 |
()
staffNo | fName | lName | position | sex | DOB | salary | branchNo |
SKh1 | 10.03.1980 | B001 | |||||
SK2 | . | 05.07.1977 | B005 | ||||
SS1 | 17.10.1965 | B003 | |||||
SKh2 | 11.05.1982 | B001 | |||||
SKh3 | 11.05.1982 | B001 | |||||
SK1 | 19.03.1979 | B005 | |||||
SK3 | 12.08.1981 | B007 |
1.
branchNo | BranchNumbers | : 4, 'B001'-'B999' | |
street | StreetNames | : 40 | |
city | cityNames | : 32 | |
postcode | Postcodes | : 5 | |
sex | Sex | : 1, '' '' | |
DOB | DatesOf Birth | : l-Jan-1900, dd-mon-yyyy | |
salary | Salaries | : 7 , 6000.00-40000.00 |
2.
1 | 2 | |
3. salary>2500
staffNo | fName | lName | position | sex | DOB | salary | branchNo |
SKh1 | 10.03.1980 | B001 | |||||
SS1 | 17.10.1965 | B003 | |||||
SK1 | 19.03.1979 | B005 | |||||
SK3 | 12.08.1981 | B007 |
4.
staffNo | fName | lName | salary |
SKh1 | |||
SK2 | |||
SS1 | |||
SKh2 | |||
SKh3 | |||
SK1 | |||
SK3 | |||
SS2 |
5. _
|
|
propertyNo | street | city | postcode | type | rooms | rent | ownerNo |
PG4 | ., 9, .11 | 040 | |||||
PG16 | ., 3, .7 | 093 | |||||
PG36 | .23 , 3, .27 | 093 | |||||
CA15 | ., 3 | 101 | |||||
CA09 | ., 17, .15 | 314 | |||||
PG80 | ., 43, .7 | 079 | |||||
A34 | ., 5 | 452 | |||||
CA19 | ., 7 | 453 |
() _
propertyNo | street | city | postcode | type | rooms | rent | ownerNo | staffNo | branchNo |
PG4 | ., 9, .11 | 040 | SKh2 | B001 | |||||
PG16 | ., 3, .7 | 093 | SKh2 | B001 | |||||
PG36 | .23 , 3, .27 | 093 | SKh3 | B001 | |||||
CA15 | ., 3 | 101 | SK2 | B005 | |||||
CA09 | ., 17, .15 | 314 | SK2 | B005 | |||||
PG80 | ., 43, .7 | 079 | B001 | ||||||
A34 | ., 5 | 452 | SS2 | B003 | |||||
CA19 | ., 7 | 453 | SK3 | B007 |
6. ( ) _
city |
7. _
city |
8. _
city |
9. 10.
11
. , . 12, _ 13.
12.
propertyNo | street | city | type | rooms | clientNo | cName |
PG4 | ., 9, .11 | CR76 | ||||
PG16 | ., 3, .7 | CR56 | ||||
PG36 | .23 , 3, .27 | CR56 | ||||
CA15 | ., 3 | CR76 | ||||
CA09 | ., 17, .15 | CR76 | ||||
PG80 | ., 43, .7 | CR56 | ||||
A34 | ., 5 | CR76 | ||||
CA19 | ., 7 | CR76 |
13. _
|
|
rooms |
¸ s rooms=3 (_)
, 14.
14.
propertyNo | street | city | type | clientNo | cName |
PG16 | ., 3, .7 | CR56 | |||
PG80 | ., 43, .7 | CR56 |
, :
cName (¸ s rooms=3 (_)).
14 ( ).
15.
cName |