data base

Description: Working in a team of two members, you have to design a Database for an organization.

The project will be completed and submitted incrementally. You will have to submit the project in three phases. Every increment submission will be accompanied by a presentation of completed work.

In the first phase you need to work on the following: (30 points)

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: (40 points)

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: (30 points)

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