I want to make software for one of local store. I am making table of transaction which have attributes
tran_id, name ,mob_no, date_of_sale, date_of_payment(multivalued),product(multi),quantity(multi),total_amount,unpaid
as buyer can pay in installments date_of_payment is mulivalued. Is there any other better way for this? How to implement multivalued attribute in mysql?
"multivalued" fields as you call them break First Normal Form (1NF). You need a 1-m table for this. Read up at http://web.archive.org/web/20110606025027/http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html and http://www.databasedev.co.uk/database_normalization_process.html and they will begin to show you how to start designing a database.