[AccessD] On DB Bloat, Bad DB Design, and various

The only suggestion I could make was not store pictures in the DB.
Extracting them in chunk or using the faster stream mode was still slower
than storing the actual pictures, in a directory and then connecting them to
the form as needed.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Tuesday, May 25, 2004 7:51 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] On DB Bloat, Bad DB Design, and various


I'm just starting a new project and I'm in two minds about one aspect
of the database design.  Since this has been discussed so much in the
last few days, I thought I'd throw it in for discussion.

It's an Accomodation Register type thing for an organisation that has
lots of staff housing.

AccomodationUnits are children of Properties (Sometimes there will be
a house on a property, sometimes a block of several units, possibly
dormitory style with individual rooms etc)

The client wants to store difital photos.  Photos could be of a
particular unit or of the whole property. I will be storing the name
of the photo file and pulling the image as required from it's storage
location.

As I see it there are several possibilities including:

tblPhotos:
AccomUnit/PropertyID
AccomUnit/PropertyType
Filename.......etc

or

tblPhotos:
AccomUnitID
PropertyID
Filename.......etc
(only store ID for the appropriate Property Type)

or

tblAccomUnitPhotos:
AccomUnit
Filename.......etc

AND
tblPropertyPhotos:
PropertyID
Filename.......etc



Any comments/suggestions as to how far I should normalize <g> and
pros/cons of the various approaches - taking into account
establishing relationships between tables in the BE, maintaining
referential integrity, ease of data retrieval/maintenance in the FE?




--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System
Support.



--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com