assignment

a) Detailed record of camera photos stored in the database includes make/model, speed,

b) Time tables for buses must include bus specifications such as bus c) Greenhouse information records the travel distance, fuel usage and speed, number of

d) A stored procedure is required for formulating the *letterhead* for a letter to the owner of

e) A stored procedure that calculates the average number of passengers in each bus for

f) A stored procedure that calculates kg of CO2 emitted per leg of travel that is calculated

g) A graph relating kg of CO2 emission, starting with an empty bus, then for every

h) A stored procedure is needed to *search* for a for any type of vehicle using *cursors*. You

j) Finally, SQL for the creation of all tables, attributed, PKs, FKs, and relationships using

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b

## Platform

windows sql server express 2005

Odd Jobs

Project ID: #3350318

About the project