This assignment is to practice reading and creating entity-relationship (ER) diagrams.

Make sure the ER diagrams you create are legible and that the relationships are properly documented, including cardinality (one-to-one / one-to-many / many-to-many), participation (mandatory / optional) and identified primary and foreign keys.

Redundant Data: Consider the ER diagram about a database for Bolmont Landscapes below City EL Sie w A 2 C The following tablet provides a spreadsheet with simple data for the nice table Identity the redundant data in the table. Figure out a way to clinate the redundant data by change the design of the database 2501 10 11.500.00 2303 305 PM $3.000.00 2371 20 Schema 2372 179 52.800.00 2 SH 1245 Pan 2174 200.00 21 179 Commy w Screw 3000 23/ 2400 15400000 2:34 2011 27 20 11/27/58 179 Carwash 2993 1/2000 Construction Documents 2394 122 3051 Construction 2401 12/ 1244 30 Contactos Doces 300 2000 SEY 3053 Hint Add another entity that would contain the redundant data and in the to the Invice entity through a relationship Draw the resulting ER diagram containing the Customer Contact Invoice tables, as well as the new table and upload a photo