need help designing a database for PC booking system ? I have 3 labs and students should be able to book a PC 1 week or even 1 Day before if they want to work extra. Database should store student Login time and info. (Well this is some programming technique) but I need to have some fields so that data should be dumped into database so as to keep a record if the student has consumed his/her time or not.
Very Urgent a quick response will be highly appreciated.From that informaiton, I would reccomend three tables, (Labs, Students, and schedule) Possible design:
Labs
Labname
Location
...
Students
StudentPK
Firstname
Lastname
...
Schedule
ScheduleID
Labname
StudentPK
Date
Logintime
Logouttime
...
Probably more you could do but this should get you started, researching normalizaiton should help as well.
HTHsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment