Question: Create an ER model for Project Inc. Assignment 6: Data Modeling ER (Entity Relationship) Model: Project, Inc. ed on the following data requirements and business

Create an ER model for Project Inc.

Create an ER model for Project Inc. Assignment 6: Data Modeling ER

Assignment 6: Data Modeling ER (Entity Relationship) Model: Project, Inc. ed on the following data requirements and business rules, construct an ER Model for Project Ino We wish to store information about employees. It is required to store EmpID, first name, last name, address, hire date, and title. An employee may be married to another employee of the company. If an employee is currently married to another employee, the date of marriage should be recorded. An employee belongs to only one department. Each department hires many employees. Each department has a department ID, name, and budget. There is a manager for each department. A manager manages one department and each department is managed by one manager An employee sometimes works on more than one (many) projects. Each project is assigned many employees. Projects are distinguished by project numbers. It is required to maintain information on project name and location. The amount of time (i.e., number of hours) that an employee is assigned to any project must be stored A project uses many equipment. An equipment is assigned to one project at any givern time. The company wishes to store equipment number, name, description and purchase date. A vendor provides many equipment. Each equipment is provided by one vendor endor ID, name, address and contact information must be stored

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!