To danaanderson:

I confess I am doing normalization to the death. :crying:

I know I am a beginner and I think I need to learn too about normalization as well.

I have a little background in normalization and I thought that on my data model, I had achieved this, but as usual, professional people like you all have seen so many flaws in my data model. I need to read more.

To Sean Lange:

Yes Sir, I noticed the 1:1 relationship when I tried to simulate a sample data in a scratch paper. What I really want is 1-to-many relationship (i.e., a student can/may have a permanent, mailing and/or an e-mail address). Thank you for the suggestion, it seems much better from my former [font="Courier New"]ADDRESS[/font] table, I will do your suggestion Sir. 🙂

To michael vessey:

Thank you Sir. I guess/realize that it will be much better to do your "sentence describing objects" first, before creating tables on SQL Server. I was just really excited to do stuffs in MS SQL Server. I was a total beginner to SQL Server, now I know how to use the program little by little, but I know to myself that I have still a very long, long way to go. :laugh:

I will keep on studying, experimenting and asking questions. 😀

Warm regards,

Mark Squall