Question: create an ERD from this data Create an ERD of the normalized data from the second assignment, Grocery Store data. 1) Include correct annotations for


create an ERD from this data
Create an ERD of the normalized data from the second assignment, Grocery Store data. 1) Include correct annotations for cardinality: include minimum and maximum 2) ERD must use crows foot notations 3) Strongly recommend using Microsoft Visio N 1 2 3 4 A B C DE F G H 1 K L M Store Number Store Address City State Zip ClerkFirst Clerklast TotalAmount ItemCount CashBack RewardCard Transactioi Transaction Number 133 2589 Lomas NE Albuquerque NM 87131 Steve Rogers $68.40 14 No Yes Credit 1001 133 2590 Lomas NE Albuquerque NM 87131 T'Challa Wakanda $81.56 24 Yes Yes Debit 1002 133 2591 Lomas NE Albuquerque NM 87131 Steve Rogers $27.50 12 No No Credit 1003 133 2591 Lomas NE Albuquerque NM 87131 T'Challa Wakanda $224.42 52 No Yes Credit 1004 290 4433 Plaza Central Ave Santa Fe NM 87587 Tony Stark $52.00 20 No Cash 2001 290 4434 Plaza Central Ave Santa Fe NM 87587 Natasha Romanoff $48.20 21 Yes Yes Debit 2002 290 4435 Plaza Central Ave Santa Fe NM 87587 Tony Stark $43.56 16 No Yes Credit 2003 290 4436 Plaza Central Ave Santa Fe NM 87587 Natasha Romanoff $9.78 3 No No Cash 2004 5 Yes o cova 10 12 13 14 15 16 17 18 19 20 21 22 23Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
