Project Assignment: Designing a Database using MS Access
Description: Working in a team of two members, you have to design a Database for an organization.
In the first phase you need to work on the following:
1. Determine the purpose of your database
2. Design the DFD (Data Flow Diagram) for your system. Recommended tool to design DFD is MS Visio or Visual Paradigm but it is not required.
3. Design the ERD (Entity Relationship Diagram)
In the second phase you need to work on the following:
1. Find and organize the information required
2. Divide your information items into major entities or subjects, such as Products or Orders. Each subject then becomes a table.
3. Decide what information you want to store in each table. Each item becomes a field, and is displayed as a column in the table. For example, an Employees table might include fields such as Last Name and Hire Date.
4. Choose each table's primary key. The primary key is a column that is used to uniquely identify each row. An example might be Product ID or Order ID.
In the third & final phase you need to the following:
1. Apply the data normalization rules to see if your tables are structured correctly. Make adjustments to the tables, as needed.
2. Write SQL (Structured Query language) to retrieve the data
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.