reflect on some potential problems a database designer may encounter when trying to construct an ERD.
Some of the potential problems faced by the database designer would be:
(1) Debugging database will hard as it will require a lot of complex SQL commands to understand where the error is, a visualization tool for the database would help out in such a case.
(2) There are no proper notions for entity and relationship set, This ambiguity will itself lead to a set of other problems during database design, such as Use of Entity set vs attributes, Use of Entity sets vs relationship sets..etc. This ambiguity also leads to problems such as different traps (Fan Traps: Many relationships from a single entity, Chasm Traps: due to relationships with partial participation..etc).
Get Answers For Free
Most questions answered within 1 hours.