Reply to thread

Message: <blockquote data-quote="විල්සන් මාමා" data-source="post: 19417291" data-attributes="member: 397789">Machan comma separated values thiyena table ekak normalized naha ne. First normal form ekema oka gana kiyala thiyenawa ne. Oka harima simple. Item kiyala table ekak thiyenawa. Thawa Person kiyala table ekak thiyenawa. Person kiyana table eke foreign key eka thamai Item table eke primary key eka.ExampleItem (item_id(PK),item_name)Person(person_id(PK),person_name,item_id(FK))EDITEDUda thiyena solution eka 1:M ekak. Habai uba passe dala tibba reply eka dakkama therune oka M:M kiyalaMenna mehema karapanItem (item_id(PK),item_name)Person(person_id(PK),person_name)Item_Person(item_id,person_id)Item_Person kiyala aluth table ekak hadanna wenawa. Eke thiyenne composite primary key ekak. Mehema wunama ekama item eka kihipa denek hadanna puluwan. E wagema eka person kenekta item 1k ho godak hadanna puluwan</blockquote>

Top Bottom