Customers (CID, CName, CAddress, CPhone#, Favorite Activity, Device Type, Device Model, Device Manufacturer, Device Serial#) Performed (CID, CName, CAddress, CPhone#, Activity, Date, Time, Duration, Calories Burned, Average Heart Rate, Location ID, Location Name, Location Longitude/Latitude) Challenges (Challenge Name, Challenge Start Date, Challenge End Date, Total Distance required, List of Customer Participants) The Favorite Activity" of a customer must be a valid "Activity", and, of course, anything performed must be a valid "Activity" as well. The above spreadsheets do not provide a way for a customer to own more than one device. There is no way in the above spreadsheets to record that a challenge involves a particular activity, nor that it is to be done at a specific location. There is no way in the above spreadsheets to record that a customer has signed up for a challenge. There is no way in the above spreadsheets to record that a particular Performed" entry is to be counted as being part of meeting the requirements of a challenge. Your task is to build a database for this enterprise using the Entity Relationship Model. Specifically, upon completion of this design, I want you to turn in the following: 1. (40 pts) A list of entities (with their attributes) and a list of relationships. You will need to write a short paragraph describing each entity (be sure to be specific about what attributes are unique). A brief description of each relationship is required as well. 2. (30 pts) An E-R Diagram for your solution, complete with the mapping labels. 3. (20 pts) A set of tables derived from your E-R Diagram. Give the name of each table along with its columns. Make SURE the set of attributes of your tables is a separate listing from your list of entity attributes. Also, make sure you describe how the set of tables was derived from the E-R Diagram, if it is not part of the normal algorithm. Highlight the primary key and any foreign