Re: normalization

2010-06-15 Thread Peter Brawley
can u please tell me , 5NF with example, There's one in http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.html PB - On 6/14/2010 10:51 PM, bharani kumar wrote: Frankly speaking , Am looking very simple example for 5NF , Even i looked the lot of site , in most of the site t

Re: Normalization vs. Performance

2008-08-29 Thread Arthur Fuller
sage- > >From: Kevin Hunter [mailto:[EMAIL PROTECTED] > >Sent: Thursday, August 28, 2008 10:59 PM > >To: John Smith > >Cc: MySQL General List > >Subject: Re: Normalization vs. Performance > > > >At 2:11pm -0400 on Tue, 26 Aug 2008, John Smith wrote: >

RE: Normalization vs. Performance

2008-08-29 Thread Jerry Schwartz
>-Original Message- >From: Kevin Hunter [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 28, 2008 10:59 PM >To: John Smith >Cc: MySQL General List >Subject: Re: Normalization vs. Performance > >At 2:11pm -0400 on Tue, 26 Aug 2008, John Smith wrote: >> So

Re: Normalization vs. Performance

2008-08-29 Thread Martijn Tonies
> > So how bad is this? The mentioned query will be the query which is used > > the most in my application (yes, it is going to be a forum). > > Should I break normalization and save the date of the root in each node row? > > My recommendation is no. Normalization is a Good Thing, and you'll be >

Re: Normalization vs. Performance

2008-08-28 Thread Kevin Hunter
At 2:11pm -0400 on Tue, 26 Aug 2008, John Smith wrote: > So how bad is this? The mentioned query will be the query which is used > the most in my application (yes, it is going to be a forum). > Should I break normalization and save the date of the root in each node row? My recommendation is no. N

Re: Normalization question

2005-12-10 Thread Rod Heyd
Thanks for you responses! This list has proven to be for useful to pick pick the brains of other DBA's. I think we are probably going to go the route of splitting the different pieces of data into seperate columns, while keeping the original product_id, since we have a lot of third party applicat

Re: Normalization question

2005-12-09 Thread Michael Stassen
Rod Heyd wrote: Hi Everyone, I've got a little debate that maybe you can all help me settle. I have three tables that I need to join, but there are performance problems with the joins due to some misunderstandings of my predecessor about what's needed to join the tables efficiently. Here's the

Re: Normalization question

2005-12-09 Thread SGreen
Rod Heyd <[EMAIL PROTECTED]> wrote on 12/09/2005 11:01:38 AM: > Hi Everyone, > > I've got a little debate that maybe you can all help me settle. > > I have three tables that I need to join, but there are performance problems > with the joins due to some misunderstandings of my predecessor about

Re: Normalization sql

2002-10-21 Thread Michael T. Babcock
John Chang wrote: What is the Title.ID and Actor.ID? Will this work if someone is doing a text search on a webpage? The results will go to another page. Does the below go to the first page or the results page? You need a good SQL book and a good CGI/web programming book. The .ID's are usua

Re: normalization question

2002-10-21 Thread Richard Clarke
CTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 9:17 PM Subject: RE: normalization question Hi! I don't understand problem. Car can belong to only one Dealer, and one Dealer can have many Cars, therefore DealerID should be in Car table. Also Car can

RE: normalization question

2002-10-21 Thread Artem Koltsov
Hi! I don't understand problem. Car can belong to only one Dealer, and one Dealer can have many Cars, therefore DealerID should be in Car table. Also Car can be only one Model, but there are many Cars the same Model. It looks quite normal to put ModelID into Car table, and I don't see any possib

Re: Normalization sql

2002-10-20 Thread John Chang
What is the Title.ID and Actor.ID? Will this work if someone is doing a text search on a webpage? The results will go to another page. Does the below go to the first page or the results page? Thank you. At 12:20 PM 10/16/2002 -0400, you wrote: John Chang wrote: Studios (StudioName, Studi

Re: Normalization

2002-10-16 Thread Michael T. Babcock
Arthur Fuller wrote: >>Ooops! You just threw a new wrench into the works! "A video may have >>multiple titles." In this case you must distinguish the original from its >>presumably foreign-translations (or whatever). In other words, you might >>store the master as "La Cage aux Folles" and the En

Re: Normalization sql

2002-10-16 Thread Arthur Fuller
Message - From: "John Chang" <[EMAIL PROTECTED]> To: "Arthur Fuller" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 7:26 PM Subject: Re: Normalization sql > > >Studios (StudioName, StudioID) > >Genres (GenreName, GenreID)

Re: Normalization sql

2002-10-16 Thread Michael T. Babcock
John Chang wrote: > >> Studios (StudioName, StudioID) >> Genres (GenreName, GenreID) >> Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) >> Actors (F_Name, L_Name, ActorID) >> Stars (TitleID, ActorID) > > TitleGenres (TitleID, GenreID) > > So, if I just use theses tables I will

Re: Normalization sql

2002-10-14 Thread John Chang
>Studios (StudioName, StudioID) >Genres (GenreName, GenreID) >Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) >Actors (F_Name, L_Name, ActorID) >Stars (TitleID, ActorID) TitleGenres (TitleID, GenreID) So, if I just use theses tables I will be OK if the video has multiple tit

Re: Normalization sql

2002-10-14 Thread John Chang
I forgot to add Video (This has all the Primary key id from the tables below) Now does it work? My question is how do I get the Primary keys into the video table? Do I just put them in and the database will know it should look in the other tables? How do I connect it? I read some books bu

Re: Normalization sql

2002-10-14 Thread Michael Zimmermann
Hi John, your design is normalized, but incomplete and unconnected. Where do you put the information which actor was playing in what title, which title was done in what studio etc. ? Normalization is a representation technique to avoid storing *redundant* information. But first this informati

Re: Normalization sql

2002-10-14 Thread Arthur Fuller
You're starting off ok, just missing the links between the tables. I would suggest for simplicity though that you change the names of your PKs to reflect their table, i.e. Title (VideoTitle, Details, TitleID). Otherwise once you do multi-table queries joins you will have to specify the table names

RE: Normalization question

2002-06-04 Thread Cal Evans
June 04, 2002 6:38 PM To: [EMAIL PROTECTED] Subject: RE: Normalization question I have a question about the setup of the tables in my database. In my members table, I store a lot of info about demographics, such as marital status, income, etc. The way I'm doing this is the enum type. Is it bett

RE: Normalization question

2002-06-04 Thread Daren Cotter
t;correct" way to do this? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 6:24 PM To: Daren Cotter Subject: Re: Normalization question Your message cannot be posted because it appears to be either spam or simply off topic to

Re: Normalization advice needed

2001-12-27 Thread Bob Hall
On Thu, Dec 27, 2001 at 04:01:57PM -0600, Gawain wrote: > I've got a 3500 record database cataloging an art collection. The > data was originally assembled (by others) in Access. I've imported it > into MySQL to make it available on the artist's web site: > . > >

RE: normalization question

2001-08-20 Thread Rene Churchill
l [mailto:[EMAIL PROTECTED]] >Sent: Sunday, August 19, 2001 7:34 AM >To: Daren Cotter >Cc: [EMAIL PROTECTED] >Subject: Re: normalization question > > > >Hi Daren, > >How long do you need to store this information? The normalized table >that you describe is simple and e

RE: normalization question

2001-08-19 Thread Daren Cotter
aren Cotter CEO, InboxDollars.com http://www.inboxdollars.com (507) 382-0435 -Original Message- From: Rene Churchill [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 19, 2001 7:34 AM To: Daren Cotter Cc: [EMAIL PROTECTED] Subject: Re: normalization question Hi Daren, How long do you need to store t

Re: normalization question

2001-08-19 Thread Rene Churchill
Hi Daren, How long do you need to store this information? The normalized table that you describe is simple and easy to index. Having several million rows in the table won't bother MySQL. So is it sufficient to keep the data around for a month and then prune it out of the database? Long term