Click here to Skip to main content
Sign Up to vote bad
good
See more: SqlServer
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 10 Jul '12 - 7:28

Comments
Wes Aday - 10 Jul '12 - 14:17
"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:41
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
ryanb31 - 11 Jul '12 - 14:57
You need to write code to do it? What specific question do you have?
Kaushik Saha from Kolkata,India - 17 Jul '12 - 5:56
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)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 425
1 OriginalGriff 315
2 Slacker007 240
3 Dave Kreskowiak 212
4 Aarti Meswania 210
0 Sergey Alexandrovich Kryukov 8,893
1 OriginalGriff 7,134
2 CPallini 3,678
3 Rohan Leuva 3,036
4 Maciej Los 2,428


Advertise | Privacy | Mobile
Web02 | 2.6.130516.1 | Last Updated 10 Jul 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid