Database Assignment Help

----------------------------------------------------------------------------------------------------------------------------------

Create an Unformatted Work Order report which displays when a work order is assigned to a crew
The ability to assign WO’s has already been complete you just need to create the report that displays the information.
Add a button to the assign work order form to display the report mentioned above when you click on it.
Create a report that displays the information already displayed in the open work order form. This report should be called the open work order report.
New order Entry form
-WO
-Property ID
-Address
-Client
-Zipcode
-Assigned date from Client
-Entered Date (auto)
-Original client request (attachment)
-Client Comments
-(if it is an initial create a -1 WO and a -2)
[saves to a temporary file for review before posting to database, no posting double entries, auto produce report on contradicting entries]

Unassigned Work Order Form
-WO(static)
-Property ID (static)
-Address (Static)
-Zipcode (static)
Crew(pull-down)
Account Manager’s comments
Account manager’s Activities request
Assigned Date (auto)
Estimated completion date
Add Activity types
Client
Type
Rate
Unit of measure

Adjust Property ID form
Property ID (static)
Address
Zipcode

Zipcode to City table


Open Work Order Report
WO
Property ID
Address
Client
Work Order Status
Date
Due Date
Comments
Account Manager

Work Order Processing Form
-WO(static)
-Property ID (static)
-Address (Static)
-Zipcode (static)
Assigned Crew (Static)
AM requested Activities (static)
AM Comments (static)
Estimated completion date (static)
Assigned by 
Actual Activities
Field Comments
Inventory Items Used
Due Date extension (y/n)
Due date extension (date)
Arrival time (time)
Completion time (time)
Photos taken
Link to photos taken
Cubic Yards Removed (on trashouts)
Dumpster ordered (on trashouts)
Photos for each activity (server location)
Length x with (if grasscuts)
Type of Trip charge(if trip charge)
[track trip charges by property id]


Update Crews Form
Employee
Supervisior
Crew

Work Order Completion Report
Work Order
Activities Performed
Due Date 
Field Comments
Date Completed
Post completion comments


Admin Processing Form
Work Order
Property ID
Address
Due Date
Date Completed in the field
Photos Uploaded By
Do photos support work?
Location of scanned backup (server location)
Post Completion comments

Work Order Revenue Estimate Report
Work Order
Property ID
Actual Activities
Revenue

Total Revenue


Daily Revenue Estimate
Assigned date
Completion date
WO
Total Revenue
Daily revenue
Daily rev goal
Weekly Revenue Report
Assigned date
Completion date
WO
Total revenue
Weekly revenue
YTD revenue
MTD revenue
Annual Revenue Goal
Monthly Revenue goal
Weekly Revenue goal
Daily revenue goal
Amount over the goal
Amount over x 3%

Bid form
Activities
Cost per activity
Date of initial bid
Date assigned to 180
Estimated completion date
Sub estimate
Estimated revenue

Upload Monthly Janitorial 

Upload Triweekly addresses

Monthly Work orders by type
Monthly zipcodes 
Vehicle Maintenance report
Inventory Usage Report
Estimated Net Income Report
Invoicing Form
WO
Property ID
Invoice Number

-how to dont allow manual edit to the tables ,and just forms should do that
2-after building the report,the viewer should be able to add extra values to the report .
3-for example fill the form which is directly connected to data base and clear the txt boxes if the user decide that he doesnt want the record.
4-create login screan with password.
5-we try this but tink its hard to do it directly
have for example the supervisor able view and update but for example the workers not just to view ,more likely set rights for the users
create a report and then be able to exchange the information on them for example if there 6 txt boxes 
and the report fill 4 of them when we ran it,the user can actually go to this report and fill the other 2 and add edit the other 4
all this should be done in MS Access

( Price 50$) - Contact: businessonline4me@gmail.com

------------------------------------------------------------------------------------------------------------------------------------

Suppose you need to sort a relation of 40 gigabytes, w/4 kb blocks, 
using a memory size of 40 mgbytes. 
Suppose the cost of seek is 5milliseconds, while the disk transfer
rate is 40mgbytes per second. 

a. Find the cost of sorting the relation , in seconds, w/bb = 1 & 
w/ bb= 100.

b. In each case, how many merge passes are required?
c. Suppose a flash storage device is used instead of a disk , and 
it has a seek time of 1 microsecond, and a transfer rate of 40 
mgbytes per second . Recompute the cost of sorting the relation, 
in seconds, w/bb= 1 & w/bb= 100, in this setting.

The question is from the textbook "Database System Concepts" 6th 
edition chapter 13 Query optimization

( Price 5$) - Contact: businessonline4me@gmail.com

----------------------------------------------------------------------------------------------------------------------------------