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