Click here to Skip to main content
11,490,007 members (67,020 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
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 8:28am
Comments
Wes Aday at 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 at 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
ryanb31 at 11-Jul-12 14:57pm
   
You need to write code to do it? What specific question do you have?
Kaushik Saha from Kolkata,India at 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)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 595
1 Andy Lanng 233
2 OriginalGriff 213
3 Maciej Los 170
4 _duDE_ 141
0 Sergey Alexandrovich Kryukov 9,608
1 OriginalGriff 8,475
2 Sascha Lefèvre 3,419
3 Maciej Los 3,106
4 Richard Deeming 2,370


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 10 Jul 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100