How can i create a database for a website?

Question

database (admin)

Answer 1

I personally enjoy to use Oracle Workbench to handle complex databases, the tool can help you to build new database from scratch or to import an existing one and it draws you the structure with links between tables... and from Workbench you can upload your update to the database when you finish your update in local.

Answer 2

if you're using php you can use phpmyadmin to create a database. but depending on the server and the language you're using, you may need other options.

Answer 3

Quite many actually. I don't know your level in database knowledge but before start to build anything here are some things you have to learn:
- Relation 1,1 1,n n,n (hope I'm not wrong about these)
The idea of it is about how many element are going to be in relation with the table I will create? is it my ecommerce basket is going to be own by one user or "n" users? Its all about it but I'm not expert in it. You will probably find great tutorials.

- What is a primary key? Automatic increment?

- How flexible need to be my datas? Does that need to be split in many tables link to each others? If yes which are connected together? Maybe user's table is connected to the table handling baskets (ecommerce) and products to baskets... that's a deep thinking where I strongly appreciate the help of Oracle Workbench.

Try small with one table:
ID/ID_USER/NAME_USER
Play with, try to set/get/delete/drop...
Then add another table and try to communicates throught both tables at the same time.

Answer 4

OK

Answer 5

I make use HTML for my website but don't kwn how to make it like a standard website..
please show me the way out.

Answer 6

thanks @Geo.. what are the steps?