Object-oriented database design
 

I need help converting a relational model into an object-oriented database design in terms of classes, listing all attributes for each class together with their reference and collection data types.

Entities

Entity
Booking
Attributes
bookID (Pk)
volServID (Fk)
clientID (Fk)
Date-Req,
Hours_Req

Entity
Client
Attributes
ClientNo (Pk)
ClientName
ClientType
ClientAddress
ClientTel
NextOfKin

Entity
Volunteers
Attributes
volNo (Pk)
volName
volTel
volAddress
AreaofSpeciality

Entity
Volunteer_Services
Attributes
Vol_ServNo
serviceNo (Fk)
volNo (Fk)
track

Entity
Service
Attributes
serviceNo (Pk)
serviceName

Entity
Client_Pet
Attributes
PetNo (Pk)
PetName
Description
Client_No(FK)

Entity
Client_Child
Attributes
ChildNo (Pk)
ChuldName
DateOfBirth
Sex
Client_No(FK)

Re: Object-oriented database design
 

please post this in your other post and close this one