Reference no: EM133684452
IT Project Management
Answer the Following Questions
Question 1: Given the time-phased work packages and network, complete the baseline budget form for the project.
Question 2: How can outsourcing project work alleviate the three most common problems associated with Multiproject resource scheduling? Briefly explain.
Question 3: A software company is tasked with developing a new mobile application within a tight deadline. The project involves various stages such as design, development, testing, and deployment. Project faces some challenges which are given below.
Deadline constraint: The project must be completed within 6 months to meet market demands and stay ahead of competitors.
Resource constraints: Limited availability of developers and specialized software tools may impact project progress.
Given the limited availability of developers and specialized tools, how would you optimize resource scheduling to maximize efficiency and meet project deadlines within the 6-month timeframe? Briefly explain.
Normalization of Database Tables
What is normalization? When is a table in 1NF?
Given the dependency diagram shown in Figure 1, answer the following questions
Identify and discuss each of the indicated dependencies
Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table.
Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table.
The dependency diagram in Fig 2 indicates that a patient can receive many prescriptions for one or more medicines over time. Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table.
What is a partial dependency? With what normal form is it associated?
What three data anomalies are likely to be the result of data redundancy? How can such anomalies be eliminated?