Professional Web Applications Themes

Tutor and Tutees website system - ASP Database

I'm starting to develop a system to link Tutors with Tutees. The goal is to match tutors with tutees on their likes and schedule (MTWRFSU, morning, afternoon, and evening) Below is the proposed database schema for the tables. Could you please let me know if you think it would work for that purpose or do you know of a better way or schema? I'm using SQL Server and ASP. tutor( tutorID int identity, tutorFName varchar(20), tutorLName varchar(20), tutorCity varchar(20), tutorState char(2) tutorZip varchar(10) tutorStatus char(1) ) Tutee( tuteeID int identity, tuteeFName varchar(20), tuteeLName varchar(20), tuteeCity varchar(20), tuteeState char(2) tuteeZip varchar(10) ...

  1. #1

    Default Tutor and Tutees website system

    I'm starting to develop a system to link Tutors with
    Tutees. The goal is to match tutors with tutees on their
    likes and schedule (MTWRFSU, morning, afternoon, and
    evening)

    Below is the proposed database schema for the tables.
    Could you please let me know if you think it would work
    for that purpose or do you know of a better way or
    schema? I'm using SQL Server and ASP.

    tutor(
    tutorID int identity,
    tutorFName varchar(20),
    tutorLName varchar(20),
    tutorCity varchar(20),
    tutorState char(2)
    tutorZip varchar(10)
    tutorStatus char(1)
    )


    Tutee(
    tuteeID int identity,
    tuteeFName varchar(20),
    tuteeLName varchar(20),
    tuteeCity varchar(20),
    tuteeState char(2)
    tuteeZip varchar(10)
    tuteeStatus char(1)
    )


    Likes(
    LikesID int
    LikesDesc varchar(200)
    Status char(1)
    )

    TutorLikes(
    TutorID int,
    LikesID int
    )

    TuteeLikes(
    TuteeID int,
    LikesID int
    )

    TutorSchedule(
    TutorID int identity,
    Monday bit,
    Tuesay bit ,
    Wednesday bit,
    THursday bit,
    Friday bit,
    Saturday bit,
    Sunday bit,
    Morning bit,
    Afternoon bit,
    Evening bit
    )

    TuteeSchedule (
    TutorID int identity,
    Monday bit,
    Tuesay bit ,
    Wednesday bit,
    THursday bit,
    Friday bit,
    Saturday bit,
    Sunday bit,
    Morning bit,
    Afternoon bit,
    Evening bit
    )

    One problem I have is how do I find matches, that is, how
    do I find Tutors and Tutees who have the same interest and
    same schedule? Any and all help would be appreciated with
    design and all. Then when I want to
    Mike Guest

  2. #2

    Default Re: Tutor and Tutees website system

    Mike,

    While I am not privy to requirements, a better idea would be to create the
    schedules something like:

    TutorSchedule
    (
    TutorID,
    DayID)

    instead of using Bits for Sun-Sat. This would definitely make it flexible
    while writing queries to match up who is available, etc.

    --
    Manohar Kamath
    Editor, .netWire
    www.dotnetwire.com


    "Mike Williams" <microsoft.com> wrote in message
    news:2e6d01c4a7c5$9ccef020$gbl... 


    Manohar Guest

  3. #3

    Default Re: Tutor and Tutees website system

    What would the Day table contain? Day, Hours, etc?

    Thanks

     
    would be to create the 
    make it flexible 
    wrote in message [/ref]
    their [/ref]
    how [/ref]
    and [/ref]
    with 
    >
    >
    >.
    >[/ref]
    Mike Guest

Similar Threads

  1. Free PHP CMS System for family website?
    By Dahl in forum PHP Development
    Replies: 2
    Last Post: December 7th, 08:25 AM
  2. Need Flash ASP Data Tutor
    By redtiger in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: March 6th, 08:21 AM
  3. Replies: 1
    Last Post: May 8th, 06:00 PM
  4. Windows XP Tutor
    By RebeccaB in forum Windows XP/2000/ME
    Replies: 0
    Last Post: July 6th, 02:03 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139