I have work in a high school and I am working on designing a database for a tardy calculator. It will be Internet based. I am not real sure how I am going to set up the database though. So I though I would throw it out there and get suggestions.
StuID (this is a number assigned to them by the district)Primary Key
FistPeriod (the actual times would go here also)
This would be hosted on our web server. One person would input the information. When a student is tardy the person would click on their name and then click on the correct class period. Then this would be stored for the year. After getting five tardies they then would go to detention. Not sure how to flag that though. Any suggestions would be great. I am not programmer, just learning out of need. Please advise. Thank you.