1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
KonstantinChe [14]
3 years ago
15

Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state th

em for each situation.) Draw the same situation using the tool you have been told to use in the course. a. A company has a number of employees. The attributes of EMPLOYEE include Employee ID (identifier), Name, Address, and Birthdate. The company also has several projects. Attributes of PROJECT include Project ID (identifier), 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 (Billing Rate) for each employee when assigned to a particular project. Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names. Do you have any associative entities on your ERD? If so, what are the identifiers for those associative entities? Does your ERD allow a project to be created before it has any employees assigned to it? Explain. How would you change your ERD if the Billing Rate could change in the middle of a project? b. 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 (identifier), Name, and Phone No. Attributes of PROJECT include Project ID (identifier) and Start Date. Attributes of EQUIPMENT include Serial No and Cost The organization wishes to record Assign Date—that is, the date when a given equipment item was assigned to a particular chemist working on a specified 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. Provide good definitions for all of the relationships in this situation. c. A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION? d. A hospital has a large number of registered physicians. Attributes of PHYSICIAN include Physician ID (the identifier) and Specialty. Patients are admitted to the hospital by physicians. Attributes of PATIENT include Patient ID (the identifier) and Patient Name. Any patient who is admitted must have exactly one admitting physician. A physician may optionally admit any number of patients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients, or may not treat any patient& Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment (Treatment Detail). Components of Treatment Detail include Date, Time, and Results. Did you draw more than one relationship between physician and patient? Why or why not? Did you include hncnithi ac an antitv type? Why or why not?
Engineering
1 answer:
Julli [10]3 years ago
3 0

Answer:

it wqas red

Explanation:

red

You might be interested in
Of the cost reduction strategies for workers' compensation mentioned in the required readings, which one do you think would work
Vesnalui [34]

In industries together with production, we want people to address the manufacturing of merchandise and the usage of heavy machinery.

<h3>What is the painting situation?</h3>

In such painting situations, people are at risk of injuries, and this prices the maximum for the company. So so that you can put into effect value discount is such conditions we want to have right coincidence cowl plans for the people and make sure all of the protection precautions are taken withinside the factory.

  1. The people have to be properly educated on using protection measures and in case any injuries arise we have to have coverage claims in order that we not want to make investments extra cash and we also can offer protection and protection to the people.
  2. This approach is excellent for this enterprise due to the fact regardless of what number of precautions we take people are uncovered to fitness risks and as a result having the right coverage insurance is a superb value discount strategy.

Read more bout the compensation :

brainly.com/question/25273589

#SPJ1

3 0
1 year ago
An escalator handles a steady load of 26 people per minute in elevating them from the first to the second floor through a vertic
photoshop1234 [79]

Answer:

\eta = 70.711\,\%

Explanation:

The power needed to make the escalator working is obtained by means of the Work-Energy Theorem:

\dot W  = \dot U_{g}

\dot W = \dot n \cdot m_{p}\cdot g \cdot \Delta y

\dot W = \left(26\,\frac{persons}{min}\right)\cdot (124\,lbm)\cdot \left(32.174\,\frac{ft}{s^{2}}\right)\cdot \left(\frac{1\,lbf}{32.174\,\frac{lbm\cdot ft}{s^{2}} } \right)\cdot (27.5\,ft)

\dot W = 88660\,\frac{lbf\cdot ft}{min}\,\left(2.687\,hp\right)

The mechanical efficiency of the escalator is:

\eta = \frac{2.687\,hp}{3.8\,hp}\times 100\,\%

\eta = 70.711\,\%

3 0
3 years ago
A(n) ____ is an object setting used to control the visible display of objects.
KatRina [158]
Remote?? maybe I’m not really sure
3 0
3 years ago
technician a says that dirt bypassing the filter on many common rail injectors can cause an injector to stick open and continuou
NNADVOKAT [17]

Technician a is correct because he says that Many common rail injectors filters can be bypassed by dirt, which can lead to an injector sticking open and continuously fueling a cylinder.

Coalescence is used to separate the water and fuel. To the fuel injector cleaning kit, fasten your air compressor. Diesel engines run at compression ratios that are greater than those of gasoline engines. greater ratio compared to gasoline engines. increased thermal expansion as a result. more fuel energy that is transformed into usable power. The great benefit of using a dry cylinder sleeve is that by quickly installing new sleeves, the cylinder block can be quickly restored to its original specifications. Vacuum drying can be used to get rid of small amounts of water. A nozzle is used to spray the fuel into the vacuum chamber of engines. Air and unsolved free water are taken out of the oil. The fuel is evenly dispersed, which facilitates efficient drying.

Learn more about injectors here:

brainly.com/question/27969202

#SPJ4

3 0
1 year ago
Jerry wants to manufacture flat metal sheets. Which process will he use?
Marina CMI [18]
Option choice d is the correct answer
5 0
3 years ago
Other questions:
  • A sign erected on uneven ground is guyed by cables EF and EG. If the force exerted by cable EF at E is 46 lb, determine the mome
    13·1 answer
  • : A pneumatic "cannon" is a device that launches a low mass projectile from a cylindrical tube using pressurized air stored upst
    6·1 answer
  • Water flows with a velocity of 3 m/s in a rectangular channel 3 m wide at a depth of 3 m. What is the change in depth and in wat
    9·1 answer
  • Consider a 400 mm × 400 mm window in an aircraft. For a temperature difference of 90°C from the inner to the outer surface of th
    10·1 answer
  • Which type of engineer is needed in the following scenario?
    14·2 answers
  • Only respond if your the person im talkin to
    14·1 answer
  • Which 1 of the following did women NOT do during WWII?
    6·2 answers
  • Find the value of L
    9·1 answer
  • The product of two factors is 4,500. If one of the factors is 90, which is the other factor?
    15·1 answer
  • 5. Which of the following is false about onStep?
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!