Draw entity relationship model for project management system

Assignment Help Software Engineering

Reference no: EM1352638

Q1) A computer consultancy undertakes a number of projects. A project is for either an external client or an internal department. A project must be for one or the other. A client or department may have several projects on the go. Some departments and clients are stored in the system even if there are no current projects for them. A project is split up into stages and there must be at least one stage stored in the system for each project. Consultants are allocated for each stage of a project. One consultant may be involved with several stages and each stage may have several consultants. Consultant details are still stored in the system even if they are not allocated to stages. For each project, one of the consultants must be the project leader. A consultant is not necessarily a project leader, but they can only be project leader for one project.

a. Outline the steps for drawing an entity relationship model of the project management System

a. Draw an entity relationship model for the project management System

b. Explain the steps required to validate such a model via normalization.

Reference no: EM1352638

Questions Cloud

Measuring quality and customer satisfaction : Describe some Examples of the tools and techniques used to measure quality customer satisfaction

Write down a paper analyzing different approaches : Write down a paper analyzing different approaches that might be used by Keynesian theorists and monetary theorists to promote long-run macroeconomic stability.

Show organizational behavior success of different practices : Organizational Behavior Success of Different Practices - How can two successful companies have such different approaches to employment security? How can they both work? What implications can you derive from the success of these different practices.

Meta-cognitive skills and cognitive flexibility : Why does some empirical evidence suggest that bilingualism can increase meta-cognitive skills and cognitive flexibility, and even perfect some perceptual tasks,

Draw entity relationship model for project management system : A consultant is not necessarily a project leader, but they can only be project leader for one project. Draw an entity relationship model for the project management System.

What is the line spacing of the diffraction grating : A cylinder of gas at room temperature (20°C) has a pressure p1. To what temperature in degrees Celsius would the temperature have to be increased for pressure to be 2.7p1.

What role training plays in an individual''s ability : Organizational Training - What role do you think training plays in an individual's ability to trust others?

Relationship between language and cognition : An analysis of the relationship between language and cognition. Explain the importance of understanding this relationship.

What cost does an impact industry pay for capital : What cost does an impact industry pay for capital. What is the total price of producing 120,180, and 240 units of output in the long run.

User Account

All Pages