DataBase Design Help

Thread Solved

Join Date: Aug 2008
Posts: 1,162
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 138
dickersonka dickersonka is offline Offline
Veteran Poster

Re: DataBase Design Help

 
0
  #11
Oct 30th, 2008
I will help, not do assignments, what specific pieces are you having trouble with?

Also what is background and skills in the volunteers table?
One more, where did the relationships table go? ClientChild table means only children and not other relationships? Client table has a next of kin column, what is this?
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
Join Date: Oct 2008
Posts: 15
Reputation: xman12 is an unknown quantity at this point 
Solved Threads: 0
xman12 xman12 is offline Offline
Newbie Poster

Re: DataBase Design Help

 
0
  #12
Oct 30th, 2008
I deleted the background and skills attributes
The next of kin is the person to be informed just in there is any problems. Now i completed the ERD MODEL i need help with idenfying potential fan traps. i identify the client entity as the entity that is most likely to have a fan traps
Reply With Quote Quick reply to this message  
Join Date: Aug 2008
Posts: 1,162
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 138
dickersonka dickersonka is offline Offline
Veteran Poster

Re: DataBase Design Help

 
0
  #13
Oct 30th, 2008
i agree, would also add clientpets to bookings / volunteers
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
Join Date: Oct 2008
Posts: 15
Reputation: xman12 is an unknown quantity at this point 
Solved Threads: 0
xman12 xman12 is offline Offline
Newbie Poster

Re: DataBase Design Help

 
0
  #14
Nov 8th, 2008
Next Stage is covert the relational model into object oriented shema

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)
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:




Views: 1465 | Replies: 13
Thread Tools Search this Thread



Tag cloud for Database Design
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC