Already a member?

Minty

what do u do with tables having many to many relaionship.
because in the erd we make another table of containing the primary keys of both the tables.

its confussinnnn me how we change those tables in inf

vikas1234

nice short tutorial on normalization ... I just would like to add that that too much normalization make lots of table so you should always go for optimal normalization ...

pradeep

Very right said Vikas!

satyedra pal

Normalization is the process of organizing data into tables in such a way that the results of using the database are always unambiguous or
the process of organizing data to minimize redundancy. Normalization divides a database into two or more tables and links relationships between the tables
Normalization is done in two step that puts data into tabular form by removing redundent data and then removes duplicated data from the relational tables.
In normalization we do:
Avoiding repetitive entries.
Increased speed and flexibility of queries.
Reducing required space of storage for data by removing redundent data.

It has following normal form:
1NF(Normal form)
2NF
2NF
3NF
BCNF
4NF
5NF

smithshn

When data records are in large form then there is required normalization.
Normalization is a process of removing data which is repeated and filtering data to identify a value as uniquely in a table.
In RDBMS there is different method for normalization of the records which is shown as below:
(1) 1st Normal Form
(2) 2nd Normal Form
(3) 3rd Normal Form
(4) 4th Normal Form
(5) 5th Normal Form
(6) BCNF - Boyce Codd Normal Form- In this normal form you have follow the 32 rules of it.

seomanju

Thanks for this detail.

seomanju

Data models are the techniques to handle our databases.

sneha123

Quote:

Originally Posted by pradeep
Functional Dependency

Definition: A functional dependency occurs when one attribute in a relation uniquely determines another attribute. This can be written A -> B which would be the same as stating "B is functionally dependent upon A."
Examples: In a table listing employee characteristics including Social Security Number (SSN) and name, it can be said that name is functionally dependent upon SSN (or SSN -> name) because an employee's name can be uniquely determined from their SSN. However, the reverse statement (name -> SSN) is not true because more than one employee can have the same name but different SSNs.

Transitive Dependency

Definition: A type of functional dependency in which the value in a non-key field is determined by the value in another non-key field and that field is not a candidate key

Hello Pradeep,,,,sneha here,,its excellent job,,,,,Thanks lot for share with us,,,,,,,,,

samantha1230

Thanks for letting me know about Normalization, I just heard this but now come to know what exactly it is.

Minty Newbie Member
30Oct2007,20:14	#11
	what do u do with tables having many to many relaionship. because in the erd we make another table of containing the primary keys of both the tables. its confussinnnn me how we change those tables in inf

vikas1234 Go4Expert Member
11Sep2008,13:19	#12
	nice short tutorial on normalization ... I just would like to add that that too much normalization make lots of table so you should always go for optimal normalization ...

pradeep Team Leader
11Sep2008,14:17	#13
	Very right said Vikas!

satyedra pal Contributor
20Apr2010,15:26	#14
	Normalization is the process of organizing data into tables in such a way that the results of using the database are always unambiguous or the process of organizing data to minimize redundancy. Normalization divides a database into two or more tables and links relationships between the tables Normalization is done in two step that puts data into tabular form by removing redundent data and then removes duplicated data from the relational tables. In normalization we do: Avoiding repetitive entries. Increased speed and flexibility of queries. Reducing required space of storage for data by removing redundent data. It has following normal form: 1NF(Normal form) 2NF 2NF 3NF BCNF 4NF 5NF

smithshn Light Poster
6May2010,00:39	#15
	When data records are in large form then there is required normalization. Normalization is a process of removing data which is repeated and filtering data to identify a value as uniquely in a table. In RDBMS there is different method for normalization of the records which is shown as below: (1) 1st Normal Form (2) 2nd Normal Form (3) 3rd Normal Form (4) 4th Normal Form (5) 5th Normal Form (6) BCNF - Boyce Codd Normal Form- In this normal form you have follow the 32 rules of it.

Already a member?

Not a member yet?

Search Go4Expert

Latest Forum Topics

Find Us On Facebook

Latest Articles

seomanju Banned
3Dec2010,16:40	#16
	Thanks for this detail.

seomanju Banned
3Dec2010,16:42	#17
	Data models are the techniques to handle our databases.

sneha123 Go4Expert Member
13Dec2010,16:30	#18
	Quote: Originally Posted by pradeep Functional Dependency Definition: A functional dependency occurs when one attribute in a relation uniquely determines another attribute. This can be written A -> B which would be the same as stating "B is functionally dependent upon A." Examples: In a table listing employee characteristics including Social Security Number (SSN) and name, it can be said that name is functionally dependent upon SSN (or SSN -> name) because an employee's name can be uniquely determined from their SSN. However, the reverse statement (name -> SSN) is not true because more than one employee can have the same name but different SSNs. Transitive Dependency Definition: A type of functional dependency in which the value in a non-key field is determined by the value in another non-key field and that field is not a candidate key Hello Pradeep,,,,sneha here,,its excellent job,,,,,Thanks lot for share with us,,,,,,,,,

samantha1230 Banned
28Mar2012,17:23	#19
	Thanks for letting me know about Normalization, I just heard this but now come to know what exactly it is.

User Name:		Save
Password