

Based on the readings and videos from this week, use a free software diagram tool such as Creately (Links to an external site.), yED (Links to an external site.), www.draw.io (Links to an external site.), or LucidChart (Links to an external site.) to generate an entity-relationship diagram that satisfies the needs of your problem and depicts your proposed database design. Add notes, comments, scribbles, and anything else to make your diagram easier to understand. Remember, the purpose of the diagram is to help you understand a project and to visualize a relationship among “things”! The below components are the requirements for the assignment “Project Part One”. You will submit your Part One assignment to the instructor by 11:59ET at the end of Week 3. Your data model should include, at minimum, five entities. Your diagram should include: (NOTE: We will not identify Primary Keys in this exercise) • Entities (Tables) • Attributes (Columns) • Identified relationships (remember a relationship always exists between two entities) • Cardinality: one-to-one, one-to-many, many-to-many (Avoid the symbols if you wish. Feel free to use words to identify cardinality.) Iterate your proposed preliminary database model into a final version if necessary. In this version, ensure your proposed tables (entities) match your Final Table List. You may have created a Preliminary Table List, however, for the sake of this project you only need to turn in the Final Table List. This section should include a Final Table List with table names and descriptions. Articulate (in paragraph format) how the mission objectives can be cross-mapped to your final data model. (Be sure to make certain that each objective can indeed be cross-mapped!)