i am using SSMS to create and execute my queries..am not sure if that answers your question.

I found out the solution... I already had records in the student table n these records were violating the constraint...the query worked fine after I deleted the records.

is it...

thank u all for your help...i have tried to create a relationship but have run into an error. please help. thank you.

k i have created two tables as shown in...

thank you...so much

no it is not homework. like i said, it the first time, thats why i did not know where to start.

Each student will have multiple classes(subjects) and each...

is Sp1 meant for all editions...since mine is Professional edition...?

i came across this . can u kindly verify this

"SQLManagementStudio_x64_ENU.exe is NOT SSMS! Confusing filename, huh? It includes only the basic management tools (e.g., Configuration Manager) and support...

thanks for the reply...i was able to install Ms sql server 2008 express R2...but it has only Configuration tools but no Management Studio. i downloaded "SQLManagementStudio_x86_ENU.exe" and "SQLManagementStudio_x64_ENU.exe" and...