33
Manager
1..1
staffNo
{PK. FK}
Telephone
1..1
Manages
-. Supervises
IelNo {PK}
IS-A
'I'
branchNo {FK}
'I'
0
11
1..1
1..1
1..3
...
0..10
1..1
Prov1des
Staff
-. Has
Branch
staffNo {PK}
1..'
1..1
branchNo
{PK}
0..1
supervisorStaffNo {FK}
mgrStaffNo
{FK}
branchNo {FK)
1..1
Processes 1
..1
1..1
Reg1sters
'I'
o.·
Registration
1..'
'I'
clientNo {PK, FK}
branchNo
{FK}
staffNo
{FK)
"'1 1..1
Agrees
1..1
Oversees
'I'
Holds
1..
Cl1ent
Offers
'I'
clientNo {PK}
1..1
Requests
'
0..•
0 •
'I'
Lease
Viewng
leaseNo
{PK}
clie'ltNo {PK.FK}
cl•entNo {FK)
propertyNo {PK, FK)
propertyNo {FK}
...
0.•
o.:
...
LeasedBy
1..1
1..1
Takes
PropertyForRent
1..*
propertyNo {PK}
1..1
0..100
ownerNo {FK}
staffNo {FK)
branchNo
{FK}
PlacedIn
·f·..
...i
11.*
'I'
POwns 0..1
BOwr1s
0..1
o.:
PrivateOwner
Bus r1essOwner
Advert
ownerNo
{PK}
ownerNo
{PK}
propertyNo {PK. FK}
newspaperName {PK. FK}
dateAdvert
{PK}
... 1
..*
Displays
1..1
Newspaper
newspaperName {PK}
Garnbar 2. 6 Logical
Data Design
(Cormolly
&
Begg, 2005, hal.
489)
 |