1. Illustrate the concept of Normalization by means of a dependency diagram thatshows how the spreadsheet in Figure 1 would look in Third-Normal-FormYou may use any diagramming tool to draw the diagram.2. Illustrate a conceptual design of the database that needs to be built for GoldenGardens by means of an ER Diagram that reflects the dependency diagram producedin Question 1. Show the data types of all attributes in your entities.You may use any diagramming tool to draw the ER diagram.DBMS-created diagrams are not allowed.• Allowed notations: Crow's foot, Chen Model and UML. JoziCleaners is local cleaning service that is looking to upgrade their current operations bymaking use of a database to keep track of the teams, houses, clients and billings of each clientper/week.Each house is cleaned by one or more teams. A team goes out to a particular house on a certainday of the week. Each cleaning team has a team leader. Every cleaner eams R150 per day,except the team leader who earns a unique amount.The report that the JoziCleaners' manager produced in Microsoft Excel is illustrated as aspreadsheet in Figure 1 below.DayClientClient NameTeam MembersTeam LeaderLeaderTotalCodeIDWageMondayAeliana GebahardT36.Jaymes MerricksonR 350R 850C10Alfher DareiaT1Geoffrey GloverR 250R 750C8Felina DiodotusT2Elmer VictorsonR 300R 700Brutus SigihildSigibert QuirinusBrutus SigihildC9T4Norris MamadouR 400R1 000TuesdayCST3Jaymes MerricksonR 350R 850C9T25Elmer VictorsonR 300R 700Alfher DareiaDuncan GardynerGeoffrey GloverC10T55R450R 850C7Servius AmbrosiaT16.R 250R750C10Alfher DareiaT2Elmer VictorsonR 300R 700WednesdayC10Alfher DareiaT36.Jaymes MerricksonR 350R850C1Nikolaos GallusT47Norris MamadouR 400R1 000C3Amalia ProchorosT25Elmer VictorsonR 300R 700C8Felina DiodotusT3Jaymes Merrickson R 350R 850Thursday C2Hariwini AgrippaT47Norris MamadouR 400R1 000C9Brutus SigihildT2Elmer VictorsonR 300R 700CSSigibert QuirinusT25Elmer VictorsonR 300R 700C6Artemisia Hippolytos T36.Jaymes MerricksonR 350R850FridayC8Felina DiodotusT25Elmer VictorsonR 300R 700Geoffrey GloverGeoffrey GloverC4Aeliana GebahardT16.R 250R 750C9Brutus SigihildT1R 250R 750Servius AmbrosiaT47Norris MamadouR 400R1 000C2Hariwini AgrippaT36Jaymes MerricksonR 350R850Figure 1: JoziCleaners' report

Question

Accepted Answer

An entity is an object in the real world with an independent existence that can be differentiated…