Using Visio, create an Entity Relationship Diagram (ERD) of .xlsx data a. Please include the correct...

  

Transcribed Image Text:

Using Visio, create an Entity Relationship Diagram (ERD) of .xlsx data a. Please include the correct annotations for cardinality You are now the database designer. Add a new entity to your ERD in Visio from question #3 that was not defined in the data provided. This new entity should relate to the existing entities. a. Include i. ii. iii. iv. Entity Name Cardinality relationship to other Entity Column Names Data Type Size your normalized V. vi. Key References vii. NOT NULL Constraints Grocery Store 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 Sales Clerk Steve Rogers T'Challa Wakanda Steve Rogers T'Challa Wakanda Steve Rogers T'Challa Wakanda Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Natasha Romanoff Total, Item Count $68.40, 14 $81.56, 24 $27.50, 12 $224.42, 52 $51.60, 14 $137.40, 31 $52.00, 20 $48.20, 21 $43.56, 16 $9.78, 3 $169.50, 43 $27.06, 8 $87.28, 20 $97.42, 22 $181.48, 34 Type, Cash-back, Rewards Card used? Credit, No, Yes Debit, Yes, Yes Credit, No, No Credit, No, Yes Credit, No, Yes Credit, No, Yes Cash, No, Yes Debit, Yes, Yes Credit, No, Yes Cash, No, No Credit, No, Yes Credit, No, Yes Debit, Yes, No Cash, No, Yes Debit, No, Yes Column Name Grocery Store Sales Clerk Grocery Store No. Total Item Count Payment Type Cash back Additional Payment varchar varchar Number float number var char var char varchar Data Type Max 8000 char Max 8000 char 5-17 bytes 4-8 bytes 5-17 bytes Max 8000 char Max 8000 char Max 8000 char Size Key Foreign Key Not Null Constraints Primary Key NOT NULL Using Visio, create an Entity Relationship Diagram (ERD) of .xlsx data a. Please include the correct annotations for cardinality You are now the database designer. Add a new entity to your ERD in Visio from question #3 that was not defined in the data provided. This new entity should relate to the existing entities. a. Include i. ii. iii. iv. Entity Name Cardinality relationship to other Entity Column Names Data Type Size your normalized V. vi. Key References vii. NOT NULL Constraints Grocery Store 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 Sales Clerk Steve Rogers T'Challa Wakanda Steve Rogers T'Challa Wakanda Steve Rogers T'Challa Wakanda Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Natasha Romanoff Total, Item Count $68.40, 14 $81.56, 24 $27.50, 12 $224.42, 52 $51.60, 14 $137.40, 31 $52.00, 20 $48.20, 21 $43.56, 16 $9.78, 3 $169.50, 43 $27.06, 8 $87.28, 20 $97.42, 22 $181.48, 34 Type, Cash-back, Rewards Card used? Credit, No, Yes Debit, Yes, Yes Credit, No, No Credit, No, Yes Credit, No, Yes Credit, No, Yes Cash, No, Yes Debit, Yes, Yes Credit, No, Yes Cash, No, No Credit, No, Yes Credit, No, Yes Debit, Yes, No Cash, No, Yes Debit, No, Yes Column Name Grocery Store Sales Clerk Grocery Store No. Total Item Count Payment Type Cash back Additional Payment varchar varchar Number float number var char var char varchar Data Type Max 8000 char Max 8000 char 5-17 bytes 4-8 bytes 5-17 bytes Max 8000 char Max 8000 char Max 8000 char Size Key Foreign Key Not Null Constraints Primary Key NOT NULL

Answer rating: 100% (QA)

Question For the Entity relationship diagram it include 5 entities 1 Item entity 2 payment entity 3 ... View the full answer