Logical Database Model

Instructions: Note that you were to create a physical diagram to include not only the entities and their relationships but also designation of the attributes (field names), primary keys, foreign keys and datatypes. You should be showing each of the tables design in Access as well with screenshots of each. You must have the Access Database system installed for this assignment. Create a physical model using the Access Database system. • You will compose a paper with the following: • An explanation of how you implemented the physical model from the logical model. • An explanation of how you identified the tables. • An explanation of how you identified the columns. • A description of how you chose the data types for each column. • A description of the security implications for each column. • A screen shot showing the columns for each table. • A drawing of your physical model. Minimum Submission Requirements • This Assessment should be a Microsoft Word (minimum 2 pages for the body) document, in addition to the title and reference pages. • Respond to the questions in a thorough manner, providing specific examples of concepts, topics, definitions, and other elements asked for in the questions. Your paper should be highly organized, logical, and focused. • Your paper must be written in Standard English and demonstrate exceptional content, organization, style, and grammar and mechanics. • Your paper should provide a clearly established and sustained viewpoint and purpose. • Your writing should be well ordered, logical and unified, as well as original and insightful. • A separate page at the end of your research paper should contain a list of references, in APA format. Use your textbook, the Library, and the internet for research. • Be sure to cite both in-text and reference list citations were appropriate and reference all sources. Your sources and content should follow proper APA citation style