Information Technology Reference
In-Depth Information
etc.)..Then.you.might.create.a.table.that.lists.all.of.the.movie.
themes.such.as.westerns,.thrillers,.romance,.and.children's;.
and.another.table.that.refers.to.all.of.the.actors;.and.another.
table.for.directors.
Now,.you.create.a.new.record.of.your.irst.DVD.that.refers.
to.the.Actors.table.and.the.Themes.table.
The. main. DVD. records. table. you. create. would. contain.
the.identiication.number,.the.name.of.the.DVD,.maybe.the.
date.and.place.you.bought.it,.and.the.price.you.paid..Then.
it.would.also.include.references.to.the.publisher.of.the.DVD.
(taken.from.the.Publishers.table),.the.stars.on.that.DVD.(taken.
from.the.Actors.table),.and.the.theme.of.the.DVD.(taken.from.
the.Themes.table)..If.you.refer.to.Figure 3.4,.you.get.a.visual.
idea.of.how.this.all.might.look.
You. might. begin. to. see. that. these. related. tables. can. be.
used.for.data.that.are.common.to.several.different.records..
Without.getting.too.deeply.into.database.theory,.this.should.
help.you.to.understand.the.basics.of.what.is.referred.to.as.a.
relational
.database.
To.add.new.records.to.any.of.those.tables,.database.appli-
cations.include.forms.where.you.ill.in.the.blanks.to.add.and.
save.new.records..They.also.include.some.kind.of.query.tool.
ID Number Reference
ID Number Reference
emes table
Actors table
DVD Database
Main Table
ID Number
Name
ID Number Reference
ID Number Reference
Directors table
Publishers table
Figure 3.4 Our.sample.relational.database.design.