AS we know that entity relation diagram(ERD) is an important concept in database implementation, But I was wondering that can we skip this step when creating a small database containing a few tables i.e directly create tables in RDBMS in order to save time. or I should do all steps for better understanding i.e draw the ERD and then implement in RDBMS ?? Although it is a small database.

Just asking this question for general knowledge as I am new to this field.

closed as primarily opinion-based by Marco, hot2use, Md Haidar Ali Khan, Philᵀᴹ, Colin 't Hart Jul 27 '18 at 8:27

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    How much time does it take to draw an ERD for a small database? Is this a really significant loss of time? You might catch something (small) that you missed and save you time to fix it later. You can often generate an ERD once you created the tables. Up to you. – Marco Jul 26 '18 at 9:47
  • Oh yeah, That's a good point. Suits my question well – Tom Jul 26 '18 at 9:53

The ERD is simply a product of the database design phase. You can skip drawing the ERD if you can complete design in your head, but you cannot (should not) skip designing your database.

Not the answer you're looking for? Browse other questions tagged or ask your own question.