I.T Database H/W (GCSE)[+REP]

[Con]

Hai there.
Basically in class we are making databases using MS ACCESS.
I know how to make the database if I was jsut there making it, But the homework expects me to design it on paper!
So I need to get my head around where I would put each different section.

Here's what I have wrote down;

Design the tables, fields + relationships for the DVD rental shop.
Database about customers, DVDS and rentals.
In addition, It needs to suggest titles of interest for customers, E.G Someone likes horror - Show them all horror films.
List things with Tbl_(enter text here) - AUTONUMBER/TEXT etc.
Frms:
Title - Text
Horror - Text

I dunno if that makes sence, If ANYONE can get their head around it, Can you hep

+REP for all help!

Thanks xox

[Fifteen]

Table names, field names, field types, field sizes, validation rules, input masks, combo boxes, what fields are primary keys and which are look up wizards.

[Con]

Table names, field names, field types, field sizes, validation rules, input masks, combo boxes, what fields are primary keys and which are look up wizards.

Umm is that a question? Or are you clearing up what I said :S

[Nemo]

Umm is that a question? Or are you clearing up what I said :S

She's giving you field names.

[Fifteen]

Umm is that a question? Or are you clearing up what I said :S

oh....

thought you were asking what to write about it

just basically draw 3 tables

kinda like this

tblcustomers
FieldName Data type Field size Validation
CustID(Primary key) Autonumber
Title Text 4 'Miss' or Mr' or 'Ms' Or Mrs'
FirstName Text 30


then have a inputmask and combo box column..

[Con]

Table names, field names, field types, field sizes, validation rules, input masks, combo boxes, what fields are primary keys and which are look up wizards.

oh....

thought you were asking what to write about it

just basically draw 3 tables

kinda like this

tblcustomers
FieldName Data type Field size Validation
CustID(Primary key) Autonumber
Title Text 4 'Miss' or Mr' or 'Ms' Or Mrs'
FirstName Text 30


then have a inputmask and combo box column..

Oh yeh!
That kind of clearedit up Hmm..
I'll attempt something tonight and then hunt down my teacher tomorrow

[Fifteen]

tblcustomers

CustID (primary key)
FirstName
LastName
Address line 1
Town
County
Postcode
CardType
CardNumber
ExpiryDate


tblcds

cdID (primary key)
CdTitle
Artist

tblorders

ordernumber
orderdate
custID (look up wizard)
cdID (look up wizard)

[Con]

Oooo THANKYOU. I think I get it more now
I have +REPP'd you

tblcustomers

CustID (primary key)
FirstName
LastName
Address line 1
Town
County
Postcode
CardType
CardNumber
ExpiryDate


tblcds

cdID (primary key)
CdTitle
Artist

tblorders

ordernumber
orderdate
custID (look up wizard)
cdID (look up wizard)

[Fifteen]

Oooo THANKYOU. I think I get it more now
I have +REPP'd you

need anymore help, just ask.

Did databases in GCSE ICT aswell, also last year in my OCR course..and I am currently doing them now

[Con]

need anymore help, just ask.

Did databases in GCSE ICT aswell, also last year in my OCR course..and I am currently doing them now

Annoying thing is.. If I was on a computer with MS access I could probably do it.

Just it's confusing having to write it down
+ Im basically like :S on how to link up to say they like horror - Show them all horror movies

I think it will be easier if I draw the realtionships first..
so I think it will looksomething like this:


Probably wrong titles Já + obviously have more titles etc. But I think that's right "/