Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Tracking project work. Queries and reports You are responsible for managing information systems development project at AAA systems. To better track progress in completing projects

Tracking project work. Queries and reports You are responsible for managing information systems development project 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 employee 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 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 employees 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database 19c DBA By Examples Installation And Administration

Authors: Ravinder Gupta

1st Edition

B09FC7TQJ6, 979-8469226970

More Books

Students also viewed these Databases questions

Question

Why is the System Build Process an iterative process?

Answered: 1 week ago