InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 18:30:11 GMT20http://www.sqlservercentral.com/Forums/Topic1403216-373-1.aspx[quote][b]msanchez7 (1/5/2013)[/b][hr]Yeah this is my first time dealing with SQL, thank you for your support, it's good to know that there are people who help as much as they can.[/quote]Is it the problem that this is your first time dealing with SQL (as in SQL Server) or is it that this is your first time attempting to do data modeling?if the issue is the RDBMS then check Books Online, it comes with SQL Server for free.If the issue is data modeling and you are required to go 3NF please check [url]http://pkirs.utep.edu/cis4365/Tutorials/Database%20Design/Normalization/tutorial%206.00400.htm[/url] for a starting point.Hope this helps.Tue, 22 Jan 2013 19:02:27 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1403216-373-1.aspxI don't suppose you still have the original question? Anyone else searching for similar help can benefit from the question and answer. Editing it away makes it more difficult for people.Mon, 07 Jan 2013 04:44:45 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1403216-373-1.aspxYeah this is my first time dealing with SQL, thank you for your support, it's good to know that there are people who help as much as they can.Sat, 05 Jan 2013 10:36:51 GMTmsanchez7http://www.sqlservercentral.com/Forums/Topic1403216-373-1.aspx[quote][b]msanchez7 (1/5/2013)[/b][hr]Yeah that's right, I've been trying to figure it out for the past month and I got stressed! That's why I need help :-)[/quote]ok...seems you are new to all this funky SQL stuff :-)the following series may help you start[u][b][url]http://www.sqlservercentral.com/stairway/72400/[/url][/b][/u]Sat, 05 Jan 2013 10:28:03 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic1403216-373-1.aspxYeah that's right, I've been trying to figure it out for the past month and I got stressed! That's why I need help :-)Sat, 05 Jan 2013 10:23:27 GMTmsanchez7http://www.sqlservercentral.com/Forums/Topic1403216-373-1.aspx[quote][b]msanchez7 (1/5/2013)[/b][hr]I just wrote the data As an example. Do you mean staff no: etc...?[/quote]appreciate this is in "Design Ideas and Qs"...but have you created any SQL tables yet?...or we still in design thought stage?Sat, 05 Jan 2013 10:15:46 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic1403216-373-1.aspxI just wrote the data As an example. Do you mean staff no: etc...?Sat, 05 Jan 2013 10:07:27 GMTmsanchez7http://www.sqlservercentral.com/Forums/Topic1403216-373-1.aspx[quote][b]msanchez7 (1/5/2013)[/b][hr]I am so confused I have to normalise these form 1 and 2 together, 2 and 4 together and the rest separately into 3nf. Can somebody help. On the first 2 forms I also have to include the branch, managed by and telephone.these are the forms:[/quote]rather than giving us details of the "forms"....are you able to provide the details of the underlying data tables and queries that are being used to populate your forms ?Sat, 05 Jan 2013 10:02:27 GMTJ Livingston SQLhttp://www.sqlservercentral.com/Forums/Topic1403216-373-1.aspx:-)Sat, 05 Jan 2013 05:04:42 GMTmsanchez7