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.
|
Question on patent system
: Government involvement in general scientific research has been justified on the grounds that advances in knowledge are public goods- once produced, information can be shared at virtually no cost.
|
|
Determining linear programming-maximizing profits
: A manufacturer of outdoor clothing makes wax jackets and trousers. Each jacket requires 1 hour to manufacture, whereas each pair of trousers takes 40 minutes.
|
|
Marginal physical product of labor
: Use the following information for a company's output at various levels of employment to compute: its marginal physical product of labor schedule; its schedule,
|
|
Relationship between ap and mp
: Explain the relationship between AP and MP. Be sure to use graphs to help support your answer. Calculate the MP and the AP for each worker
|
|
Sketch er diagram to keep track of employees and projects
: Sketch ER diagram for the following situation and write any assumptions you think you have to make to develop a complete diagram. Company requires the operational database to keep track of all employees, departments, and projects.
|
|
Steady state level of capital
: Suppose that the rate of depreciation as well as the rate of saving are each .10. Also assume that there is no technological nor population growth.
|
|
Determining optimal production level
: What is the Marginal Cost? What is the Average Cost? What is the optimal production level where production costs are the lowest per unit?
|
|
Ddefinition of poverty
: Everyone thinks there is a problem with the United State poverty figures. The conservatives think so: The Heritage Foundation calls the figures, A Soviet-style disinformation campaign.
|
|
Write a program learn multiplication
: Write a program which will help the elementary school student learn multiplication. Use Random object to produce two positive one-digit integers.
|