|
| |
|
|
zed
Posts: 7
Joined: 3/13/2004
Status: offline
 |
booking system - 3/16/2004 4:37:59
Im trying to produce a online booking system for a video shop. Basically on the home page is a link for Dvd's from here a drop down box will a appear with different catergories to choose from. Also before you can book online you must register so i will need to hold customer details.
Wot tables will i need and what attributes
1.Customer table
2.Dvd Table
3.Do i need more ?????
please help
|
|
|
|
BeTheBall
Posts: 6359
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: booking system - 3/16/2004 11:45:04
Technically, in a true relational database you would probably create a separate table just for categories. Makes it easier when you decide to add a category later. You would then use the category table as a lookup table in the DVD table. As far as what fields to use, that is up to you. All depends on how much information you want to store. In the category table, I would guess you will have just two fields. One will be something like, CategoryID and should be an autonumber and the primary key. The other will be simply Category. For the DVD table, the skies the limit. You will want to include the CategoryID field so that you can join the Category table, however, it will NOT be the primary key in the DVD table. You should have DVDID as an autonumber, primary key. DVD title and then anything else you can think of such as YearReleased, Rating, etc.
Same goes for the Customer table. You will want CustomerID as an autonumber, primary key and then anything else you want.
Does that help get you started?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
zed
Posts: 7
Joined: 3/13/2004
Status: offline
|
RE: booking system - 3/16/2004 13:34:42
[Thanks for reply
Im sorry if i sound stupid im not very good at this sort of thing. What did you mean by
quote]use the category table as a lookup table in the DVD table[/quote] ?
i want user's to login with a password and user name to my site do i need to add these fields to customer table or have a new table.
This is fist time ive used a forum .I have drawn a ER diagram but i dont know how to post it here.
Is it 3 tables
Customer to Dvd 1:M
Catergory to Dvd 1:M
Customer to Catergory 1:M ( not sure)
| |
|
|
|
zed
Posts: 7
Joined: 3/13/2004
Status: offline
|
RE: booking system - 3/16/2004 14:12:53
Had a look at login system i dont under stand it. .
Ive managed to make a search page on my site its got a drop down box where use choose a catergory from. For example if someone chooses comedy how do i bring up all the comedy DVD's. i know its something to do with asp code but what and where the code goes i dont know.
And once the dvd titles come up what should the page look like
Plus if i want to be able to have admin privileges like add new dvd, remove product ,remove users , show orders
how can i do this through thw site.
do i need another table -- idont think so
i want i page on my site where someone can administer the site
< Message edited by zed -- 3/16/2004 15:15:20 >
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
