database system for an ordering process for ford motor company
Download
Skip this Video
Download Presentation
Database System for an Ordering Process for Ford Motor Company

Loading in 2 Seconds...

play fullscreen
1 / 13

Powerpoint Access - PowerPoint PPT Presentation


  • 221 Views
  • Uploaded on

Database System for an Ordering Process for Ford Motor Company BUSA 310 – Information Systems May 14, 2008 Nicole Ferrin & Joey Bottcher Ford Background Design, develop, manufacture, sales and service of cars, trucks and service parts

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Powerpoint Access' - paul


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
database system for an ordering process for ford motor company

Database System for an Ordering Process for Ford Motor Company

BUSA 310 – Information Systems

May 14, 2008

Nicole Ferrin & Joey Bottcher

ford background
Ford Background
  • Design, develop, manufacture, sales and service of cars, trucks and service parts
  • Vehicles include cars for the small, medium, and large and premium segments, trucks, buses, vans, full-size pickups, sports utility vehicles, and vehicles for the medium and heavy segments
  • Provides products and services through the operations of Ford North America, Ford South America, Ford Europe, Premier Automotive Group, and Ford Asia Pacific and Africa/Mazda segments
the ordering process
The Ordering Process
  • Developed a database that includes the orders being made and the warehouses, suppliers and parts involved.
  • Helps identify certain characteristics through queries such as the speed or quality of suppliers
  • Benefits of the database:
    • Help make quicker decisions
    • Minimize redundancy
    • Inevitably improve efficiency
queries
Managers use this query table to see which suppliers are supplying the most products to each warehouse. It helps management identify which suppliers do the most business with Ford. This query uses information from the warehouse, supplier, and order tables.Queries

Most Frequently Used Suppliers at Warehouses

supplier quality and speed greater or equal to 7
This query table lists suppliers with the highest quality and speed ratings. This information assists managers in the decision making process of choosing the suppliers who offer the best products and service. This query is formed using information from only the supplier table. Supplier Quality and Speed Greater or Equal to 7
orders with part quantities of greater or equal to 700
Managers use this query to see which orders are asking for parts with quantities of 700 or more. Managers can expect to know how many units will be arriving. This query is formed using the orders and product table. Orders with Part Quantities of Greater or Equal to 700
products received from suppliers with speed rates of 6 or less
Managers can use this query to see which products are being received from suppliers with a low speed rate of 6 or less. This query provides information that may assist managers in deciding what suppliers they may potentially weed out. This query is formed from information from the part and supplier tables. Products Received from Suppliers with Speed Rates of 6 or Less
companies supplying seat systems
Managers use this very specific query to identify the companies supplying seat systems and for what price. This query provides value to the firm because they can use it to compare prices and ultimately reduce the cost of inputs. This query uses information from the supplier and part tables. Companies Supplying Seat Systems
ad