Question
Read the following description and then draw a correct Entity-Relationship Diagram to represent the description. Use the correct symbols and rules for entities, attributes, identifier
Read the following description and then draw a correct Entity-Relationship Diagram to represent the description. Use the correct symbols and rules for entities, attributes, identifier attributes, relationship line(s), minimum cardinality, and maximum cardinality. Do not normalize any N:M relationships. A Translink Compass card is identified by a CardiD number, which is unique to each card. A card has a card type (e.g. adult or concession) and a balance (the amount of money available to use with the card). When money is added to the card, the transaction is recorded with a unique EventID. The record of the transaction includes the date and time of the transaction, the payment method, and the amount. Compass Cards are issued with zero balance, but because there is a $6 fee for the card itself, there is always at least one transaction. Money can be added to a card many times. Each transaction applies to one card only.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started