Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    difference between ERD and Data Modelling

    Hi All,
    I am quite new to this area of technology. Recently I am given an assignment of designing a database for an application.

    I thought initially that:
    1) I need to identify the data points that needs to be captured
    2) Structure it in the form of table
    3) Draw the relationship of each table - (ERD)

    and thats it.

    But when i searched on the internet, I saw lots of information and activities pertaining to a database design.

    Can anyone brief the steps involved in a database design? Also some URLs, references to a newbie like me will be helpful.

    Thanks in advance.

  2. #2
    Join Date
    Jun 2003
    Start with the logical design, modeling the business. Identify entities and their relationships. Then add attributes to the entities. From there, you move to a physical database design where you may combine or split entities for performance or data integrity reasons.
    Model the business, not the application.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts