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.