Question

Database Analysis and Design (ER diagram)

After the requirement collection and analysis phase the software project of a database application about a company is described as follows:

1. The company is organized into departments. Each department has a name, an unique number, and a particular 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.

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

3. We store each employee's name, SSN, address, salary, gender, and DOB. An employee is assigned to one dept but may work on several projects, which are not necessarily 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.

4. We want to keep track of the dependents of each employee for insurance purpose. We keep each dependent's first name, gender, DOB, and relationship to the employee.

Draw the E-R diagram by Dia tool.

Reference: Fundamentals of Database System, 3rd ed., by Elmasri

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer is as follows :

ERD for given scenario in Crow's Feet notation is as follows :

PK defines the Primary Key.

FK defines the Foreifn Key.

All the attributes and Relationships are set as er given scenario.

No assumptions are there.

if there is any query please ask in comments...

Add a comment
Know the answer?
Add Answer to:
Database Analysis and Design (ER diagram) After the requirement collection and analysis phase the software project...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Project Database Description After the requirement collection and analysis phase the software project of a database...

    Project Database Description After the requirement collection and analysis phase the software project of a database application about a company is described as follows: The company is organized into departments. Each department has an unique name, an unique number, and a particular employee who manages the department. We keep track of the start date when the employee began managing the dept. A dept may have multiple locations(cities). A dept controls a number of projects, each of which has a unique...

  • Oracle Database term Project

    Any help with this project would be greatly appreciated and I will be sure to rate highly for all the help! I just want to turn in something for a grade but I don'tknow where to start. Any help at all please!You are tasked to create an Oracle database for a company to track their employees and projects. After speaking with the customer, you have determined the following asthe user’s needs:The company is organized into departments. Each department has a...

  • 1. {90 points} Your task is to design a 'Company database capable of storing information about...

    1. {90 points} Your task is to design a 'Company database capable of storing information about EM- PLOYEE(S), DEPARTMENT(s), and PROJECT(s). Knowing that: We store each employee's name composite attribute - {10 points}), social security number, address, salary, and telephone number. An employee is assigned to one department, but may work on several projects which are not necessarily controlled by the same department. We keep track of the number of hours that an employee works on each project - {10...

  • SQL Fundamental 3rd ed. by John J. Patrick Final Project. (repost request Edan, or Shirlee)

    Note the link to the database is as followshttp://oracle.ecpicollege.com:8080/apex/f?p=4550:11:516714645771406::NO:::user and password is the same: RicJac7604. Access is under SQL iconNote: Section 1 ER design and section 2 have been done by Shirlee, Section 3 was done by Edan. Section 4 is what I need the final answer for. (request Edan, orShirlee) Thanks for all your help!You were tasked to create an Oracle database for a company to track their employees and projects. After speaking with the customer, you have determined...

  • Projects inc. is an engineering firm with approximately 50 employees A database is required to keep...

    Projects inc. is an engineering firm with approximately 50 employees A database is required to keep track of all employees, their skills, projects assigned and departments worked in. Every employee has a unique number assigned by the firm, required to store her or his name and data of birth. If an employee is currentty married to another employee of Projects tnc. the data of the marriage and who the employee is married to must be stored. Howeer no record of...

  • Problem 1 (25 points) Consider the following database schema: Employee (fname, Iname, ssn, address, salary, mgrssn,...

    Problem 1 (25 points) Consider the following database schema: Employee (fname, Iname, ssn, address, salary, mgrssn, dnumber) Department (dname, dnumber, mgrssn, mngrstartdate) Project (pname, pnumber, plocation, dnumber) Works_On (ssn, pnumber, hours_per_week) Dependent (ssn, dependent name, bdate, relationship) The above relations store information about a company. The meaning of most of the relations and attributes is straightforward. For example, the first relation stores information about employees. The mgrssn is the SSN of the manager (supervisor) of the given employee. A manager...

  • DRAW AN ER DIAGRAM TO MAP IT OUT: The Problem: The database you design should be...

    DRAW AN ER DIAGRAM TO MAP IT OUT: The Problem: The database you design should be for the following scenario: OHIP wants to keep track of it's doctors and patients and hospitals. For the doctors, you must keep track of the doctor's license number. The license number is 4 character alphanumeric, for example 4RG2. Also, you must keep track of the doctor's first name (up to 20 letters), last name(up to 20 letters), specialty (up to 30 letters) and the...

  • Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage ...

    Question 4. ER model (5 points). You are asked to design the ER diagram for a database to manage data for athletes athletic game. Requirements are as follows: Each participating team has a name and a manager. Each athlete has a unique athlete ID, and is also described by first name and last name, gender and age. A team has many athletes but an athlete only belongs to one team. Each sport has a unique code and some sport name....

  • ER DIAGRAMS

    1Consider the following information about a university database:• Professors have an SSN, a name, an age, a rank, and a research specialty.• Projects have a project number, a sponsor name , a starting date, an ending date, and a budget.• Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S.or Ph.D.).• Each project is managed by one professor (known as the project’s principal investigator).• Each project is worked on by one or more professors (known...

  • DATABASE Draw an ER diagram according to the following requirements.   The bank application keeps track of...

    DATABASE Draw an ER diagram according to the following requirements.   The bank application keeps track of the following information. As a customer of the bank, he/she must either own an account or borrow a loan. The banking application does not require a customer to both own account and borrow a loan. Customer information includes a SSN (unique), a name, and an address. A customer can borrow at most one loan. A loan has a loan number (unique) and an amount....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT