The main difference between entity and relationship in DBMS is that the entity is a real-world object while the relationship is an association between the entities. Also, in the ER diagram, a rectangle represents an entity while a rhombus or diamond represents a relationship.