Hi all, I am Chaitanya, I am working on a project and is in design stage now. The application is all about tracking the attendance details of a school. Obviously schools have staff and students. We are supposed to track the attendance details for both actors.
We first deploy a huge RFID based network, which consists of many RFIDs and RFID switches. All these are in a LAN.
There is a possibility that a student/staff can swipe his/her card from any where in the school.
We created two different tables, one for student and one for faculty. Because both have different attributes. But both the actors perform the same operation, that is swiping the cards and enrolling attendance (in,out) for a day.
We created a table named attendance whose structure is like this
trans_id BIGINT PRIMARY KEY
pid BIGINT //this column has to refer both student and staff table
Can anyone tell me how to model such kind of relations? Thank you all in advance.