Reference no: EM133672431

IT Project Management

Activity - 1

Question 1: Why is it important to assess the culture of an organization before deciding what project management structure should be used to complete a project? Briefly explain your answer.
Question 2: Other than culture, what other organizational factors should be considered when determining which project management structure to use? Briefly explain your answer.
Question 3: What do you believe is more important for successfully completing a project- the formal project management structure or the culture of the parent organization? Briefly explain your answer.
Question 4: Going to university is analogous to working in a matrix environment in that most students take more than one class and must distribute their time across multiple classes. Briefly explain any three problems that this situation creates for you.

Activity - 2

Question 1: Why are accurate estimates critical to effective project management? Briefly explain.
Question 2: What are the differences between Bottom-up and Top-down estimating approaches? Under what conditions would you prefer one over the other? Briefly explain.
Question 3: You are in charge of organizing a dinner-dance concert for a local charity. You have reserved a hall that will seat 30 couples and have hired a jazz combo (group of few musicians). With a budget of $20,000 allocated for the project, develop a scope statement for this project that contains examples of all the checklist/elements. Assume that the event will occur in 4 weeks and provide your best guess estimate of the dates for milestones.
Question 4: Below is a project WBS with cost apportioned by percents. If the total project cost is estimated to be $600,000, what are the estimated costs for the following deliverables?

Design In-house testing Programming
What weaknesses are inherent in this estimating approach? Briefly explain.

Instructions:
Your work will be assessed on the following criteria:

The accuracy of the answer (40%)
The consistency in the answer (30%)
The level of the communication (30%)

Relational Database Model

What is entity integrity and referential integrity and why are important to a database?

Explain the purpose and function of each of the following relational set operators:

Select
Project
Union
Intersect
Difference
Product

Identify and describe the components of the table shown in figure 1, using correct terminology. Consider knowledge of naming conventions to identify the table's probable foreign key(s).

Identify the Primary Keys
Identify the Foreign keys
Create the ERM
Create the relational diagram to show the relationship between Director and Play.
Considering the Student and Professor tables shown in Figure 3 to illustrate the differences between a natural join, an equijoin, and an outer join.