View Full Version : 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;
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
30-09-2008, 07:44 PM
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.
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
Umm is that a question? Or are you clearing up what I said :S:P
She's giving you field names.
Fifteen
30-09-2008, 07:50 PM
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..
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
30-09-2008, 07:53 PM
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)
Oooo :D THANKYOU. I think I get it more now :P
I have +REPP'd you :D
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
30-09-2008, 08:04 PM
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 :$
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 "/
Fifteen
30-09-2008, 08:19 PM
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?
Abbie.
30-09-2008, 08:39 PM
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.
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 :(
Abbie.
30-09-2008, 08:42 PM
yeaa i know what you mean
i ask my teacher for help every 2 mins, no joke lmao.
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
Fifteen
30-09-2008, 09:33 PM
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
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!
Fifteen
30-09-2008, 09:38 PM
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
Want to hide these adverts? Register an account for free!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.