Click here to Skip to main content
16,016,580 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hai friends
i have been creating tables for sending attendance report and other event information to parents and some event information for staff.

table1:student:
It contain details with student_id as primary key
table2:parents:
It contain detail with contact_id as primary key
table3:staff
It contain details with staff_id as primary key
table4:attandance
It contain details with student_id as foreign key
please give me some suggestion about further table creation for sending sms automatically whenever student enter their attandance through finger print device and creating and sending other message through manually.
thank you advance
Posted
Comments
[no name] 10-Jul-12 14:17pm    
"suggestion about further table creation"... is going to depend entirely on your project requirements and since no one but you know what those requirements are, what exactly do you expect us to suggest to you?
baskaran chellasamy 11-Jul-12 0:41am    
thanks for reply.how can i could able to send sms automatically when student enter their attendance using fingerprint device and please give sample database tables for sending sms to parents
ZurdoDev 11-Jul-12 14:57pm    
You need to write code to do it? What specific question do you have?
Kaushik Saha from Kolkata,India 17-Jul-12 5:56am    
how do you design parent table primary key as contact_id

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900