Reference no: EM131214218
Introduce specialization/generalization concepts into the ER model shown in Figure 7.5 and described in Exercise 6.10. Use the enhanced concepts to show that there are two types of employees, namely permanent and temporary. The total number of days off due to sickness is recorded for all staff. The total annual holiday entitlement and the number of days taken are recorded for permanent staff only. Only permanent staffare required to provide an employment history, if previously employed.
Exercise 6.10
Create an ER model for each of the following descriptions:
(a) Each company operates four departments, and each department belongs to one company. Each company has a unique name, and each department has a unique number and name.
(b) Each department in part (a) employs one or more employees, and each employee works for one department. Each employee has a number, name (including first and last name), date of birth, and age.
(c) Each of the employees in part (b) may or may not have one or more dependants, and each dependant belongs to one employee. Each dependant has a name, relationship to employee, and contact telephone numbers up to a maximum of three.
(d) Each employee in part (c) may or may not have an employment history. Each employment history has the name of the organization that the employee worked for and in what capacity, the start date and finish date for each employment.
(e) Represent all the ER models described in (a), (b), (c), and (d) as a single ER model. Provide any assumptions necessary to support your model.
|
Identify three issues relevant to the field of psychology
: Your three to four page paper should summarize the details of the case and identify three issues relevant to the field of psychology. In the Weston situation examples of two such questions might be, what potential conflicts of interest might aris..
|
|
Prepare to discuss the choosen article
: Prepare to discuss the article you find at the beginning of the next class and submit a printed copy to the instructor. This will count towards your participation grade.
|
|
Number of pages with moderate and high graphics
: A sample of four pages is selected without replacement, and X and Y denote the number of pages with moderate and high graphics output in the sample. Determine fXY (x; y), fX(x), E(X), fY j3(y) and E(Y jX = 3). Are X and Y independent?
|
|
Likelihood that non of the selected experiments
: 1) What is the probability that all three experiments are successfully performed? 2) What is the likelihood that non of the selected experiments are successfully performed? 3) Atleast one of the selected experiments is successfully performed?
|
|
Create an er model for each of the following description
: Each company operates four departments, and each department belongs to one company. Each company has a unique name, and each department has a unique number and name.
|
|
Compare theory of normal and abnormal development
: Review the three personality theories we've covered thus far and compare and contrast each theory's description of normal and abnormal development. Which theory best fits with your own personal theory of development?
|
|
Determine the magnitude of the power supplied
: Determine the current supplied by the 40 V source in the circuit.- Determine the magnitude of the power supplied by the 40 V source in the circuit.
|
|
Why is information security a management problem
: Why is information security a management problem? What can management do that technology cannot? Why is data the most important asset an organization possesses? What other assets in the organization require protection?
|
|
Appropriate model for the number of offices
: She is visiting 20 offices this week. Assume the binomial is an appropriate model for the number of offices that make the purchase. What is the probability that exactly 4 of them will make a purchase? (give your answer to 4 decimal places as a nu..
|