Monday, July 11, 2011

How to create a third normal form for a T-SQL database?

I have to create a database in T-SQL. The tables have to be in third normal form. I'm a newbie to this and I sort of get the whole form normalizing thing, but I am struggling with the specific columns I have to create the tables. It is for a music database program. The following columns needs to be in the tables: Artist_name, Track_name, Genre, Rating, Release_year. Could someone please help me putting these columns correctly in tables so it meets the requirements for third normal Form(3NF)?

No comments:

Post a Comment