If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Identifying the Main Objects and Classes

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-17-07, 12:27
DeanoX DeanoX is offline
Registered User
 
Join Date: Jul 2007
Posts: 3
Identifying the Main Objects and Classes

Not sure where to post but would someone be able to help me identify the Main Objects and Classes from the bellow system? I'm trying to get into this sort of thing as I find it interesting, A friend of mine provided me with this and asked me to give it a go to get used to it.

Quote:
System - Doctors Surgery

Patient Record System
- Name and Address of each Patient
- Their first choice doctor
- A list of each visit to the surgery (with date) and type of ailment
- A list of each out call
- Any drugs prescribed

For each doctor the system should record
- Name and Address
- Surgery hours
- On call hours (for outcalls)
- List of outcalls made (and to whom)

The surgery administrator should be able to list currently available doctors, patients waiting for attention. Drugs prescribed per doctor (or per patient) and patient visits (including prescriptions and ailments)

He/She should be able to add/remove doctors/patients. Alter surgery/outcall hours, and latest visits.
Oh and thanks for any help, It'll be very appreciated.
Reply With Quote
  #2 (permalink)  
Old 07-17-07, 13:22
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
And your "friend" can't help you?
When is your homework assignment due?
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #3 (permalink)  
Old 07-17-07, 13:34
DeanoX DeanoX is offline
Registered User
 
Join Date: Jul 2007
Posts: 3
Haha, No my "friend" can't help me unfortuantly. I like how you could tell it was an assignment, Not that it wasn't obvious.

It's due in for August 17th.
Reply With Quote
  #4 (permalink)  
Old 07-17-07, 14:04
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
Ha ha. You lie to people and then expect them to do your work for you?
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #5 (permalink)  
Old 07-17-07, 14:14
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
we are good at recognizing homework because we see it all the time

the only way you're going to get any sort of meaningful response from us is after you've put in the effort yourself

the more work you put into the assignment, the more likely we are to comment on it

no effort on your part means a simple "well, good luck" from us

deal?
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #6 (permalink)  
Old 07-17-07, 14:28
DeanoX DeanoX is offline
Registered User
 
Join Date: Jul 2007
Posts: 3
Quote:
Originally Posted by blindman
Ha ha. You lie to people and then expect them to do your work for you?
Well I apologise.

Quote:
Originally Posted by r937
we are good at recognizing homework because we see it all the time

the only way you're going to get any sort of meaningful response from us is after you've put in the effort yourself

the more work you put into the assignment, the more likely we are to comment on it

no effort on your part means a simple "well, good luck" from us

deal?
Deal.

I wasn't expecting you too do everything or anything, Just some general guidelines and some help was what I was aiming for.

Anyway, I've been trying to identify the objects in classes. The list is probably wrong mind haha.

Objects:
Patient Name
Patient Address
Patient's Doctor
Patients date of visit to surgery & Ailment - (Or should these be split?)
Patients Outcalls
Drugs prescribed

Doctors Name
Doctors Address
Surgery Hours
Doctos On Call hours
Out calls made and to whom

Providing thats right, I will have to break this list down into the main objects and classes?
Reply With Quote
  #7 (permalink)  
Old 07-17-07, 16:42
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
PatientName and PatientAddress are not objects. They are relations, and thus attributes of a Patient object.
Ditto for all of the others.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On