CODEWITHSUNDEEP
phpdatabase-design
Nano HE
Nano HE

Reputation: 9307

How to start the DataBase design for a web project?

I plan to develop a web directory system.(php used)

But i don't know how to start the Data Base design.

Are there any good books/tutorials about it? Thank you.

Upvotes: 0

Views: 754

Answers (1)

Sri
Sri

Reputation: 5845

Questions you should ask yourself (or the product owner) are:

  • What entities are at the heart of your application?
  • How are they linked to each other?

My guess: Web directory system has got:

  • Entries
  • Categories
  • Tags
  • Users

Now take it further.. how are these related to each other?

  • Entries belong to categories
  • Tags are associated with entries
  • Entries are submitted by users

And another step..

  • Entries have titles, descriptions, images, links, contact info
  • Users have usernames, emails, passwords

.. and so on

Upvotes: 4

Related Questions