database - Pledges table normalize -


i have table , don't know how normalize.

1st table name, address, landline no., mobile no., e-mail ad, amount, , registration number https://docs.google.com/file/d/0b99tebyt30n2ddvlvhv4du1yrfe/edit

and in second table monthly pledges. https://docs.google.com/file/d/0b99tebyt30n2tvh4c1dmltfyows/edit

persontable   personid int primary key   name varchar(50)   addresss varchar(50)   etc.  pledgetable   pledgeid int primary key,   personid int foreign key references persontable(personid)   pledgedate datetime   pledgeamount decimal(10,2) 

Comments

Popular posts from this blog

java - How to specify maven bin in eclipse maven plugin? -

single sign on - Logging into Plone site with credentials passed through HTTP -

php - Why does AJAX not process login form? -