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
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
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)
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
e
>star), all the titles in a genre and even compound queries such as all the
>MGM thrillers featuring actor XYZ.
>
>hth,
>Arthur
>
>----- Original Message -
>From: "John Chang" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, Octob
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
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
t;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 14, 2002 8:49 AM
Subject: Normalization sql
>
> I've read a bunch about normalization in MySQL and still can't do it very
> well. What I want to normalize is videos (Title, Studios, Actors, Genre,
>
I've read a bunch about normalization in MySQL and still can't do it very
well. What I want to normalize is videos (Title, Studios, Actors, Genre,
&bitrate).
These are the tables and fields I think it needs. Is this
normalized? Thank you.
Table (Fields)
Title (VideoTitle, details, id)
Studio
