|
 |
RSS |
|
| Subscribe to our newsletter |
|
|
|
 |
Recent Posts |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|
| November 18, 2009 - What is ERD and Why Is It Important In Website Development? |
|
|
|
ERD is an Entity Relationship Diagram which is a graphical representation of database entities (tables, table columns, table definitions, attributes) and inter-relationships between these entities (how the tables are connected).
Here is simple ERD for the website with news section updated by users:
This simple ERD has 3 tables: users, news, and newsComments. It is easy to understand the attributes and data relationships.
Please note, this is a very simple diagram, most ERDs include 100s of tables. For example
Why it is important:
For the Website Owner - It is easiest way to describe relationships between data and to get a picture of functionality needed for the website. This reduces development time, helps meet deadlines and saves money.
For the Website Developer - It is easy to assess time to program, and accurately project deliverables, timelines and pricing.
Michael P. |
|
|
Associated tags:
SQL, MySQL, Website Development, ERD, Databse, Relationship, Attributes, Entity Relationship Diagram, MsSQL |
|
|
| Comments: |
| Michael wrote on August 8, 2011 at 12:10 |
| Drupal is not the only platform, and we are not using it. We have our own in-house written CMS. |
|
|
| Nesei wrote on July 14, 2011 at 02:45 |
| At this time it looks like Drupal is the top blogging platform available right now. (from what I`ve read) Is that what you`re using on your blog? |
|
|
| Michael Pankratov wrote on April 9, 2010 at 10:49 |
| As I understand you are interested in ERD lessons, please let me know what exactly you need to learn and we will be able to help you, you can fill in contact us form with your contact information and we will get back tou you. |
|
|
| Jeffrey Hagendijk wrote on April 6, 2010 at 09:56 |
| If this is ever looked at again, do you have some kind of instruction or Lesson material for ERDs? I am studying IT, and already failed my exam 5 times because of it. The realisation is fine, but my technical report is where I fail on everytime. Please send information to my mail regarding ERD lessons. Thanks in advance~ Jeff |
|
|
| Web Developer wrote on December 7, 2009 at 06:10 |
| Your post is helpful and informative. |
|
|
|
|
|
|
|
Web development