booking system (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

zed -> 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 -> 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?



zed -> 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)



BeTheBall -> RE: booking system (3/16/2004 13:49:32)

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.


May be worth looking at the Spooky Login product available here at OutFront. Then the whole login system is ready to go and you would just need to add your DVD tables to the already existing db. Take a look:

http://www.outfront.net/spooky/login.htm

I highly recommend it if developing a password protected site (and I get no kick back for saying that).

As far as relationships, not all table will have one. For example, there is no logical relationship between DVD Category and Customer. In fact, there may not be one between Customer and DVD.

Don't think you sound stupid. If you want to be amused, look at some of my posts over the past 20 mos. [8|]



zed -> 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



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
3.100586E-02