United States Andrew Woodbridge awoodbridge@schools. nyc. gov 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 l l “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 l The environment is being damaged by chemicals, pollution and other issues. Solution l We are selling Biofuels to other companies to reduce the damage being caused towards the environment.
Procedural Business Rules l l l l l 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 l l l l l 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 BIOFUEL FACTORY #name *address *telephone *e-mail be on deliver the product to SALE DISTRICT #id SHIPPING COMPANY #name *address *phone number be responsible for be the responsibility of be divided into #employee ID *name *address *phone number *salary 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 BIOFUEL SUPPLIER *name ◦website *phone number #id *email *name *address *phone number #id *email be for BIOFUEL BUYER LOG be on be for *date sold *price *amount sold
Suppliers
References l l l http: //www. bulkoil. com/index. asp http: //www. alnoroil. com/oil. htm http: //www. biodieselsolutions. com/default. as px
Скачать презентацию United States Andrew Woodbridge awoodbridge schools nyc gov Our
a60af743644620a3b2b869eefa28a7d1.ppt