Home » SQL & PL/SQL » SQL & PL/SQL » another design issue - suggestion needed
another design issue - suggestion needed [message #208399] Sun, 10 December 2006 06:04 Go to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member

i am designing a database in mysql...mysql or oracle, the
design concepts are same

i have come to a few conclusions, can anyone please go thru
the doc (very small one...) and suggest me if i am right?
give me better suggestions?

thanks

  • Attachment: doubt.doc
    (Size: 25.50KB, Downloaded 124 times)
Re: another design issue - suggestion needed [message #208422 is a reply to message #208399] Sun, 10 December 2006 15:56 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm sorry, but I'm not opening potentially dangerous files (these include .doc and .xls ones) from an unknown source. Could you, perhaps, post text part of this document as a message text, and attach a model as a .jpg file?
Re: another design issue - suggestion needed [message #208461 is a reply to message #208399] Mon, 11 December 2006 00:12 Go to previous message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
there you go



We have to store information about students . (mentally challenged)
It is common information like name, medical history(family history,by birth or post birth),date of birth,diagnosis,mother toungue, gender,previous assessment(date,details,place /who assessed it,tests administered)
And Goals – goals for the student, has 1)current baseline(summary of assessment),
Short term goals(quaterly), long term goals(yearly), recommendations,(targets)
Staff – 1) staff for assessment 2) staff responsible for attending the student
Now there are CATEGORIES or stages for any student..
1) GROSS / FINE MOTOR (WHEN THE KID IS SMALL) (PHYSIOTHERIPST)
2) PERCEPTUAL / COGNITION (SE, OT)
3) COMMUNICATION / LANGUAGE (ST)
4) SOCIAL EMOTIONAL INTERACTION (SE)
5) SELF CARE / ADL
These are several conditions or categories each kid goes thru,…SE, OT are the kind of doctors involved who take care of each kind of situation.
Now, each kid can fall into more than one category…(many to many)
Now the most important thing….each CATEGORY has separate “things”, I call it
Attributes..that describe about them…
Each category has a separate Assessment form, I was given assessment form for the first Category, so there are separate attributesˇ WE HAVE TO CAPTURE THESE ASSESSMENTS INTO DATABASE.
ˇ THERE ARE SEPARATE GOALS FOR EACH CATEGORY
If STUDENT AND CATEGORY are entities, since there is many to many..
I thought, let there be a separate entity for each category…

If we have a student table (Student_id,Name…….pk is student_id)
And another table CATEGORY1_GROSS(id, student_id,category_id,category_name(one of the categories listed above), gait, muscle tone…etc, foreign key is student_id, pk is id, which is some autonumber) foreign key is student_id referring to student table.

Similarly, we have another table CATEGORY2_PERCEP(id,student_id,category_id,category_name,characteristic1, ….)

So the idea is, obviously one student cannot be entered twice in category1_gross table
So this would be one to many….
Like that 5 category tables with student_id as foreign key to student table,
And an id column in each table, which could be a primary key and auto increment



Previous Topic: Mapping column names into variables
Next Topic: How to write Linefeed Symbol (L above F) via UTL_FILE on VMS?
Goto Forum:
  


Current Time: Fri Dec 09 21:36:07 CST 2016

Total time taken to generate the page: 0.10787 seconds