Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Pakistan, Karachi
    Posts
    22

    Question Unanswered: PC booking system

    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.

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    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.

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •