Question
---- Hello, __________________________________________________________________________________ 100% accuracy ------------------------------------------------------------------------------------------------------------------------------------------ Are you familiar with database analysis and diagrams? Please walk me through the process of how to interprete the
----
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started