SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    Community Advisor ULTiMATE's Avatar
    Join Date
    Aug 2003
    Location
    Bristol, United Kingdom
    Posts
    2,160
    Mentioned
    46 Post(s)
    Tagged
    0 Thread(s)

    URGENT: Relationship Woes

    Basically, to cut a long story short. I've been given a design for a database, and I've been asked to put it together. Only problem is, after fixing the crap they've put in before, I am stumped on where to put relationships to certain pieces of data. This is how it's been laid out so far, but it looks a bit off.

    Student Details is the main area where student information is put. Everything else leads off on different forms, but is linked to the students. For example, Dojo Details is license details for the chosen student, and Gradings is grading info for the student.

    Do I need to create new fields, and how should I alter the relationships?


  2. #2
    SitePoint Member JBelthoff's Avatar
    Join Date
    Jun 2006
    Location
    Bantam, CT
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by ULTiMATE
    Do I need to create new fields, and how should I alter the relationships?
    What you have looks OK to me. But now knowing what the application is supposed to do with that data, it's hard to give any advice on whether you need any new fields or not.
    JB
    Hosts Station is a Professional Asp Hosting Provider
    Position SEO: SEO Services at an affordable price
    As for myself... I do this for fun!

  3. #3
    SitePoint Member
    Join Date
    Oct 2003
    Location
    WI, USA
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    First of all, wouldn't Member_ID be another primary key in tblCompetitions & tblGradings.

  4. #4
    Wadge! F4nat1c's Avatar
    Join Date
    Oct 2005
    Location
    South Wales, UK
    Posts
    1,134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There aren't any relationships set there. There's 2 relationship types

    - One to Many
    - Many to Many

    If a relationship between 2 tables has been created properly, there should be:

    - A 1 on one end of the line, and an infinity sign on the other end
    - 2 infinity signs

    There are no signs on any of your lines, so there are no successfull relationships there.

    You can't have a field set to primary key in more than one table, like you have with Dojo_Details, Students Details and Courses. (The field in bold is the primary key field).
    OMFG SitePoint ROXORZ TEH BIG ONE111!
    Wish you were invisible?


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
  •