Unit 2
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 learning
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 Dev 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.
