Information Technology Reference
In-Depth Information
Figure 3.3 Databases.are.everywhere,.and.it.is.extremely.important.
to.understand.how.they.work.
But. databases. are. extremely. important. to. understand.
because.nearly.every.type.of.application.you.will.interact.with.
on.a.computer.or.the.Internet.will.use.some.type.of.database.
to.organize.and.manage.your.user.experience.and.the.data.
you.create.(Figure 3.3).
A.database.is.simply.deined.as.any.organized.collection.
of. datum. that. has. a. relationship. with. each. other.. An. Excel.
spreadsheet.with.a.table.of.columns.and.rows.of.values.could.
be.deined.as.a.very.simple.“lat”.database.
More.complex.databases.are.made.up.of.more.than.one.
table. that. are. related. to. each. other. in. some. fashion,. usu-
ally.through.a.common.ield.such.as.a.record.identiication.
number..These.can.be.used.to.store.information.about.any-
thing.imaginable.
Let's.look.at.an.example.to.make.this.easier.to.understand.
You.might.create.a.relatively.simple.database.of.all.of.the.
DVDs.in.your.media.library..You.might.have.a.common.identi-
ication.ield.that.is.simply.a.number.that.increments.as.you.add.
new.records..So.the.irst.DVD.you.put.in.your.database.would.
have.the.common.identiier.of.1,.and.all.the.information.that.
relates.to.that.DVD.would.include.a.reference.to.that.number.
Next.you.might.create.a.table.in.your.database.that.is.a.
list.of.all.the.different.publishers.of.DVDs.(e.g.,.Sony,.Disney,.
