Attributes of employee include employee id

Assignment Help Basic Computer Science
Reference no: EM131275096

Draw ERD for each of the following situation and submit your drawings (hand-drawing, Visio etc. are all accepted) in Word format with your name on the document:

A company has a number of employees. The attributes of EMPLOYEE include Employee ID, Name, Address, and Birthdate. The company also has several projects. Attributes of PROJECT include Project ID, Project Name, and Start Date. Each employee may be assigned to one or more projects, or may not be assigned to a project. A project must have at least one employee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate for each employee when assigned to a particular project.

A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project.

Attributes of CHEMIST include Employee ID, Name, and Phone No. Attributes of PROJECT include project ID, and start date. Attributes of
EQUIPMENT include serial number and cost. The organization wishes to record assign date - the date when a given equipment item was assigned to a particular chemist working on a specific project. A chemist must be assigned to at least one project and one equipment item.

A given equipment item need not be assigned, and a given project need not be assigned either a chemist or an equipment item.

Reference no: EM131275096

Questions Cloud

Determine the solidification temperature : If the cooling curve was obtained at the center of the casting sketched in the figure, determine the mold constant, assuming that n = 2.
Sector of economy especially on technology : Software engineers play a significant role in any sector of economy especially on technology related areas..list some of the responsibilities of software engineers.
Why a cooperative could not claim to be a syndicate : What is the distinction between a general partnership and a limited partnership?-  Explain why a cooperative could not claim to be a syndicate.
How each of the layouts enhance or hinder productivity : Choose two fast food franchises, such as McDonalds and Burger King, and examine their facility layouts. Compare and contrast both food franchises, and discuss the differences in their layouts.
Attributes of employee include employee id : A company has a number of employees. The attributes of EMPLOYEE include Employee ID, Name, Address, and Birthdate. The company also has several projects. Attributes of PROJECT include Project ID
How where you able to identify the agent in a laboratory : How where you able to identify the agent in a laboratory? Describe the etiology. How did the infection make its way to the farm? Trace the fictional outbreak from its origins either locally, nationally or internationally.
What are the requirements of holder in due course status : Explain the rationale for the following statement: "The purpose of holder-in-due-course status is to encourage parties to engage in financial transactions."
How can solid solutions form in ceramic systems : Do we need 100% solid solubility to form a solid solution of one material in another?
What are the attributes of a particularly dangerous disease : What are the attributes of a particularly dangerous emerging infectious disease? What features of modern society influence dissemination of viral diseases of this nature?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Smp and massively parallel processing

What are the components used in SMP and Massively Parallel Processing (MPP) machines?

  Write program determines for each sales person their salary

This must be written in C++. A company pays its salespeople on a commission basis. The salespeople each receive $200 per week plus a 9 percent commission of their gross sales for the sales period.

  Marketing communications planning

Managing and coordinating the complete communications practice calls for thorough marketing communications planning. It is important to identify the added value of an inclusive plan that assesses the tactical roles of an assortment of communicatio..

  Homework assignment in electronic format

Please feel free to submit your homework assignment in electronic Format: WORD (preferred) or PDF documents.

  Draw a block diagram of the pcm system

Specify the number of uniform quantization steps needed and the channel null bandwidth required, assuming that the peak signal-to-noise ratio at the receiver output needs to be at least 30 dB and that polar NRZ signaling is used.

  Write a report with matlab simulations about the maximum

Partial feedback II: only SINR at each antenna element is known at the transmitter (full and quantized).

  Difference in real gdp per capita between country

Suppose that yA(0) = yB(0) = 1, gA = 2% and gB = 4%. What is the (log) difference in real GDP per capita between country A and B when t = 50?

  Application that allows you to enter any first name

Create a program that accepts a series of employee ID numbers, first names and last names from the keyboard and saves the data to a file. Save the program as WriteEmployeeList.java. When you execute the program, be sure to enter multiple records..

  Determine the number of gates needed to implement

Determine the number of gates needed to implement an eight-bit carry-lookahead adder assuming that the maximum fan-in for the gates is four.

  Main advantage b-trees

Explain the main advantage B-trees have over a multilevel index of the type.

  What you think are the major characteristics of a project

What you think are the major characteristics of a project?

  Define some classes for providing random numbers

Define some classes for providing random numbers of certain distributions (for example, uniform and exponential). Each class has a constructor specifying parameters for the distribution and a function drawthat returns the next value.

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