[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