Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Urgent normalisation help please! Expand / Collapse
Author
Message
Posted Saturday, January 5, 2013 5:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 6, 2013 4:22 PM
Points: 4, Visits: 8
Post #1403216
Posted Saturday, January 5, 2013 10:02 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:51 AM
Points: 1,912, Visits: 19,380
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
Post #1403245
Posted Saturday, January 5, 2013 10:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 6, 2013 4:22 PM
Points: 4, Visits: 8
I just wrote the data As an example. Do you mean staff no: etc...?
Post #1403247
Posted Saturday, January 5, 2013 10:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:51 AM
Points: 1,912, Visits: 19,380
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
Post #1403249
Posted Saturday, January 5, 2013 10:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 6, 2013 4:22 PM
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
Post #1403252
Posted Saturday, January 5, 2013 10:28 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:51 AM
Points: 1,912, Visits: 19,380
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
Post #1403255
Posted Saturday, January 5, 2013 10:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 6, 2013 4:22 PM
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.
Post #1403257
Posted Monday, January 7, 2013 4:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:46 AM
Points: 13,752, Visits: 28,148
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1403541
Posted Tuesday, January 22, 2013 7:02 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
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.
Post #1410310
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse