Database Framework for a Requesting Process for Passage Engine Organization.


140 views
Uploaded on:
Description
Database Framework for a Requesting Process for Passage Engine Organization BUSA 310 – Data Frameworks May 14, 2008 Nicole Ferrin and Joey Bottcher Portage Foundation Outline, create, production, deals and administration of autos, trucks and administration parts
Transcripts
Slide 1

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

Slide 2

Ford Background Design, create, make, deals and administration of autos, trucks and administration parts Vehicles incorporate autos for the little, medium, and extensive and premium sections, trucks, transports, vans, full-estimate pickups, sports utility vehicles, and vehicles for the medium and substantial fragments Provides items and administrations through the operations of Ford North America, Ford South America, Ford Europe, Premier Automotive Group, and Ford Asia Pacific and Africa/Mazda portions

Slide 3

The Ordering Process Developed a database that incorporates the requests being made and the distribution centers, suppliers and parts included. Aides recognize certain attributes through inquiries, for example, the pace or nature of suppliers Benefits of the database: Help settle on snappier choices Minimize repetition Inevitably enhance productivity

Slide 4

Order Table

Slide 5

Warehouse Table

Slide 6

Part Table

Slide 7

Supplier Table

Slide 8

Entity Relationship Diagram

Slide 9

Managers utilize this inquiry table to see which suppliers are supplying the most items to every stockroom. It assists administration with recognizing which suppliers do the most business with Ford. This question utilizes data from the distribution center, supplier, and request tables. Questions Most Frequently Used Suppliers at Warehouses

Slide 10

This inquiry table records suppliers with the most astounding quality and rate appraisals. This data helps directors in the choice making procedure of picking the suppliers who offer the best items and administration. This question is shaped utilizing data from just the supplier table. Supplier Quality and Speed Greater or Equal to 7

Slide 11

Managers utilize this inquiry to see which requests are requesting parts with amounts of 700 or more. Administrators can hope to know what number of units will be arriving. This question is shaped utilizing the requests and item table. Orders with Part Quantities of Greater or Equal to 700

Slide 12

Managers can utilize this inquiry to see which items are being gotten from suppliers with a low speed rate of 6 or less. This inquiry gives data that may help administrators in choosing what suppliers they might conceivably remove. This question is framed from data from the part and supplier tables. Items Received from Suppliers with Speed Rates of 6 or Less

Slide 13

Managers utilize this particular question to distinguish the organizations supplying seat frameworks and for what cost. This question gives worth to the firm on the grounds that they can utilize it to look at costs and at last decrease the expense of inputs. This question utilizes data from the supplier and part tables. Organizations Supplying Seat Systems

Slide 14

.:tslidese

Recommended
View more...