SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    Patience... bronze trophy solidcodes's Avatar
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    911
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    My DataBase Model ?

    Hi guys,

    What can you say about the relationships of my database model,
    LMS-DataBase-Model-ver2.jpg

    Please disregard the datatypes, I'm only interested to hear from you guys regarding the relationships of the tables.
    For example on 'Classes' table It is a FK on 'Parts' and 'Media' tables is this fine?
    One parent table two children tables is this okay.

    Also any improvements you can suggest like the look-up table or junction table.
    Or flaws that you will notice?

    Thanks in advance.
    I Love coding...
    Don't click this link.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,014
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by solidcodes View Post
    For example on 'Classes' table It is a FK on 'Parts' and 'Media' tables is this fine?
    One parent table two children tables is this okay.
    yes, it's absolutely fine

    i was surprised that classes and lessons have related media, but the media are not related to the class parts
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    Patience... bronze trophy solidcodes's Avatar
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    911
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    @r937
    Parts is just a temporary folder...
    I Love coding...
    Don't click this link.

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,014
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    a temporary folder???
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    Patience... bronze trophy solidcodes's Avatar
    Join Date
    Jul 2006
    Location
    Philippines
    Posts
    911
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    It's a folder as a table.
    The rest are true tables.

    Or perhaps the right term for that is lookup table?
    I Love coding...
    Don't click this link.


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
  •