|
|
Posted by Summercoolness on 08/15/07 22:44
On Aug 15, 2:59 pm, Neo <neo55...@hotmail.com> wrote:
> > a simple way to do database schema design.
> > user can type in the movie name and zipcode,
> > return all the theaters showing that movie
> > and at what time, for theaters in THAT zipcode.
So let's say the problem is just that simple, without needing zipcode
related information (such as the name of the district)...
We can write
Movies
id
title
showtimes and in which theaters >>>>>>>
duration
description
Theaters
id
name
zipcode
phone number
address line 1
address line 2
movies showing there and their showtimes >>>>>>>>
and we put the ">>>>>>>>" for things that are "multiple items".
(indicated by us writing it in plural, such as showtimes)
and for any ">>>>>>>>" line, we will need to create a separate table,
if that table doesn't already exist.
and for those ">>>>>>>>" lines, we will simply remove them from the
original table.
so in our case, we create a new table
Showings
movie_id
theater_id
movie start time
and remove those ">>>>>>>>" lines in the original tables "Movies" and
"Theaters".
and that will complete the basic task? (assuming no future function
is needed).
Navigation:
[Reply to this message]
|