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

Research on popular simulation modeling software application

Use the internet to conduct research on popular simulation modeling software applications. Find two applications to compare by examining the costs, features, and training re

What av or malware software do you use

What AV or Malware software do you use? Please include what type of device or OS (Windows, Mac, Android). Share with us three tips you have for protecting yourself online. Use

What is hidden can be changed without risk

What is hidden can be changed without risk and define the terms in each law and explain the law clearly and thoroughly. Illustrate your explanation with practical examples

Conducting unit testing of code

Suppose you are writing a program and you will start to conduct testing on your code as it becomes completed and operational. This is generally called unit testing.

What are the goals of structured systems analysis

What are the goals of structured systems analysis?- Why do we study and document the current physical environment?- Why do we develop a current logical model of an Information

Concepts of software engineering

Explain the software measurement process and state how to implement the software measurement?  List the challenges and difficulties of applying the software metrics?

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

Component interface for an emergency control room

Assignment: Component Interface for an Emergency Control Room - As the lead software engineer for a medium-sized hospital, you have been asked to spearhead an effort to impr


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