Hackerspace" <lvl1@googlegroups.com>
Received: by 10.58.92.9 with SMTP id ci9mr2351811veb.40.1348834143724;
Fri, 28 Sep 2012 05:09:03 -0700 (PDT)
X-BeenThere: lvl1@googlegroups.com
Received: by 10.52.92.207 with SMTP id co15ls3145070vdb.5.gmail; Fri, 28 Sep
2012 05:09:02 -0700 (PDT)
Received: by 10.58.136.100 with SMTP id pz4mr2375642veb.34.1348834142301;
Fri, 28 Sep 2012 05:09:02 -0700 (PDT)
Received: by 10.58.136.100 with SMTP id pz4mr2375640veb.34.1348834142283;
Fri, 28 Sep 2012 05:09:02 -0700 (PDT)
Return-Path: <jdc...@gmail.com>
Received: from mail-vc0-f171.google.com (mail-vc0-f171.google.com [209.85.220.171])
by gmr-mx.google.com with ESMTPS id s13si494277vde.2.2012.09.28.05.09.02
(version=TLSv1/SSLv3 cipher=OTHER);
Fri, 28 Sep 2012 05:09:02 -0700 (PDT)
Received-SPF: pass (google.com: domain of jdc...@gmail.com designates 209.85.220.171 as permitted sender) client-ip=209.85.220.171;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of jdc...@gmail.com designates 209.85.220.171 as permitted sender) smtp.mail=jdc...@gmail.com; dkim=pass header...@gmail.com
Received: by vcmm18 with SMTP id m18so7417236vcm.16
for <lvl1@googlegroups.com>; Fri, 28 Sep 2012 05:09:02 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=20120113;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:content-type;
bh=RorUFJgUk8woqddGqEJ9pS5me+KMlIn5Zt3gG9+DBew=;
b=UU+c4xnNkuDk0Wp6koxH7KaL1UXSMHf34oBYsqMZo02wJk3X5QETnKsKStpfBT1wK1
SdqtjLLmEBmBxp3sgfVlfIdi3vwlYPpf8O3+Xamtv41BzLAx7tTE/HfRarp8QPFJfhAg
GRE5iWGp/ljZynsQde1Y+6RTjZ8m5XdJxJRxudcgIeunZN0oGDnbXcYamdUH1TlZR7HI
YYzak3gWXkKGDJ/mWKoSREikMDjT6P4LTZonfa4kiaeOxrHBB9CbNygtoJPNajk98r1E
GLZeqyLYawjJRDhdyWWnMQ5nLgQ6b/JeNfK6IIDRt61shadJr0OZXGI+56y+FIWm+YOi
geMw==
MIME-Version: 1.0
Received: by 10.52.96.167 with SMTP id dt7mr3272740vdb.118.1348834142165; Fri,
28 Sep 2012 05:09:02 -0700 (PDT)
Received: by 10.58.161.138 with HTTP; Fri, 28 Sep 2012 05:09:02 -0700 (PDT)
In-Reply-To: <CAKoqi78Tk_NB61BTSF-9AhzNJSzszqz7vb8LbHSsh19gOyr...@mail.gmail.com>
References: <CALRsrfNoCbbArayOhOEx9ZdBozfKcot28+xzioyC=KYxMzo...@mail.gmail.com>
<CALRsrfOjAJYNsHXFb8XN2drk4RvHb2pLB2AKV2UgMPAVDP0...@mail.gmail.com>
<CALo4-vyRtZNit_MYRqoWYRNVF-Z8-ARmUvZZ02Fde9kPDe_...@mail.gmail.com>
<CALRsrfPRNepcfGr=7P7=9WL7N1M1qZbetCYEVSkqSHuSnbB...@mail.gmail.com>
<CAKoqi78Tk_NB61BTSF-9AhzNJSzszqz7vb8LbHSsh19gOyr...@mail.gmail.com>
Date: Fri, 28 Sep 2012 08:09:02 -0400
Message-ID: <CALRsrfPM0GaVSEPEoiQbVkrgmbCE81yG3eP7Pq9J2e4P4w0...@mail.gmail.com>
Subject: Re: {LVL1} Looking for some very basic MySQL consulting (Paid Work)
From: Jonathan Clark <jdc...@gmail.com>
To: lvl1@googlegroups.com
Content-Type: multipart/alternative; boundary=20cf307d03dae79b4d04cac1ebcc
--20cf307d03dae79b4d04cac1ebcc
Content-Type: text/plain; charset=ISO-8859-1
Essobi,
I'm trying to figure out what fields could be normalized. After looking up
normalization I think I understand the concept, and I think the database is
structured according to that method, but I may not be fully understanding
normalization. Can you point out an example of whats not normalized?
On Thu, Sep 27, 2012 at 9:24 PM, Essobi <ess...@gmail.com> wrote:
> Normalizing. Some of those fields can be enums. Normalize if you need it
> to scale. Do input sanitation too. Lookup OWASP.
>
> -essobi
>
>
>
>
>
>
> On Thu, Sep 27, 2012 at 3:16 PM, Jonathan Clark <jdc...@gmail.com> wrote:
>
>> Brian,
>>
>> I like the concept of using single status and type tables for tables that
>> have the same status and type definitions. You wouldn't use the same table
>> to put ALL status definitions in though..right? Only when the fields
>> referencing the status values will share the same exact set of options?
>>
>> I definitely missed the adding of a data/time stamp for entries!
>>
>> I don't know what an n-tier database strategy is, but I know how to
>> start google-ing :) Thanks for the input!
>>
>>
>> On Thu, Sep 27, 2012 at 3:06 PM, Brian Wagner <br...@tegrasys.com> wrote:
>>
>>> I tend to create a single codes table for 'types' and 'statuses' and
>>> other lookup type codes. Then as you add functionality to your db, you can
>>> simply add another code instead of building another table. Also consider
>>> using an n-tier database strategy using a module that handles all database
>>> calls. You really do not want sql in your view code. Finally you might
>>> need a timestamp field in your tables if you worry about multiple
>>> people editing the same record at the same time. Most of the DB work I do
>>> is in Visual Basic and Sql Server but the concepts are the same. You may
>>> want to read up on Ruby on Rails. Good database strategy there. There is
>>> a lot to being a DBA and a good database programmer. Keep reading and ask
>>> me any questions. I have been in this game for 20+ years. Good luck.
>>>
>>> Brian
>>>
>>> On Thu, Sep 27, 2012 at 1:53 PM, Jonathan Clark <jdc...@gmail.com>wrote:
>>>
>>>> Thanks to everyone that's responded,
>>>>
>>>> At the moment I'm just creating the initial database and working on
>>>> some very simple pages to display and input data. I think I have the
>>>> database structured correctly but then again this is my first time creating
>>>> any type of database and I have less then 24 hours of experience, so I'm
>>>> sure there errors all over the place.
>>>>
>>>> Once I have got the majority of the database setup I am definitely
>>>> interested in any guidance related to the best way to display data and
>>>> create forms for data input. (I may also be able to pay someone to get the
>>>> initial web interface up and running).
>>>>
>>>> Here's a copy of the current database I've created and the relationship
>>>> diagram. If any of you database guys wanna take a look at it and let me
>>>> know if there's anything I'm doing horribly wrong, please feel free. I'll
>>>> take all the advice I can get. THANKS!
>>>>
>>>
>>>
>>
>
>
> --
> Essobi
>
--20cf307d03dae79b4d04cac1ebcc
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Essobi,<div><br></div><div>I'm trying to figure out what fields could b=
e normalized. After looking up normalization I think I understand the conce=
pt, and I think the database is structured according to that method, but I =
may not be fully understanding normalization. =A0Can you point out an examp=
le of whats not normalized?<br>
<br><div class=3D"gmail_quote">On Thu, Sep 27, 2012 at 9:24 PM, Essobi <spa=
n dir=3D"ltr"><<a href=3D"mailto:ess...@gmail.com" target=3D"_blank">ess=
o...@gmail.com</a>></span> wrote:<br><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Normalizing.=A0 Some of those fields can be enums.=A0 Normalize if you need=
it to scale.=A0 Do input sanitation too.=A0 Lookup OWASP.<br><br>-essobi<d=
iv class=3D"HOEnZb"><div class=3D"h5"><br><br><br><br><br><br><div class=3D=
"gmail_quote">
On Thu, Sep 27, 2012 at 3:16 PM, Jonathan Clark <span dir=3D"ltr"><<a hr=
ef=3D"mailto:jdc...@gmail.com" target=3D"_blank">jdc...@gmail.com</a>></=
span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">Brian,<div><br></div><div>I like the concept=
of using single status and type tables for tables that have the same statu=
s and type definitions. =A0You wouldn't use the same table to put ALL s=
tatus definitions in though..right? =A0Only when the fields referencing the=
status values will share the same exact set of options?</div>
<div><br></div><div>I=A0definitely missed the adding of a data/time stamp f=
or entries!</div><div><br></div><div>=A0I don't know what an n-tier dat=
abase=A0strategy=A0is, but I know how to start google-ing :) Thanks for the=
input!<div>
<div><br>
<br><div class=3D"gmail_quote">On Thu, Sep 27, 2012 at 3:06 PM, Brian Wagne=
r <span dir=3D"ltr"><<a href=3D"mailto:br...@tegrasys.com" target=3D"_bl=
ank">br...@tegrasys.com</a>></span> wrote:<br><blockquote class=3D"gmail=
_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:=
1ex">
I tend to create a single codes table for 'types' and 'statuses=
' and other lookup type codes. =A0Then as you add functionality to your=
db, you can simply add another code instead of building another table. =A0=
Also consider using an n-tier database strategy using a module that handles=
all database calls. =A0You really do not want sql in your view code. =A0Fi=
nally you might need a timestamp field in your tables if you worry about mu=
ltiple people=A0editing=A0the same record at the same time. =A0Most of the =
DB work I do is in Visual Basic and Sql Server but the concepts are the sam=
e. =A0You may want to read up on Ruby on Rails. =A0Good database strategy t=
here. =A0There is a lot to being a DBA and a good database programmer. =A0K=
eep reading and ask me any questions. =A0I have been in this game for 20+ y=
ears. =A0Good luck.<span><font color=3D"#888888"><div>
<br></div></font></span><div><span><font color=3D"#888888">Brian<br></font>=
</span><div><br><div class=3D"gmail_quote"><div>On Thu, Sep 27, 2012 at 1:5=
3 PM, Jonathan Clark <span dir=3D"ltr"><<a href=3D"mailto:jdc...@gmail.c=
om" target=3D"_blank">jdc...@gmail.com</a>></span> wrote:<br>
</div><div><div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8e=
x;border-left:1px #ccc solid;padding-left:1ex">
=A0Thanks to everyone that's responded,<div><br></div><div>At the momen=
t I'm just creating the initial database and working on some very simpl=
e pages to display and input data. =A0I think I have the database structure=
d correctly but then again this is my first time creating any type of datab=
ase and I have less then 24 hours of experience, so I'm sure there erro=
rs all over the place.</div>
<div><br></div><div>Once I have got the majority of the database setup I am=
definitely interested in any guidance related to the best way to display d=
ata and create forms for data input. (I may also be able to pay someone to =
get the initial web interface up and running).</div>
<div><br></div><div>Here's a copy of the current database I've crea=
ted and the relationship diagram. =A0If any of you database guys wanna take=
a look at it and let me know if there's anything I'm doing horribl=
y wrong, please feel free. =A0I'll take all the advice I can get. =A0TH=
ANKS!</div>
</blockquote></div></div></div><br></div></div>
</blockquote></div><br></div></div></div>
</blockquote></div><br><br clear=3D"all"><br></div></div><span class=3D"HOE=
nZb"><font color=3D"#888888">-- <br>Essobi <br>
</font></span></blockquote></div><br></div>
--20cf307d03dae79b4d04cac1ebcc--
Message from discussion {LVL1} Looking for some very basic MySQL consulting (Paid Work)
| Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy |
| ©2013 Google |