Homework 6 Database Design Recognizing Entities, Attributes and Relationships Overview The object of this exercise is to come up with the basic relational structure that could exist on the backend to support the information shown in the following brochure: IndyFringe2017.pdf IndyFringe2017.pdfPreview the document. To do this you will reverse engineer the underlying database from the front-end display. The scope of this assignment is restricted to the information found on pages 18-31. Page 17 may also be helpful. NOTES: Make sure that you do not confuse data with attributes and attributes with entities. Entities contain attributes and attributes contain data. What You Will Turn In Your goal is to reverse engineer the information from the brochure on the pages listed above to construct the database behind the scenes, and to report on your findings using the following report format. Entity Relationship Diagram: A visual model which represents each table (entity) and the relationships between the tables (i.e. a Relationship Diagram). Find at least three entities. Technical Summary: The technical summary provides verbal support for the E-R Diagram. The technical summary should answer the questions, "Why this design and not some other?" or "Why are these relationships one-to-many or many-to-many?" This is the portion where you get to talk the database language, at least 1/2 page 12 pt font double-spaced. Field List: Shows the fields for each table (entity) and identifies the primary key (by underlining it). The field list should include all fields which are found in the problem. We will use the Relational Database Shorthand from the Power Point Presentation "Database Concepts" on the Canvas Schedule Page. Note: You are NOT responsible for identifying any foreign keys at this point. Just concentrate on the main fields for each table. NOTE: You should not build this Database using Access or any other Database platform, this is simply logical design. Submit a copy of your report to the appropriate Canvas Assignment Submission Area.