Your goal is to redesign their single table database. below you have some rows of the table to you understand the kind of data it stores, and how thedata relates with itself./hour117721013bill 2/27/20113$100117651015melanie 1/25/20114$120117672051ed 1/31/20112$50117682051ed 2/10/20114$551176933562/15/20115$90 1177333563/20/20116$601177140762/26 /20117$651176640791/25/20114$110117 7040792/25/20115$70a)what can go wrong with storing such information in a single table like the one above? give oneexample of an insertion anomaly and of an update anomaly that can happen when using the tableabove. b)propose a relational database to store the information: draw an entity-relationship diagram andwrite a database design outline.