Database Queries and Reports
Database Queries and Reports
You are responsible for managing information system 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 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.
Project_Name
Task Name
Employee_ID
Production Week
Hours Worked
Fin-Goods- Inv
App. Devel.
456
21
42
Fin-Goods-Inv
DB Design
345
20
20
Fin-Goods- Inv
VI Design
234
20
16
HR
Analysis
234
21
24
HR
Analysis
456
20
48
HR
VI Design
123
20
8
HR
VI Design
123
21
40
HR
VI Design
234
21
32
Shipmt -Tracking
DB Design
345
20
24
Shipmt-τracking
DB Design
345
21
16
Shipmt -Tracking
DB Development
345
21
20
Shipmt- Tracking
VI Design
123
20
32
Shipmt- Tracking
VI Design
234
20
24
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 is 20.
c. Create a report grouped by employee that will show their hours worked on each task and the total hours worked. The user should be able to select a production week and have data only for the week presented.
d. What major trends are occurring in software? What capabilities do you expect to see in future software packages?
e. How do the different roles of system software and application software affect you as a business end user? How do you see this changing in the future?
You are responsible for managing information system 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 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.
Project_Name
Task Name
Employee_ID
Production Week
Hours Worked
Fin-Goods- Inv
App. Devel.
456
21
42
Fin-Goods-Inv
DB Design
345
20
20
Fin-Goods- Inv
VI Design
234
20
16
HR
Analysis
234
21
24
HR
Analysis
456
20
48
HR
VI Design
123
20
8
HR
VI Design
123
21
40
HR
VI Design
234
21
32
Shipmt -Tracking
DB Design
345
20
24
Shipmt-τracking
DB Design
345
21
16
Shipmt -Tracking
DB Development
345
21
20
Shipmt- Tracking
VI Design
123
20
32
Shipmt- Tracking
VI Design
234
20
24
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 is 20.
c. Create a report grouped by employee that will show their hours worked on each task and the total hours worked. The user should be able to select a production week and have data only for the week presented.
d. What major trends are occurring in software? What capabilities do you expect to see in future software packages?
e. How do the different roles of system software and application software affect you as a business end user? How do you see this changing in the future?