A Project management company approached your IT company for a system to keep track of their...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A Project management company approached your IT company for a system to keep track of their projects. It is possible for an employee to work on more than one project. Each employee will have only one job title, e.g., System analyst, Project manager, Programmer etc. The company will be working on many projects at the same time. Each project will have only one client. Each project must be managed by only one Project manager. Adjusted from Source: Coronel, C., Morris, S. & Rob, P. 2011. Database principles: Fundamentals of design, implementation, and management. Cengage leaming p 190. 5.1 Create a class diagram to keep track of their projects. Indicate possible attributes. operations, relationship names and multiplicities. (20 Marks) 5.2 Employees can be classified as part time, full-time, or contract employees. Illustrate with a diagram how this can be implemented with generalisation. (5 Marks) A Project management company approached your IT company for a system to keep track of their projects. It is possible for an employee to work on more than one project. Each employee will have only one job title, e.g., System analyst, Project manager, Programmer etc. The company will be working on many projects at the same time. Each project will have only one client. Each project must be managed by only one Project manager. Adjusted from Source: Coronel, C., Morris, S. & Rob, P. 2011. Database principles: Fundamentals of design, implementation, and management. Cengage leaming p 190. 5.1 Create a class diagram to keep track of their projects. Indicate possible attributes. operations, relationship names and multiplicities. (20 Marks) 5.2 Employees can be classified as part time, full-time, or contract employees. Illustrate with a diagram how this can be implemented with generalisation. (5 Marks)
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these accounting questions
-
A cellular operator needs a database to keep track of its customers, their subscription plans, and the handsets (mobile phones) that they are using. The E-R diagram in Figure 2-24 illustrates the key...
-
A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the...
-
A math instructor asked her students to keep track of how much time each spent studying a chapter on functions in her algebra-trigonometry course. She collected the information together with test...
-
If we define the median of a sequence as a number so that exactly as many elements come before it in the sequence as come after it, fix the program in 4.6.3 so that it always prints out a median....
-
Monroe Corporation imports merchandise from some Canadian companies and exports its own products to other Canadian companies. The unadjusted accounts denominated in Canadian dollars at December 31,...
-
c and d are unsigned chars. What is the value in hexadecimal) of ( cd) if c has the value oxa3, and d 0x91? [1]
-
How should the leaving chief executive be involved in the succession planning and transition process?
-
The following information relates to Joachim Anderson, Realtor, at the close of the fiscal year ending December 31: 1. Joachim paid the local newspaper S335 for an advertisement to be run in January...
-
This level of the scale describes a low level change in usual behavior that does not engage anyone else.
-
Since its 100% acquisition of Dancer Corporation stock on December 31, 2012, Jones Corporation has maintained its investment under the equity method. However, due to Dancer's earning potential, the...
-
Tiffany has started tutoring students x hours per week. The tutoring job corresponds to the following additional income: a. Graph the polynomial function. b. Give any real zeros that occur. c. How...
-
How might property acquired in contemplation of marriage be classified? Why? What about property acquired during premarital cohabitation? Why?
-
Explain the concept of continuing, exclusive modification jurisdiction under PKPA. When is that jurisdiction lost?
-
What cut-off dates are commonly used for determining when property will no longer be considered marital?
-
What is meant by the term "divisible divorce"?
-
Explain the jurisdictional concepts that are relevant to the distribution of property.
-
Please provide a statement that addresses your educational journey, your reasons for transferring, and the objectives you hope to achieve. #I am a Cybersecurity student
-
TRUE-FALSE QUESTIONS 1. In terms of preliminary analytical procedures, assume that the company has introduced a new product with a low price point and significant customer demand. The auditor would...
-
What are the four main types of NoSQL database management systems?
-
Write and execute a variety of queries to test the functionality of your database based on what you learned in this chapter. Don't panic if you can't write all the queries; many of the queries will...
-
Explain the purpose of the CHECK clause within a CREATE TABLE SQL command. Explain the purpose of the WITH CHECK OPTION in a CREATE VIEW SQL command.
-
Use the health expenditure data of Section 16.6. The model is a probit regression of DMED, an indicator variable for positive health expenditures, against the 17 regressors listed in the second...
-
Suppose we obtain a kernel density estimate using the uniform kernel (see Table 9.1) with \(h=1\) and a sample of size \(N=100\). Suppose in fact the data \(x \sim \mathcal{N}[0,1]\). (a) Calculate...
-
Suppose we obtain a kernel regression estimate using a uniform kernel (see Table 9.1) with \(h=1\) and a sample of size \(N=100\). Suppose in fact the data \(x \sim \mathcal{N}[0,1]\) and the...
Study smarter with the SolutionInn App