1 / 13

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 Design, develop, manufacture, sales and service of cars, trucks and service parts

paul
Download Presentation

Database System for an Ordering Process for Ford Motor Company

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database System for an Ordering Process for Ford Motor Company BUSA 310 – Information Systems May 14, 2008 Nicole Ferrin & Joey Bottcher

  2. 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

  3. 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

  4. Order Table

  5. Warehouse Table

  6. Part Table

  7. Supplier Table

  8. Entity Relationship Diagram

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

More Related