Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data, Mining, And Analytics Components Of Strategic Decision Making

Authors: Stephan Kudyba

1st Edition

1466568704, 9781466568709

More Books

Students also viewed these Databases questions

Question

Q.1. Taxonomic classification of peafowl, Tiger and cow ?

Answered: 1 week ago

Question

Q .1. Different ways of testing the present adulterants ?

Answered: 1 week ago

Question

Q.1. Health issues caused by adulteration data ?

Answered: 1 week ago

Question

1. Traditional and modern methods of preserving food Articles ?

Answered: 1 week ago