In a Word document, write the following: 1. For each of the entities, define all of the attributes. Define the data type and nullability of each attribute. Explain your choices. 2. For each of the entities, define the primary key. Define the data type and nullability. Explain your choices. 3. For each of the entities, define any foreign keys. Define the data type and nullability of each key. Explain your choices. 4, Create a logical model diagram using Microsoft Visio, Refer to the leaming activity for an example. Please embed the Visio diagram in your Word document so that you are only submitting a single document for this Assignment What did you refer to while working on this Assignment? Annotate those as your references at the end of the paper. Be sure your work demonstrates the ability to apply critical thinking skills to illustrate sound reasoning. This includes the ability to identify entities, formulate inferences and identify relationships between entities, identify faulty reasoning, assess assumptions, formulate conclusions, and assess what you referred to while you worked on this Assignment. Assignment Requirements Generate the logical design diagram using Microsoft Visio. Microsoft Visio can be obtained at no cost from the Microsoft Azure Dey Tools for Teaching site, which is accessible from the Course Resources section. Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper, Copy the design diagram(s) into your Word document. Be sure to use appropriate APA format and cite your textbook or other sources that you used in the assignment. For more information on APA style formatting, go to Academic Writer under the Academic Tools area of this course. Also review the university policy on plagiarism, If you have any questions, please contact your professor. The assignment is due by the final day of the Unit 2 week