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
>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
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
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
