Can anyone verify My data model

yaragalla_murali

New member
Local time
Tomorrow, 02:46
Joined
Jan 13, 2008
Messages
6
Hi I have designed a database for a small organization. It is a ver small database. can any one verify and tell me the mistakes in my design. It hardly takes 20 min for the people like you. This is my first step in designing. I am attaching the zip file which contains dbm file and business requirements. Complete physical data model is there.

especially in "category_tests" table i feel that i have done some thing wrong.

Thanking you all.
 

Attachments

I took a quick look and you have a normalization issue in test table. You have field normal1 to normal4. You should have sepate table for these.
 
I do agree. I thought of it but then I thought it should be fine so kept like that.
Now after your suggestion I will change it.
Thanks for that.

I will be waiting for more suggestions. Any suggestions on "category_tests" table. Please do help me in my initial steps. Thanking you.
 

Users who are viewing this thread

Back
Top Bottom