<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Database Design
»
Design Ideas and Questions
»
Urgent normalisation help please!
Urgent normalisation help please!
Rate Topic
Display Mode
Topic Options
Author
Message
msanchez7
msanchez7
Posted Saturday, January 05, 2013 5:04 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 06, 2013 4:22 PM
Points: 4,
Visits: 8
Post #1403216
J Livingston SQL
J Livingston SQL
Posted Saturday, January 05, 2013 10:02 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Today @ 10:41 AM
Points: 1,452,
Visits: 14,227
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 !
__________________________________________________________________
Post #1403245
msanchez7
msanchez7
Posted Saturday, January 05, 2013 10:07 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 06, 2013 4:22 PM
Points: 4,
Visits: 8
I just wrote the data As an example. Do you mean staff no: etc...?
Post #1403247
J Livingston SQL
J Livingston SQL
Posted Saturday, January 05, 2013 10:15 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Today @ 10:41 AM
Points: 1,452,
Visits: 14,227
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 !
__________________________________________________________________
Post #1403249
msanchez7
msanchez7
Posted Saturday, January 05, 2013 10:23 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 06, 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
J Livingston SQL
J Livingston SQL
Posted Saturday, January 05, 2013 10:28 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Today @ 10:41 AM
Points: 1,452,
Visits: 14,227
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 !
__________________________________________________________________
Post #1403255
msanchez7
msanchez7
Posted Saturday, January 05, 2013 10:36 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 06, 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
Grant Fritchey
Grant Fritchey
Posted Monday, January 07, 2013 4:44 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 12:19 PM
Points: 13,371,
Visits: 25,144
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
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Posted Tuesday, January 22, 2013 7:02 PM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:03 AM
Points: 2,979,
Visits: 4,389
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
