about normalization

[sweating.bullet]

hi guys,


can any one tell me in which circmstacnes we dont have to normalize the tables in database (reasons also)

thnx

[expertno.1]

please be more specific and clairfy it ...can't get what u wanna say ....




Thanks
Regards.....
Expertno.1

[T159]

its related to database table redundancy removal and transitive dependencies maintaining referential integrity.

Here is your answer(commonly accessible information will be better left without normalization as normalization increases number pf joins ):
http://www.25hoursaday.com/weblog/2007/08/03/WhenNotToNormalizeYourSQLDatabase.aspx

guess reading this might help:
http://en.wikipedia.org/wiki/Database_normalization

Normalization is a must, unless u are creating some simple application.
Consider this tutorial(worth reading):
http://phlonx.com/resources/nf3/

[sweating.bullet]

please be more specific and clairfy it ...can't get what u wanna say ....




Thanks
Regards.....
Expertno.1

hi what i want to say is that i made 3 tables and i know the circustances in which we dont do the normalization.

[T159]

lol..you havent got ur answer.

I finished reading them all, huh..now a lot clearer understanding abt normalization.

[sweating.bullet]

hi,

sorry for that i just missed the words while i was typing the reply, what i want to say that i m looking 4 a good reason for nor normalizing the tables pls suggest i try to send u the table structure


book table

Field
Type
Null
Default
id
varchar(9)
Yes

title
varchar(50)
Yes

au1_first_name
varchar(20)
Yes

au1_second_name
varchar(20)
Yes

au1_initial
char(1)
Yes
NULL
au2_first_name
varchar(20)
Yes
NULL
au2_second_name
varchar(20)
Yes
NULL
au2_initial
char(1)
Yes
NULL
section
varchar(20)
Yes

issued
char(3)
Yes
NO
issued_on
date
Yes
0000-00-00
renewal_on
date
Yes
0000-00-00
borrower_id
varchar(10)
Yes
NULL
fine
float(4,2)
Yes
0.00
reserved
varchar(9)
Yes
NULL
comments
varchar(30)
Yes
NULL

stats table

Field
Type
Null
Default
date
date
Yes
0000-00-00
tbi
int(4)
Yes
NULL
tbr
int(4)
Yes
NULL
total_fine
float(4,2)
Yes
NULL


book table

Field
Type
Null
Default
roll_no
varchar(10)
Yes

password
varchar(32)
Yes

first_name
varchar(20)
Yes

second_name
varchar(20)
Yes

initial
char(1)
Yes

sex
char(1)
Yes

email
varchar(50)
Yes

books_issued
text
Yes
NULL
reserved
text
Yes
NULL