Transcript Project Manager - Design Journal

United States
Andrew Woodbridge
[email protected]
Our mission is to help keep the environment
safer and cause less damage to the Earth.
Project Manager- Yu Xia Li
Project Manager Assistant- Melissa Monserrate
Data Modeler Assistant- Natalie Torres
Data Modeler- Janni Ramirez
Our Quote


“Green Energy is ready for anything!”
“Green Energy reducing your impact!”
Green Energy is a established retailer of biofuels. We sell biofuels that are
manufactured in many different countries. We sell the most efficient biofuel in the United
States and around the world. Our goal is to help countries around the world cut back on
the amount of natural gas and fossil fuels being used by changing they fuel to our biofuel.
Our company buys the oil online and make trips to different restaurants to collect grease
and bring it back to the company. Our company and transportation are power by our
biofuel. We buy our equipments online from the biodiesel solutions.
Our company is divide into the 7 continent: North America, South America, Africa,
Europe, Asia, central America, and Australia. Each sales region has a unique region id.
Each continent is then divided into sales districts. Each district has a unique district id.
Each district is made up of sales territories. Then each sales territory is broken down into
sales areas. Each territories and sale area have unique id.
Each salesperson is responsible for one or more sales areas and has a specific
sales quota. We also have sales managers who are responsible for one or more sales
districts and sales directors who are responsible for one or more sales regions. Each sales
manager is responsible for the territories with his/her districts. Each sale person keep track
of the biofuel being brought. We identify all our sales personnel by their employee IDs. We
keep track of the employee address, name, phone number, and salary. For our company
we keep track of how much we spend on the materials. They are pay $800 a month and
are giving health benefit. We are opened Mondays through Fridays from 8:00 am to 8:00
pm and on Saturdays from 8:00 am to 6:00 pm. Our company is closed on Sundays and
main holidays like Christmas and Thanksgiving.
Our company keep track of our suppliers and buyers. For every supplier and buyer
we keep track of the company name, address, phone number, and we also assign each
company an id. The ID make it easier to find the companies in our database. The biofuel
are sold for $3.40 per gallon. We also keep track of how many gallons each company buys
from us and when they buy it. The factory make the biofuel and sent it to the warehouse
where the shipping company would ship it into different part of the world.
Problem

The environment is
being damaged by
chemicals, pollution
and other issues.
Solution

We are selling Biofuels
to other companies to
reduce the damage
being caused towards
the environment.
Procedural
Business Rules









The biofuel are sold for $3.40 per gallon.
Prices of raw material must be recorded and the date it is brought and
where.
We are opened Mondays through Fridays from 8:00 am to 8:00 pm
and on Saturdays from 8:00 am to 6:00 pm.
Is closed on Sundays and main holidays like Christmas and
Thanksgiving.
Employee are pay $700 a month and are giving health benefit.
Our company buys the oil online and make trips to different
restaurants to collect grease and bring it back to the company.
Our company and transportation are power by our biofuel.
Equipments are brought online from the Biodiesel solutions.
The biofuel are make in biofuel factory.
Structural
Business Rules


















We keep track of suppliers and buyers company name, phone number, email and we also
assign each company an id.
Each buyer need to give us they address.
Each supplier website must be recorded.
Each buyer and supplier log need to include price, amount brought/sold and date
brought/sold.
For every employee we keep track of their address, name, phone number, and salary.
Sales personnel by their employee IDs.
Each sales region has a unique region id.
Each continent is then divided into sales districts.
Each district has a unique district id.
Each district is made up of sales territories.
Each sales territory is broken down into sales areas.
Each territories and sale area have unique id.
Each salesperson is responsible for one or more sales areas and has a specific sales
quota.
Each sales manager is responsible for the territories with his/her districts.
Sales personnel by their employee IDs.
Sales directors are responsible for one or more sales regions.
Each sale person keep track of the biofuel being brought.
The factory make the biofuel and sent it to the warehouse where the shipping company
would ship it into different part of the world.
WAREHOUSE
SALE DIRECTOR
send product to a
#id
*address
*telephone
receive biofuel from a
SALE REGION
be responsible for
#code
receive biofuel from
be the responsibility of
be divided into
#employee ID
*name
*address
*phone number
*salary
belong to
receive product from
SALE MANAGER
send biofuel to
SALE DISTRICT
BIOFUEL FACTORY
#name
*address
*telephone
*e-mail
be on
be responsible for
deliver the product to
#id
SHIPPING
COMPANY
#name
*address
*phone number
be the responsibility of
#employee ID
*name
*address
*phone number
*salary
be divided into
belong to
TERRITORY
be for
#id
SUPPLIER LOG
SALEPERSON
be divided into
*date brought
*price
*amount brought
belong to
be responsible for
SALE AREA
be for
#id
be the responsibility of
*specific sales quota
#employee ID
*name
*address
*phone number
*salary
be on
be on
BIOFUEL SUPPLIER
BIOFUEL BUYER
*name
◦website
*phone number
#id
*email
*name
*address
*phone number
#id
*email
be for
BUYER LOG
be on
be for
*date sold
*price
*amount sold
Suppliers
References



http://www.bulkoil.com/index.asp
http://www.alnoroil.com/oil.htm
http://www.biodieselsolutions.com/default.as
px