Dear Vince,
The are many things to be said about designing a database. First of all, you
should determine the purpouse of that database. Depending of these, you can
start determining the structure of your database (tables, fields,
relationships). Of course, nothing its perfect from the begining, so finally
you should refine your database. Besides, you should use pivot tables - I
believe they are the key to a succesfull database desing process. I am using
Microsoft Access. Currently I am building a database for our large type
collection (soon it will be ready), so if you encounter any problem in
designing your database, please feel free to contact me.
Mihai
***************************************************
Dr. Mihai Stanescu
Senior curator (Lepidoptera)
"Grigore Antipa" National Museum of Natural History
Department of Collections
Sos. Kiseleff no. 1
Bucharest 1
RO-79744
ROMANIA
Phone: (+40) 021 312.88.63; (+40) 021 312.88.26
Fax: (+40) 021 312.88.63; (+40) 021 312.88.86
E-mail: [log in to unmask]
URL: http://www.antipa.ro/specialisti/mishoustanescu.html
***************************************************
----- Original Message -----
From: "Vince Bayard" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Monday, October 14, 2002 11:38 PM
Subject: Hello posting
> Our museum is developing a database to help in the design and
implementation
> of a new permanent exhibit (natural history). The complexity of designing
a
> database to cover all thing necessary while developing an exhibit is quite
> daunting. Are there any other museums that have developed a database
> alongside an exhibit? Can you share information about pitfalls and
> windfalls?
> Thanks
>
> Sincerely,
> Vince Bayard
> Fossil Mysteries Database Manager
> San Diego Natural History Museum
> "Your Nature Connection"
>
> Website: www.sdnhm.org
> Email: [log in to unmask]
>
> Mailing Address: P.O. Box 121390, San Diego, CA 92112-1390, USA
> Street Address: 1788 El Prado, San Diego, CA 92101
>
> =========================================================
> Important Subscriber Information:
>
> The Museum-L FAQ file is located at
http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed
information about the listserv commands by sending a one line e-mail message
to [log in to unmask] . The body of the message should read "help"
(without the quotes).
>
> If you decide to leave Museum-L, please send a one line e-mail message to
[log in to unmask] . The body of the message should read "Signoff
Museum-L" (without the quotes).
=========================================================
Important Subscriber Information:
The Museum-L FAQ file is located at http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed information about the listserv commands by sending a one line e-mail message to [log in to unmask] . The body of the message should read "help" (without the quotes).
If you decide to leave Museum-L, please send a one line e-mail message to [log in to unmask] . The body of the message should read "Signoff Museum-L" (without the quotes).
|
