<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Liam Clarke wrote:
<blockquote cite="midf2ff2d05021703277633c607@mail.gmail.com"
type="cite">
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">Anyway, why don't you tell us more about what you are trying to do and we can give better suggestions.
Kent
</pre>
</blockquote>
<pre wrap=""><!---->
Database organised -
Client details ---- Jobs ---- Finances
| |
| Costs
Resolutions
It will go by client#/ and job# to reference various bits.
</pre>
</blockquote>
Hi Liam,<br>
<br>
I am not a proficient Python nor OO programmer but I know my way around
databases and SQL. I believe that before you can fully jump into coding
or even writing SQL queries for your project, you need to get to know
relational databases lingo and what your subject refers to: DB Design.<br>
<br>
Basically you need to organize your data into different tables or
"entities" and then build relationships around them. You need ot
identify how each entity relates to each other. Database designers
usually refer to this as an entity-relationship diagram.<br>
<br>
For example, your entity (table) Clients describes certain attributes
(fields) each one has. The kind of relationship the entity Client can
have to the entity Jobs is that "one Client can hold one or more Jobs"
(or in this case "none to many jobs"). So you define the relationship
between entity Clients and Jobs to be a "none or one-to-many"
relationship.<br>
<br>
Additionally, there can be "one-to-one" relationships or
"many-to-many" (e.g. People to Jobs). I do not know the functionality
you want to get from your application, but that will take you to define
the kind of relationships you can build from there.<br>
<br>
Schematically this has its own representation, but I prefer to direct
you to some of the links I just found through googling a little bit.
For example, look into:<br>
<br>
<a class="moz-txt-link-freetext" href="http://miner.chem.purdue.edu/Lectures/Lecture23.pdf">http://miner.chem.purdue.edu/Lectures/Lecture23.pdf</a><br>
which is very high level. It does not describe the details in the
lecture, but helps as a first hand intro<br>
<br>
<a class="moz-txt-link-freetext" href="http://r937.com/relational.html">http://r937.com/relational.html</a><br>
More desccriptive, particularly an explanation of what normalization
is, and how to approach the database design process.<br>
<br>
Anybody have any other references or suggestions relating to the
subject?<br>
<br>
About Python, I assume (experts please jump in) you will build a class
for each entity, and any record of the entity or table becomes a class
instance.<br>
<br>
I hope this helps.<br>
<br>
Victor Bouffier<br>
Finance Manager<br>
<a class="moz-txt-link-abbreviated" href="http://www.grupoandersons.com">www.grupoandersons.com</a><br>
<br>
</body>
</html>