On Mon, 8 Dec 2008 23:46:01 -0800, Mystified
<Mystified@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
If some of those fields are required if Critical=True, you would be
better off with a second table with a 1:1 relation with the first one.
If the fields are not required, or if there are sensible defaults in
case Critical=False, I would KISS and keep everything in one table.
-Tom.
Microsoft Access MVP
I need guidance on my database design:
I have a table that lists out several tasks in field 1, and includes about 7
other fields of information on the task.
Some of these tasks are "Critical". If a task is critical, I need about 10
more fields with data on the task.
Am I better off storing this info in 2 tables, or one? It is possible for a
task that is currently not critical, to later become critical.
I need a way to be able to easily keep track of and update this data. Any
ideas?
Updating table ... I need guidance on my database design:... I have a table that lists out several tasks in field 1, ... Am I better off storing this info in 2 tables, ... (microsoft.public.access.tablesdbdesign)
Re: Concatenate and Null Values -- Features ... Hernandez' Database Design for Mere Mortals, which I will be acquiring as ... It is a unique number, so I could make it the PK, but I would be storing... needs a two-field FK; in the third case I have one PK ... but arguably some redundancy in the date. ... (microsoft.public.access.reports)
Re: Concatenate and Null Values -- Features ... every table should have an autonumber primary key and it is not a good idea to use meaningful data for relationships. ... I am aware of Michael Hernandez' Database Design for Mere Mortals, which I will be acquiring as soon as I get organized enough to order it. ... I could either add a PK field, combine two fields into a PK, or just go ahead and store 07-01, etc. ... So I ask myself if storing part of the date like that is less redundant than adding a field just so I can avoid storing part of the date. ... (microsoft.public.access.reports)
Re: Pixel-Stained Technopeasant Wretches, Unite! ... message, clearing the whole list, storing the message, and storing just ... I can also move them into different folders (it stores received and sent ... I don't know how many incoming numbers mine stores,... I *do* know I can clear those lists in ... (rec.arts.sf.composition)
Re: I need help with very complex query ...David Haynes wrote: ... into another table which lists all the contact lists, ... you can have SQL ignore the private fields on the end. ... > database design and the capabilities of the SQL language. ... (comp.lang.php)
