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  |
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 472 times)
|
|
|
|
|
|
| Re: another design issue - suggestion needed [message #208461 is a reply to message #208399] |
Mon, 11 December 2006 00:12  |
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
|
|
|
|
Goto Forum:
Current Time: Wed Dec 11 22:42:55 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
