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

Printable View

30-09-2008, 07:41 PM
Con

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

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;

Quote:

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
30-09-2008, 07:44 PM
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.
30-09-2008, 07:45 PM
Con

Quote:

Originally Posted by 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.

Umm is that a question? Or are you clearing up what I said :S:P
30-09-2008, 07:46 PM
Nemo

Quote:

Originally Posted by -conz-

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

She's giving you field names.
30-09-2008, 07:50 PM
Fifteen

Quote:

Originally Posted by -conz-

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

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..
30-09-2008, 07:52 PM
Con

Quote:

Originally Posted by 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.

Quote:

Originally Posted by Fifteen

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
30-09-2008, 07:53 PM
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)
30-09-2008, 08:03 PM
Con

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

Quote:

Originally Posted by 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)
30-09-2008, 08:04 PM
Fifteen

Quote:

Originally Posted by -conz-

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

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 :$
30-09-2008, 08:13 PM
Con

Quote:

Originally Posted by Fifteen

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:
http://uploadpicz.com/images/A8K687A.png

Probably wrong titles Já + obviously have more titles etc. But I think that's right "/
30-09-2008, 08:19 PM
Fifteen

Quote:

Originally Posted by -conz-

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:
http://uploadpicz.com/images/A8K687A.png

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

you could have a genre field then do a query looking up all horror movies?
30-09-2008, 08:39 PM
Abbie.

I HATE ACCESS LOL.

the relationships is the easy part
im going forms atm

its easy, but y cant it just not be in a spreadsheet LOL.
30-09-2008, 08:40 PM
Con

Quote:

Originally Posted by Abbie.

I HATE ACCESS LOL.

the relationships is the easy part
im going forms atm

its easy, but y cant it just not be in a spreadsheet LOL.

ino but im like..
At school - Able to work
At home - unable to work :(
30-09-2008, 08:42 PM
Abbie.

yeaa i know what you mean

i ask my teacher for help every 2 mins, no joke lmao.
30-09-2008, 09:28 PM
Con

Oo I think it's coming back to me :S

I have wrote:

Tbl_customers
Customer ID - Autonumber
First Name - Text
Last Name - Text

Tbl_DVD
dvdID - Autonumber
DVD Title - Text
Genre - Text

Tbl_rental
Order number - ? Unsure whether it is autonumber or not.
Order date - Time and date
customer ID - Lookup wizard?
DVD ID - Lookup wizard?

I think that's like.. right?
:P

Then for relationships I have to split it all up or w.e :D
30-09-2008, 09:33 PM
Fifteen

Quote:

Originally Posted by -conz-

Oo I think it's coming back to me :S

I have wrote:

Tbl_customers
Customer ID - Autonumber
First Name - Text
Last Name - Text

Tbl_DVD
dvdID - Autonumber
DVD Title - Text
Genre - Text

Tbl_rental
Order number - ? Unsure whether it is autonumber or not.
Order date - Time and date
customer ID - Lookup wizard?
DVD ID - Lookup wizard?

I think that's like.. right?
:P

Then for relationships I have to split it all up or w.e :D

Tbl_customers
Customer ID - Autonumber [Primary key]
First Name - Text - Field size 4 - Validation rule: 'Mr' or 'Mrs' or 'Miss' or 'Ms' - combo box ( Mr;Mrs;Miss;Ms )
Last Name - Text - field size 30

Tbl_DVD
dvdID - Autonumber [Primary Key]
DVD Title - Text - Field size 100
Genre - Text - Field size 50

Tbl_rental
Order number - number
Order date - Time and date
customer ID - Lookup wizard
DVD ID - Lookup wizard
30-09-2008, 09:36 PM
Con

Quote:

Originally Posted by Fifteen

Tbl_customers
Customer ID - Autonumber [Primary key]
First Name - Text - Field size 4 - Validation rule: 'Mr' or 'Mrs' or 'Miss' or 'Ms' - combo box ( Mr;Mrs;Miss;Ms )
Last Name - Text - field size 30

Tbl_DVD
dvdID - Autonumber [Primary Key]
DVD Title - Text - Field size 100
Genre - Text - Field size 50

Tbl_rental
Order number - number
Order date - Time and date
customer ID - Lookup wizard
DVD ID - Lookup wizard

okay I love you :D
I don't think we have done validation box's tbh, + I'm not sure if we have really doe much about field size. But I love you for helping me anyways :D

I can just take in what I have done and show the teacher tomorrow + see if I have done it right or not :D
again, THANKYOU!
30-09-2008, 09:38 PM
Fifteen

Quote:

Originally Posted by -conz-

okay I love you :D
I don't think we have done validation box's tbh, + I'm not sure if we have really doe much about field size. But I love you for helping me anyways :D

I can just take in what I have done and show the teacher tomorrow + see if I have done it right or not :D
again, THANKYOU!

ehhe bye have a good day tomorrow :)
xo