#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    2
    Rep Power
    0

    Thinking to create a table


    for a school
    there is like 30 teacher and like 1000 students.
    When a studen has problem (like Courses,Accounting, Accommodation, Family, etc) goes to a teacher or advisor that tell it and it will be recorden by the teacher by small forms.
    Teachers will login the system by username and passwords.
    And enter these informations :
    ------------------------------------------------
    Departman: Computer Engineering
    Elecrical Engineering
    Industrial Engineering
    id:
    Name:
    Email :
    Phone:
    Nationality:
    gender: Male/ Female
    ----------------------------------------------------
    Advisor : Yes/No
    Confidental : Yes/No
    ---------------------------------------------------
    subject: Courses
    Accounting
    Accommodation
    Family
    Details
    -----------------------------------------

    After these there shold be also statistic are also gender/ id number/ department/ advisor or not / nationality / about subject ( like % 20 courses , % 40 Accounting, %10 family, %30 Accommodation)

    İ am thinking the tables like .Please can you tell me its corect or i should add drop something here...
    ----------------------
    tblTeacher
    id
    name
    username
    departmant

    tblStudent
    id
    name
    studentNo
    Email :
    Phone:
    Nationality:
    gender
    department

    tblConversation
    id
    teacherName
    studentNo
    advisor
    confidental
    subject
    details
    time
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,150
    Rep Power
    4274
    yes, your initial design looks fine

    now create the tables and load up some sample data
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2013
    Posts
    2
    Rep Power
    0
    1 think to ask, if i wanna do a admin panel to add user to login here where should be the admin informations. like admin username and password information , should be another table ?
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,150
    Rep Power
    4274
    Originally Posted by whoiswiseman
    should be another table ?
    yes
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo spyfu logo threadwatch logo seochat tools logo