----

Hello,

__________________________________________________________________________________

100% accuracy

------------------------------------------------------------------------------------------------------------------------------------------

Are you familiar with database analysis and diagrams?

Please walk me through the process of how to interprete the requirement provided below for a software/database project.

Also, draw the E-R Diagram and tell me how it was done including tools/application used.

Thanks

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Database Design:

A company is organized into departments. Each department has a name, an unique number, and an employee who manages the department. We keep track of the start date when the employee began managing the dept. A dept may have several locations.

A dept controls a number of projects, each of which has a name, unique number, and single location.

We store each employees name, SSN, address, salary, sex, and DOB. An employee is assigned to one dept but may work on several projects, which are not necessary controlled by the same dept. We keep track of the number of hours per week that an employee works for each project. We also keep track of the direct supervisor of each employee.

We want to keep track of the dependents of each employee for insurance purpose. We keep each dependents first name sex, DOB, and relationship to the employee.

Draw the E-R diagram. Which application did you use to draw ER Diagram?