IT163-2: Create relational databases with multiple tables to collect data.

Assignment Overview

In this Assignment, you will apply what you learned in your Reading and in Seminar to translate your logical model created in Unit 3 to 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.

Instructions

You must have the Access Database system installed for this assignment. You will implement the logical design you created in the last unit.

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 your logical model.
• An explanation of how you identified your tables.
• An explanation of how you identified your columns.
• A description of how you chose the data types 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.

The paper must be written in your own words. You are encouraged to read the assigned readings first to gain valuable insight for your paper. If you elect to include some material from the Web, it must be properly referenced via APA standards.