Ervin Brindza
viner at EUnet.yu
Tue Jan 24 07:45:02 CST 2006
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