Question

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 please up vote this answer . Your upvote is valuable for me .Thank you