Database Conceptual & Logical Design (Work Done)

[Malcolm Toni]

hello,
this is what i have done so far..
The conceptual design
_____________ ________________
| | _______________ | |
|Revenue | | | |Rate |
|____________| |vehcile |1..1 ________________
| | _______________ | |
| |_______charged____| | | |
| | 0..*| |___________ | |
| | | | | | |
| | | | | | |
_____________ _______________ | _________________
0..* 0..* | |has sub-classes |
| |(Govt, diplomate |___owns______
| |& Other) |
____________ofThe_________| | |
| | |
0..* | | |1..1
________|_____ ________________| ________|________
| | | _______________ |vehcileOwner |
|invoice | | | | | |
|____________| | |staff | ________________
| | | _______________ | |
| | | | | settlesInvoice| |
| | | | | | |
| | parksToSreet | | | |
| | | | | | |
_____________ | _______________ _________________
1..* | | has sub-classes |0..*
issues | (cashier & Attendant) |
| ________| 1..1| |1..1 |
|____________________________________| | |
_____________manages____________________| |
| |
|1..1 ________paysFor_________________|
________|_____ |0..* ________________
| | ________|_______ | |
|Street | | | |Vendor |
|____________| |Ticket | ________________
| | _______________ | |
| | | | | |
| | | |_____soldBy_____| |
| | | |0..* 0..* | |
| | | | | |
_____________ _______________ _________________
has sub-classes
(City Council & Ministry of
Works)



This is the conceptual design i have come up with so far. The Rate is still playing me. It will be much easier to design the logical design if i can get the conceptual design right. Help needed.

Thanks