Draw an ERD to represent what you have discovered. Identify a business rule in this description and explain how this business rule is modeled on the E-R diagram. Also draw a data model for this situation using the tool you have been told to use in your course. 2-46. Obtain several common user views such as a credit card receipt, credit card statement, and annual summary or some other common document from one organization with which you interact.
a. Prepare an ERD for one of these documents. Also prepare a data model for this document, using the tool you have been told to use in your course.
b. Prepare an ERD for another of these documents. Also prepare a data model for this document, using the tool you have been told to use in your course.
c. Do you find the same entities, attributes, and relationships in the two ERDs you developed for parts a and b? What differences do you find in modeling the same data entities, attributes, and relationships between the two ERDs? Can you combine the two ERDs into one ERD for which the original two are subsets? Do you encounter any issues in trying to combine the ERDs? Suggest some issues that might arise if two different data modelers had independently developed the two data models.
d. How might you use data naming and definition standards to overcome the issues you identified in part c?