SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Urgent normalisation help please!


Urgent normalisation help please!

Author
Message
msanchez7
msanchez7
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 8
:-)
J Livingston SQL
J Livingston SQL
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12039 Visits: 37520
msanchez7 (1/5/2013)
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:



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 ?

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

msanchez7
msanchez7
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 8
I just wrote the data As an example. Do you mean staff no: etc...?
J Livingston SQL
J Livingston SQL
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12039 Visits: 37520
msanchez7 (1/5/2013)
I just wrote the data As an example. Do you mean staff no: etc...?


appreciate this is in "Design Ideas and Qs"...but have you created any SQL tables yet?
...or we still in design thought stage?

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

msanchez7
msanchez7
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 8
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 :-)
J Livingston SQL
J Livingston SQL
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12039 Visits: 37520
msanchez7 (1/5/2013)
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 :-)


ok...seems you are new to all this funky SQL stuff :-)

the following series may help you start

http://www.sqlservercentral.com/stairway/72400/

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

msanchez7
msanchez7
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 8
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.
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)

Group: General Forum Members
Points: 97521 Visits: 33014
I 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.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14007 Visits: 4639
msanchez7 (1/5/2013)
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.


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 http://pkirs.utep.edu/cis4365/Tutorials/Database%20Design/Normalization/tutorial%206.00400.htm for a starting point.

Hope this helps.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search