Design web hosting website database. help me!

Question

Hi, I'm not so experienced in designing database plz help me!

I'm designing a web hosting website.

We ham list of hosting plans in our site including diskspace, bandwidth and price.

Each hosting plan has several packages that will sell to users. Each package has CPanel username and password, start time, end time and …

We have list of domain type like .com, .net and …, and we store 1 year price of each type.

We ham list of submitted domain by our company and we store type of domain, start time and end time.

List of VPS is much the same as list of package and each VPS is owned by a user.

User can renew domain, change domain DNS and …

It can renew package, upgrade it and …

And the same for VPS

Some of this services are free and some not. For each service we make an invoice and we store all the user invoices.

In a nutshell, I want to relate this products (domain, host, VPS), users, services (Change DNS, upgrade) and invoices together in an effective way.

-------------------------------------------

We can have video conference if it’s not clear enough. Email me and tell me the time! (international time) I’ll be online ;)

Thank you.

[e-mail]

Answer 1

Maybe you should start here:

http://www.databaseanswers.org/data_models/index.htm

---

Ryan Shuell

Answer 2

It's easier for us to help if you provide a bit more about what you've attempted and what you've had problems with in more detail.  Ask specific questions and we can give you some answers to those questions.

Start by listing all the "things" you want to keep data about and model those, with relationships.  Don't worry about columns and tables yet.  Going right to columns is what gets people in trouble because they get caught up in the details before they've had a chance to think about the bigger picture.

Do that, then come back with some specific questions.

---

--- Love Your Data @datachick blog.infoadvisors.com

Answer 3

Hi

You can view the site below to avoid mistake

http://woork.blogspot.com/2008/09/10-useful-articles-about-database.html

Bye

---

Ahsan Kabir