[AccessD] Virtual library management database

Marty,
many thanks for sharing that resource!
Ervin
----- Original Message ----- 
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, January 23, 2006 7:01 PM
Subject: Re: [AccessD] Virtual library management database


> Have a look at the the data models here
> http://www.databaseanswers.org/data_models/
> This one seperates books by format
> http://www.databaseanswers.org/data_models/bookstore_and_warehouses/index.htm
> I would have each entity into its own table unless there is some
> commonality.
>
> Ervin Brindza wrote:
>
>><second attempt>
>>I was asked to do some voluntary work for some community. I need some 
>>ideas in designing a virtual library management database. The database 
>>will manage various matherial for amatheur folk dancers, mostly with their 
>>home made videos and sound matherial, books, magazines, video tapes, 
>>CDs(with many short video films), DVD discs, sound recordings(LP discs, 
>>sound casettes etc.) etc.
>>So there are two types of entities: "simple"entity(e.g. books or DVD discs 
>>with one film) and "complex" (e.g. magazines with articles of various 
>>category, CD or DVD discs with more than one video film). The last entity 
>>need a main table in a 1 to many relationship with the "sub" table, but 
>>the first will have nothing on many side, if I put all of them into these 
>>two tables.
>>For books and DVD discs are important: Title, Author and Category
>>For video tapes and sound cassettes are important(for each short film): 
>>Order No., Name of the film(or song), Lenghth, Category
>>For magazines(for each article): Title, Author and Category
>>The main goal of the system is to search on category, so when the user 
>>"ask" the system for e.g. Irish step to get all the book, videos, books, 
>>articles in one report.
>>So, my question is: is it clever to put all those various types of 
>>entities into one table(and connected table) or to separate each type of 
>>entity into own table.
>>Many thanks for suggestions,
>>    Ervin
>>
>>
>
> -- 
> Marty Connelly
> Victoria, B.C.
> Canada
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com