Re: Learning Question

"Lee Osborne" <osbornelee_at_hotmail.com> wrote in message news:989483808.7431.0.nnrp-14.c2de1f0e_at_news.demon.co.uk...
| Hi Todd,
|
| Thanks for replying. Regarding the data structures I was referring to
 the
| database model.
|
| Also are there any www links for ER modelling I can look at?
|
| Thanks,
|
| Lee.

Have a look at SHELLY CASHMAN SERIES?
under the link Systems Analysis and Design. I have the book, and this site is an extension of it which covers these things you are looking for.
http://www.scsite.com/

HTH
Chris Val

| "Todd Gillespie" <toddg_at_linux127.ma.utexas.edu> wrote in message
| news:9csfml$det$1_at_geraldo.cc.utexas.edu...
| > In comp.databases Lee Osborne <osbornelee_at_hotmail.com> wrote:
| > : and MySQL. I would like to learn how to create good solid data
 structures
| > : for any system I produce. I understand the best way to do this is
| > : normalization and Entity-Relationship modelling? My company is
 asking
 me to
| > : produce some complicated work and I'm struggling!
| >
| > ER modeling is a process of designing a database schema that
 elegantly
| > fits your biz process model. Normalization is a set of rules to
 reduce
| > the complexity/redundancy of said model; which usually reduces bugs
 and
| > increases performance.
| >
| > Where are these data structures you are producing? Are you talking
 about
| > structures in PHP functions, or the database model, or what? I'm at
 a
| > loss to help you until you more thoroughly define your problem
 space.
| >
| > : 1) I'm looking for a good all-round book/s for developing SQL
 applications
| > : on the web, covering database modelling, etc. Could anyone
 recommend
 any?
| >
| > On the web:
| > http://www.arsdigita.com/books/sql/
| > and
| > http://www.arsdigita.com/books/panda/
| >
| > I strongly recommend both books. Caveat #1: MySQL doesn't implement
 parts
| > of the SQL used in the first book; you might not be able to use
 examples
| > directly. Caveat #2: the author has strong opinions on technical
| > subjects. In person he's quite moderate, but when writing he is
 very
| > direct as to what works and what doesn't.
| >
| > On dead trees:
| > Teorey's 'Database Modeling and Design, 3rd Ed' is a good book on
| > modeling.
| >
| > : 2) What is the best way to document my web applications?
| >
| > I'll get back to you on that.
| >
| > : Any information would be very much appreciated,
| >
| > HTH.
|
|
  Received on Mon May 14 2001 - 16:01:53 CEST