Results 1 to 13 of 13
  1. #1
    Join Date
    Apr 2012
    Posts
    4

    e-library schema

    i need a sample database schema of e-library...

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    What kind of e-library? What do you need in terms of features/functions?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Done:
    Code:
    create table ELibrary (ELibraryName varchar(100) primary key clustered)
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Apr 2012
    Posts
    4
    e-library (books,serial, video streaming, etc)

    i just need the features and functions..im having hard time working with entities and their relationship..

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    well thats all part of the learning process
    first you have to understand what you are trying to model or represent
    then you have the foundations to build the system
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Apr 2012
    Posts
    4

    e-library

    i need some additional info with my e-library database schema

    entity set
    student
    library
    staff
    media
    book
    audio(book, music)
    video(streaming,recording)
    website internet resources
    subject_category
    title
    author
    publisher


    i need some further explantion

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    if you need further explanation talk to your tutor/teacher and or colleagues

    in the mean time bone up on normalisation
    Fundamentals of Relational Database Design -- r937.com

    The Relational Data Model, Normalisation and effective Database Design

    are pretty good starting points, although not as good as paying attention to class
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Quote Originally Posted by firstnormal View Post
    i need some additional info with my e-library database schema

    entity set
    student
    library
    staff
    media
    book
    audio(book, music)
    video(streaming,recording)
    website internet resources
    subject_category
    title
    author
    publisher


    i need some further explantion
    Do you need someone to explain all of these items for you, or do you have specific questions? I don't understand the Entity Set, but I could explain the rest of these items for you.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  9. #9
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by Pat Phelan View Post
    Do you need someone to explain all of these items for you, or do you have specific questions? I don't understand the Entity Set, but I could explain the rest of these items for you.

    -PatP
    Yikes! Just don't put all those attributes in one table. Too de-normalized.

    Edit: I meant not normalized.
    Last edited by corncrowe; 04-13-12 at 20:15.

  10. #10
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Quote Originally Posted by corncrowe View Post
    Yikes! Just don't put all those attributes in one table. Too normalized.
    How about using a GUID for the PK, then an XML column for the rest? That resolves your objection to the normalization nicely I think!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  11. #11
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Quote Originally Posted by corncrowe View Post
    Yikes! Just don't put all those attributes in one table. Too normalized.
    Besides that, you could explain the items slightly differently but just as well as I could. So there!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  12. #12
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by Pat Phelan View Post
    Besides that, you could explain the items slightly differently but just as well as I could. So there!

    -PatP
    I don't think so. I am an old student who continues to learn from folks like yourself.

  13. #13
    Join Date
    Apr 2012
    Posts
    4
    those are entity sets i split it with tables. the problem is the relationship set among those entity set above....
    tnx for the link....


    if you have an example of ERD of e-library maybe i can compare...

Posting Permissions

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