Re: Data Model

Gene,

Thanks for your feedback. I agree with your assesment, and if I was writing something that needed a more robust addressing system I probably would have designed this accordingly. Fortunately for me court buildings do not get nearly as complex as other address/building scenarios. In a way, I know the building table could just as easily been named an address table, and different addresses could have the same building name, but be different rows...but that's getting of on a tangent for my scenario, and what I have now will suffice and keep me open to work arounds within future requests for the website.

In the future though, for my own sake, I would appreciate more feedback than just "Look out". If "Look out" refers to your reasoning above such as different addresses in the same building, then please ignore my last statement. If it refers to something else I might not be seeing, then please, by all means fill me in. I like to expand my mind.

>Be careful. That feeling of power might be self-electrocution.

Who would have ever thought sticking a spoon in a power outlet could be so bad. :-(

_at_Everyone

The civil courts section is up. The folks move into their brand new building Monday. Not bad for two weeks on the job in goverment work :)  For you web tech junkies it's running under the .Net framework 2.0. The site master template is a powerful tool I must say.

The main site and how it's always been can be found here:

-http://www.justex.net

-Navigate to the courts section ( http://www.justex.net/court.htm )

-Click "Civil" to go to my redesigned area that is pulling content from my db. I also provided tools so the staff can add pages to "their" area and edit them with a WYSIWYG rich text editor. That stuff is in the bottom section of each judges page, just under the "Court Staff" section. Click each link to see the "AMAZING" stuff people come up with.

http://www.justex.net/new_civil/Courts/Civil/CivilCourts.aspx

-View the other courts, such as criminal, to see the old layout if you haven't seen it before.

Thanks everyone, and by all means view my data model and rip it to shreds. It's post number 14 in this thread.

Thanks,

Matt

P.S. Found the other developer who had it all in one table is very competent and understands normalization quite well. <-- Not being sarcastic. Received on Sun Mar 12 2006 - 00:51:47 CET