Tracking project work queries and reports

Assignment Help Management Theories

Reference no: EM131049692

Tracking Project Work Queries and Reports

You are responsible for managing information systems development projects at AAA Systems. To better track progress in completing projects, you have decided to maintain a simple database table to track the time your employees spend on various tasks and the projects with which they are associated. It will also allow you to keep track of employees' billable hours each week. The table below provides a sample data set.

a. Build a database table to store the data shown and enter the records as a set of sample data.

b. Create a query that will list the hours worked for all workers who worked more than 40 hours during production week 20.

c. Create a report grouped by project that will show the number of hours devoted to each task on the project and the subtotal number of hours devoted to each project, as well as a grand total of all hours worked.

d. Create a report grouped by employee that will show each employee's hours worked on each task and total hours worked. The user should be able to select a production week and find data for just that week presented.

Reference no: EM131049692

Questions Cloud

The company pays no taxes at present : Freiburg Company wants to buy a machine that has expected life of 6 years. It costs $30,000, and increases the income of the company by $7,000 annually. It has a salvage value of $5,000. The proper discount rate is 12%, and the company pays no taxes ..

Prepared statements in php : One of the method of preventing SQL injection is by using prepared Statements in PHP. Using that concept write a snippet you would use to add users to a MySQL database from a web-form.

Write an essay on report by complete college america : Write an essay on A September, 2013 report by Complete College America, a group seeking to raise college graduation rates, found that, in Texas, out of every 100 students who enroll in a public college.

Commercial project for an institution : You are a software developer doing a commercial project for an institution. Taking Python as your development language, give two advantages of using python for that task.

Tracking project work queries and reports : You are responsible for managing information systems development projects at AAA Systems. To better track progress in completing projects, you have decided to maintain a simple database table to track the time your employees spend on various tasks..

How does data quality impact business performance : How does data quality impact business performance? Why is data mining so important and what tools and techniques are available to make this process easier?

Analyze factors that contributed to the policy development : Describe how it was an alternative solution/strategy to its predecessor policy. Analyze the factors that contributed to the policy's development.

The spot exchange rate and forward exchange rate : Suppose on July 1st, 2003, Porsche expected $1 million sales from the U.S. at the end of July. On July 1st, 2003, the spot exchange rate was $1.1362/€, the 30-day forward exchange rate was $1.1400/€, and the 60-day forward exchange rate was $1.1450/€..

Assume that radiology group practice has cost structure : Assume that a radiology group practice has the following cost structure. Fixed Costs $500,000 Variable Cost Per Procedure 25. Furthermore, assume that the group expects to perform 7,500 procedures in the coming year. Construct the group’s base case p..

User Account

All Pages