Object-oriented database design
Please support our Database Design advertiser: Programming Forums
![]() |
•
•
Posts: 15
Reputation:
Solved Threads: 0
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)
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)
•
•
Posts: 1,157
Reputation:
Solved Threads: 133
please post this in your other post and close this one
Custom Application & Software Development
www.houseshark.net
www.houseshark.net
![]() |
Similar Threads
Other Threads in the Database Design Forum
- .Net Developer (Software Development Job Offers)
- Looking for a Senior DELPHI Developer (Software Development Job Offers)
- Sr. Java Developers Needed (Software Development Job Offers)
- Design Solution (Database Design)
- Help on General Best Practices for Table/Database Design (Database Design)
- what is object oriented???? (IT Professionals' Lounge)
- Connecting to a SQL Server Database using VB (VB.NET)
- Boundary Class and Broker Class (Computer Science)
Other Threads in the Database Design Forum
- Previous Thread: HELP figuring out a good 3rd year uni project title
- Next Thread: DataBase Design Help
•
•
•
•
Views: 545 | Replies: 1 | Currently Viewing: 1 (0 members and 1 guests)






Linear Mode