Click here to Skip to main content
12,244,322 members (48,301 online)
Rate this:
 
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 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
ryanb31 11-Jul-12 14:57pm
   
You need to write code to do it? What specific question do you have?
   
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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 10 Jul 2012
Copyright © CodeProject, 1999-2016
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