Suppose that Heather Sweeney wants to include records of her consulting services in her da...

Suppose that Heather Sweeney wants to include records of her consulting services in her database. Extend the data model in Figure to include CONSULTING_PROJECT and DAILY_PROJECT_HOURS entities. CONSULTING_PROJECT contains data about a particular project for one of Heather’s customers, and DAILY_PROJECT_HOURS contains data about the hours spent and a description of the work accomplished on a particular day for a particular project. Use strong and/or weak entities, as appropriate. Specify minimum and maximum cardinalities. Use the IE Crow’s Foot E-R model for your E-R diagrams.

Figure The Final Data Model for Heather Sweeney Designs