Question

Structuring system data requirements - including conceptual data models for the "as-is" system using E- R modeling tools.

Create a Entity-relationship (ERD) assignment (AS-IS) for Petrie Electronics.

Answer 1

Entity-relationship (ERD) assignment (AS-IS) for Petrie Electronics :

ER Diagram of Petsie's customil loyality program. The selationships between the types of records can be shown pictorially with an Entity - Relationship Diagram ox ER- Diagram Jo a data base system rrelationships can be defined as an alsociation between data which is stored in different types of records ER- Diagram Coupon Coupon ID Y service service ID is promotion offered Customer bromotion ID: Customer ID performs . Transaction AF transaction 10 --H Involved in + Product product ID All the data base designs are not documented in Visio. The relations in the data base are normalized in the third normal form The relations are broken into two relations to avoid transitive dependency. So database designs depicts the overall dependence relations

_____________________________________________________

Please up vote this answer. Thank you so much. Your up vote is so valuable to me.