Needs Help In Making Database

Please see the detail of tables with fields in SQL server 2000.

·TableStudent .Table Good Qualities
( It is a list of Students) (It is a list of Good Qualities)
1-Student Id (P.Key)1- Serial No. (P. Key)
2-Student Name 2- Good Quality

· Table Bad Qualities .Table Future Plans
(It is a list of Bad Qualities) (It is a list of Plans)
1-Serial No. (P. Key) 1- Serial No. (P. Key)
2-Bad Quality 2- Future Plans

·Table-Personality
1-Student Name/ID
2-Good Qualities
3-Bad Qualities
4-Future Plans

Data will store in Personality table like that

Student IDG.Q.No B.Q.NoF.P.No
101 3 2 1
101 4 5 NUll
101 8 Null Null
202 4 8 9
202Null 3 1

Required ResultNow I have to generate a report of One student and
sometimes of many students comprising of their Name, G.qualities, Bad
Qualities and Future Plan. To generate report User input will be only
student id.

I Need help in making relationship of these tables as well as in
Making a Query. Any suggestion to get the required result. Specially
please look at the Personality Table because I do not understand
Primary key for it. Should I just include the Serial No. as Primary
key.
Please make necessary changes to get the required result.

I shall be really thankful to you for your kind favor.