Sketch er diagram to keep track of employees and projects

Assignment Help Software Engineering
Reference no: EM1371777

Draw an ER diagram for the following situation and state any assumptions you believe you have to make in order to develop a complete diagram:

AAAAA Tech, Inc., has 10 departments and about 4000 employees. The company needs an operational database to keep track of all employees, departments, and projects. Every employee has an employee number, social security number, employed year, current name, and other names used. Each employee has a certain position in a department, and may have dependents. For each dependent, a dependent name and age are stored in the database. There are two types of employees: marketing employees and engineering employees. Each marketing employee has a list of products. Each engineering employee works in one or more research areas, and the company has defined a set of research areas. Each department has a unique department number, a department name, and an address. Each employee can be involved in up to 3 projects, and a project is carried out by up to 10 employees. Each project must have one project head (i.e., an employee), a unique project number, and a project name. There are several other companies who supply various parts for the projects. AAAAA Tech wants to keep track of these suppliers, the parts they supply, and their prices. Each supplier is represented by a unique supplier number, supplier name, and address. A part can be a component of another part. For each part, a unique part number and a part name are stored. A project may need various parts and a part can be used in multiple projects.

Reference no: EM1371777

Create a solution in java file

Assume you have been asked through a tax return preparer to create a program which will help him calculate taxes. This preparer will at most have one hundred customers.

Requirements and architecture relationship

"Requirements and Architecture Relationship" Please respond to the following: Describe a situation where you might start the design of a software system before the requireme

Perform a financial analysis of the total costs

Present the pros and cons or benefit analysis for each of the 3 proposals. Perform a financial analysis of the total costs for each proposal that includes ongoing support and

Create a behavioral model that identifies events

You have been asked to lead a software development team to build a system fulfilling the Statement of Need below. Develop initial notes of the structure/functionality of the s

Over a local news agency in stourbridge

Nash has recently taken over a local news agency in Stourbridge. Part of the deal was the sale of a laptop and software called Newsflash which manages all local newspaper de

Changes require to make to premiere products database design

Indicate changes (using shorthand representation) which you would require to make to Premiere Products database design to support following requirements.

Reply to post - mobile devices

Mobile devices provide a great platform for friends and family to share pictures and stay in touch, however, they can easily be manipulated to share too much information as

Track and monitor the reuse history of a component

As a software engineer, what are the means of tracking you would use to track and monitor the reuse history of a component? Provide a rationale for the elements you list


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd