Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL 1st 2nd & 3rd Normal Form
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Jason Moore
1st 2nd & 3rd Normal Form
0 Answer(s)      2 years and 6 months ago
Posted in : SQL


print("code sample");Im a intermediate App& Web Programmer and a novie when it comes to data base, just had the basic sql 101 in college. I really want to understand the normal forms and am having difficulty with it since not all info on the net seem to agree. OK my main confusion is 1st NF No duplicate row Info. So the Normal ex: Not having somthing like address 1, address 2, Address 3 and so on in 1 table, But i ask couldnt you also havve duplicate data just in say, a members table with Fname so you tbl make grow into

{(PK)Id    Fname
 -----------------------  
0          Frank           
1          Bob             
2          Frank}

This produces many members with same first name(redundant data) so buy the NF rule ,Should i create new Names table an tie them with Names Table (PK) Name.Id--> Mem Table (Fk) Names.Id


Advertisement
View Answers

Related Tutorials/Questions & Answers:
1st 2nd & 3rd Normal Form
1st 2nd & 3rd Normal Form  print("code sample");Im a intermediate... confusion is 1st NF No duplicate row Info. So the Normal ex: Not having somthing like... sql 101 in college. I really want to understand the normal forms and am having
how to pass values from 2nd page tp 3rd page....
how to pass values from 2nd page tp 3rd page....  Hi, How to pass values from 2nd page to 3rd page..... here are my programs(not exactly correct...;body> <form method="post" action="login1.jsp"> <p><b>Login
Advertisements
Third Normal Form (1NF)
Third Normal Form (1NF)       Third Normal Form (1NF) The Third Normal Form has one more... the requirements of the second normal form.       B
Second Normal Form (2NF)
Second Normal Form (2NF)       Second Normal Form (2NF) The concept of remove the delicacy of data comes in the Second Normal Form (2NF). A.  It should meet all
box +15 2nd
box +15 2nd  how to fix this? import java.util.*; class Example{ public static void main(String args[]){ Random r=new Random(); int x[][]=new int[3][3]; boolean b1=false,b2=false; L1:while(b2==false
3rd&5th highest salary from a table
3rd&5th highest salary from a table  how we get 3rd highest and 5th highest salary from a table
which should be learned 1st, either servlets or jsp??
which should be learned 1st, either servlets or jsp??  which should be learned 1st either servlets or jsp??? help me out asap plz
Multipage form
Multipage form  I have a multipage form in php with 2 pages wnhen i submit the form data from both the pages should go in database how should i pass teh data from 1st page to 2nd page and then put the entire form data in mysql
Regarding My 3rd Question in Java - Swing AWT
Regarding My 3rd Question in Java  sir in Netbeans By default JTable Columns will appear Horizontal like Title1 Title2 Title3 Title4 in below these our data will appear so my question that is there any method
Normal Distribution java program?
Normal Distribution java program?  For my last assignment i have to ace this to raise my grade and i wanna perfect it so i need help from anybody who knows java: Write a program to tabulate the cumulative normal distribution F(z
Disable next month at every first 3rd days Calendar.
Disable next month at every first 3rd days Calendar.  Hi all, may I know how to fix my calendar. I want it to disable next month at every first 3rd...) { alert('You can`t choose date every 3rd days at the next month
preview and saving an application form
page i got general details from users,in 2nd page i got family details,in 3rd...preview and saving an application form   i have developed an application form, which is to be filled by the user.That application form is big in size
preview and saving an application form
page i got general details from users,in 2nd page i got family details,in 3rd...preview and saving an application form   i have developed an application form, which is to be filled by the user.That application form is big in size
Difference between Normal Insert and BLOB insert
Difference between Normal Insert and BLOB insert  I have sql database... values(1,'Libraries\Pictures\Lotus.jpg') and 2nd row as INSERT INTO [dbo... = System.Drawing.Image.FromStream(returnValue);** // Error if id=1 used i.e normal insert bytearray
PLZ Need some help on the 2nd part of this question...Someone please help !!!!
PLZ Need some help on the 2nd part of this question...Someone please help !!!!  write an application that displays a menue of three items in a restaurant as follows: 1.Cheeseburger 4.99 2.Pepsi 2.00 3.Chips 0.75 prompt the user
form
form   Can I prevent a form from being submitted again
How to ask a questions to you clearly with normal english?
How to ask a questions to you clearly with normal english?  hi, i want to know how should or can i may ask a question. send me some format or explain me clearly because i am new in this web site.   Post your question
Catching Normal Exceptions
Catching Normal Exceptions       The exceptions that are generated by methods are referred to as normal exceptions.  We have already learned that to catch an exception
How to convert java BigDecimal to normal byte array not 2 s complement
How to convert java BigDecimal to normal byte array not 2 s complement  How to convert java BigDecimal to normal byte array not 2 s complement
actually i want to knw how to include an google page inside a tab(suppose in 2nd tab).can any one help me....
how to include an google page inside a tab(suppose in 2nd tab).can any one help me....  actually i want to knw how to include an google page inside a tab(suppose in 2nd tab).can any one help me
how to access the messagresource.proprties filevalues in normal class file using struts - Struts
how to access the messagresource.proprties filevalues in normal class file using struts  i want to access the below username and password in class file.Plz help to me. messageresource.properties files username=system
Fix table's column's name row(1st row of the table) so that it does not move up when the table is scrolled up to view more rows below
Fix table's column's name row(1st row of the table) so that it does not move up when the table is scrolled up to view more rows below  HI, I have... the table rows up to view more underlying data, then, the table's header (1st row
The Normal Forms
and starts from the first normal form till the fifth normal form. In this tutorial, we will only discussed about the most essential normal form such as 1NF, 2NF and 3NF. First Normal Form (1NF) The first normal form (1NF) sets the very crucial
struts form reset
struts form reset  thing is my button s working fine for first time when i run application.But in the second time it s not working (instead it takes value which i hav selected 1st time) Guys.im struck on this for past 2 days
about form
about form  how to dynamically increase the textbox in the 2nd form when i gave any value in textbox of form1 . if i gave 5 in the textbox of form1 , totally 5textbox have to be created in form2.   import javax.swing.
How to include Two multi rows, one with a file Upload and another with normal fields, have problem while including both
How to include Two multi rows, one with a file Upload and another with normal fields, have problem while including both  How to include Two multi rows, one with a file Upload and another with normal fields, have problem while
How to create a zip file and how to compare zip size with normal text file
How to create a zip file and how to compare zip size with normal text file  Hi, how are you?I hope you are fine.I want program like how to create zip.../ZipCreateExample.shtml but when i verified the size of zip and normal file,normal file is showing
Using a image for Browse button instead of normal html Browse button for Uploading files from a JSP - JSP-Servlet
Using a image for Browse button instead of normal html Browse button for Uploading files from a JSP  I am using the following code snippet.... Is it not possible to use a image instead of normal html Browse button for uploading files
form validation
form validation  how the form validation is done in jsf form using javaScript
print a form of *
print a form of *   * *** ***** ******* ********* ******* ***** *** *   Post the format properly
 

 

 

DMCA.com