Question !

[Shamal3001]

This is DB related question . One teacher wage has multiple payments . Eg: Sameera has 30,000 salary. institute is paying 10,000 * 3 times . so i represent it like this . which is correct one .

https://prnt.sc/8fi8jkuD3PjH , https://prnt.sc/IlMLXii-dxTM

 

[Shamal3001]

Bump

---

Payments walata ID kiyana Eka foreign key ekak widiyata neweida ganne ?
------ Post added on Mar 14, 2022 at 7:59 AM

wage_id eka machan `foreign key` .

 

[Nanosudha]

https://prnt.sc/IlMLXii-dxTM this one, no need to add all other ids such as teacherid, subjectid etc.. you are asking a One-to-many relationships.
https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help/one-to-many-relationships.html

 

[Jack_Sparrow]

wage_id FK widiyata dapu eka ok
eth ayi teacher, subject, grade, batch ids tikasth FK widiyata damme Payments table eke?
ewa okkoma ganna puluwanne "Wage" table and "Payments" table join kalama

 

[Anonymous_Abstract]

2nd one. with teacher(1) to payment(M)

 

[B.Chat]

wage_id eka machan `foreign key` .

Matakat na owa hariyata 1 to many ekaka many Pattata 1patte primary key Eka Enna oni සීන් එකක් tiyenawa matakai wage