Question 3 Cardholder Card Card Reader Card Reader D Cardholder Name Address Phone Ho Cardid CardType Location Position The ERD above is related to the scenario in the previous questions but is not exactly the same. You should be aware that when a cardholder uses a Compass card to enter or exit a train station or bus, the card is scanned at a card reader. The time and date of this event is recorded. In words, write the complete table design for the ERD shown above. Represent all table keys and any foreign keys required for the relationships. Add an additional table for a N:M relationship as appropriate NOTE 1: An example of table design is shown in figure KE6-14 in the textbook. NOTE 2: Indicate table key and foreign keys as follows: Table keys should be underlined with a straight line Foreign keys may be indicated either by using: Text in Italics (if you are typing your assignment) Wawiline underline (preferred if you are preparing your assignment by hand) If an attribute is both a table key and a foreign key, use italics and underline, eg Parking permited or, if you are hand writing, a double underline, e.g. Parking Permitid. Write or type your answer below the line