Reference no: EM133696161
IT Project Management
Question 1: You are a team member at XYZ Software Solutions, a small software development company. Your team is responsible for developing a new mobile application called "TaskMaster" to streamline task management for users. The project involves multiple stages including planning, design, development, testing, and deployment.
Make a Kanban board for this project in any tool like Asana, Trello etc.
Identify and list tasks associated with each stage of the project on the Kanban board.
Organize the tasks into columns representing different stages of the project.
Establish Work in Progress (WIP) limits for each column on the Kanban board. What factors did you consider while establishing these WIP limits? Briefly explain.
You can judiciously make assumptions about various resources needed for this project.
A screenshot of your Kanban Board is needed. This screenshot must show the date and time from the task bar of your PC or Laptop.
Question 2: Briefly explain any three ways by which project monitoring and evaluation contribute to project success.
Tutorial - Database Performance Tuning and Query Optimization
What is SQL performance tuning?
What is the focus of most performance tuning activities, and why does that focus exist?
How are database statistics obtained?
If indexes are so important, why not index every column in every table? (Include a brief discussion of the role played by data sparsity).
Most query optimization techniques are designed to make the optimizer's work easier. What factors should you keep in mind if you intend to write conditional expressions in SQL code?
What does RAID stand for, and what are some commonly used RAID levels?
Answer questions 7 (a) and (b), based on the following query:
SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX
FROM EMPLOYEE
WHERE EMP_SEX = ‘F' AND EMP_AREACODE = ‘615' ORDER BY EMP_LNAME, EMP_FNAME;
What is the likely data sparsity of the EMP_SEX column?
What indexes should you create? Write the required SQL commands.