Peggy and I are in the beginning stages of setting up a multimedia library database under SQL Server to catalog our books, DVDs, CDs, etc. We did this once for just our library about 15 years ago, when our collection was only about three or four thousand books, using DataEase. Now we want to catalog everything -- and use it as a chance for me to get a good amount of SQL Server experience.
The question I have for the community at large is this: Although I'm currently designing a db to handle all our different media, it would make things much faster if we were to use a pre-existing design. Does anyone know of an open/free library database schema capable of handling multiple media types that we could make use of?
Thanks!
-- Bob
---------
Then the horns kicked in...
...and my shoes began to squeak.
The question I have for the community at large is this: Although I'm currently designing a db to handle all our different media, it would make things much faster if we were to use a pre-existing design. Does anyone know of an open/free library database schema capable of handling multiple media types that we could make use of?
Thanks!
-- Bob
---------
Then the horns kicked in...
...and my shoes began to squeak.