ER Model vs. Relational Model

• Both are used to model data
• ER model has many concepts
– entities, relations, attributes, etc.
– well-suited for capturing the app. requirements
– not well-suited for computer implementation
– (does not even have operations on its structures)
• Relational model
– has just a single concept: relation
– world is represented with a collection of tables
– well-suited for defining manipulations on data

Share this

vjk