Database Concepts

Task:
In this Assignment, you will apply what you learned in your Reading and in Seminar to translate a logical model into a physical model, an actual Access database. Microsoft Access is widely used in small businesses. You are adding a valuable skillset in being able to design and implement a Microsoft Access database. Assignment Instructions 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. Here are the paper requirements: APA format which includes a title page, reference page, and at least 2 pages for the body of the paper.
Explains how you implemented the physical model from your logical model.
An explanation of how you identified your columns. Are there any security concerns with the column?
Describe how you choose the data types for each column.
A screen shot showing the columns for each table.
A drawing of your physical model Points deducted for spelling, grammar, and errors. Plagiarism is totally unacceptable. 



 Read less