10 replies to this topic

[seristee]

can someone who knows normalization please help me normalize this table. i am working on a small java based program and need this table normalized

[ATTACH]4478[/ATTACH]
attached is a copy of the table i need normalized
#thanks for your support

Attached Files

•  1975.pdf   53.73K   43 downloads

[WingedPanther]

Let's start with a different question: why is it NOT normalized?

[seristee]

ok i was told that if i want to add say multiple pdf files to the floorplan field without the second file overwriting the first i would have to normalize it to 3nf

[WingedPanther]

Nothing in your table indicates you would want to do such a thing, however. This backs us up to another question: what do you want to store in your database?

[seristee]

reference id<varchar> primarykey eg 1989-001
firstname<varchar>
lastname<varchar>
propertytitle<varchar>
address<varchar>
district<varchar>
floorplan<blob>
reportsubmitted<blob>
businesstitle<varchar>
review<date>
request<blob>

[WingedPanther]

Unfortunately, a DDL doesn't tell me your intentions. I look at way to many databases with poor documentation.

[seristee]

i just want to continually update the database with the latest entries not overwriting the previous ones. say for example i have a reference id of 1989-001 i want to add another floorplan and report but i already have that data saved on the database. how can i add a new floor plan pdf without overwriting the previous one and say when i query the table i can get both the floor plans show returned ...
thanx for your responses.....

[WingedPanther]

Here's what you need to do:
Step 1) identify invariant data, the stuff that requires no history or recorded changes. That goes in your main table with an appropriate primary key.
Step 2) identify the FIRST block of data that does require history. Use the primary key from Step 1 as your foreign key, and add an element (date/time?) to finish of the primary key for this table.
Step 3) repeat step 2 as needed, realizing that any table you've defined so far could be a "parent table" for your new table.

[seristee]

oh k i think i understand say for example floorplan is a blob i can create a new table called plans create a field called planid and another field say called submittedplan. i can do that for all three blobs to start of with is taht what you talking about ??
thanks in advance....

[WingedPanther]

Exactly, but I'd also add a date field so you know when each plan was submitted and can easily retrieve the newest one.

[seristee]

yes what i did instead of the reference number being a date and number i separated them created a date field and a referencenumber field.i tried it in mysql but the tables dont automatically update. the parent table being reports. when i add new entries into it the parent table the rest of the tables stay the same nothing is updated.....

i have attached a table that i created using mysql workbench can someone please let me know wehre im goin wrong and how can i get all teh tables to update when i enter inforamtion into the fields


thanks for your response......

Attached Files

•  table.pdf   53.55K   15 downloads

Edited by seristee, 08 January 2012 - 03:59 PM.