Chevrolet'com

1
Group 1

• Chevrolet.com

2
Team Members

• Jason Nichols
• Brian Smith
• Gary Ellis
• Chris Peeples
• Nelson Gomez
• Amanda Jones

3
Presenter

• Jason Nichols

4
Chevrolet Business Description

• General Motors
• GMA-four regions
• GM North America (GMNA)
• GM Europe (GME)
• GM Latin America/Africa/Mid-East (GMLAAM)
• GM Asia Pacific (GMAP)

Chevrolet
5
Chevrolet Database

• Large nature of Chevrolet database
• Familiarity of subject

• Focus on
• Cars
• Trucks
• SUVs
• Two to Three automobiles for each category

6
Differences?

• Automobile Company
• Multiple product lines
• International

7
Cars

• Domestic
• Corvette
• Impala
• Monte Carlo

• International
• Mexico
• Corsa
• Chevy
• Monza
• Japan
• Corvette
• Camaro

8
Trucks

• Domestic
• S-10
• Silverado
• Avalanche

• International
• Mexico
• LUV
• S-10
• Silverado
• Ecuador
• Silverado
• LUV
• Cheyenne

9
SUVs

• Domestic
• S-10
• Silverado
• Avalanche

• International
• Mexico
• Tracker
• Sonora
• Trailblazer
• Japan
• Blazer
• Cruze
• MW

10
Presenter
Brian Smith
11
(No Transcript)
12
Trucks E-R Diagram
13
SUV E-R Diagram
14
Chevrolet EER Diagram
15
Chevrolet EER Diagram(cont.)
16
Presenter

• Gary Ellis

17
Normalization

• Cars example
• 1st,2nd,3rd normal forms

18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
Presenter

• Chris Peeples

22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28

• SELECT Customer.Customer_ID, Payment.Amount,
  Dealerships.Name, Payment.Sales_Invoice
• FROM Customer INNER JOIN (Payment INNER JOIN
  Dealerships ON Payment.Sales_Invoice
  Dealerships.Sales_Invoice) ON (Payment.Sales_Invoi
  ce Customer.Sales_Invoice) AND
  (Customer.Sales_Invoice Dealerships.Sales_Invoic
  e)

29
Presenter

• Nelson Gomez

30
Application of Advanced database Concepts

• Chevrolet databases are distributed databases for
  its worldwide locations which is centrally
  managed from Chevrolets worldwide center,
  providing access to data from many users at many
  locations through location transparency .
• It is homogenous distributed database. All these
  database servers are connected through dedicated
  data communication links. Chevrolet also
  maintains backup server at different location.

31
Application of Advanced database Concepts (cont)

• Several client-server architecture are applied in
  our database such as file server a device that
  manages file operations and is shared by each of
  the client PCs attached to the LAN.
• Another application discussed in client-server
  architecture which applies to our database is
  connecting databases to the web sites by placing
  orders, accessing updated pricing information.

32
Application of Advanced database Concepts (cont)

• Data base access from clients applications, our
  database was mostly worked in MS-Access that is
  extensively discussed in chapter 10. It contains
  numerous examples and definitions of
  relationships, tables, queries, forms, reports,
  macros and database definitions.

33
Application of Advanced database Concepts (cont)

• Data and Database Administration.that are
  discussed in chapter 13. This would relate to any
  database project, the life-cycle phase Database
  planning, analysis and design were the subjects
  we developed in our team-project.
• The most important topics in this chapter are
  Database security,recovery and deadlock.

34
Application of Advanced database Concepts (cont)

• Chevrolet provides a data warehouse with
  informational systems that are separated from
  operational systems to improve performance. This
  allow the internet site to provide ways in
  managing the corporation database.

35
Presenter

• Amanda Jones

36
Conclusion and Summary

• Known as General Motors and has four major
  regions.
• GM manufactures many nameplates that are
  distributed within the United States as well as
  Internationally

37

• Our database project consisted of cars, trucks,
  and SUVs. We focused on two to three categories
  of each vehicle.
• Brian presented the E-R and EE-R diagrams that
  demonstrated the attributes and entity
  relationship of the database
• Gary presented the 1st, 2nd, and 3rd normal forms
  for the database.

38
Features of our database

• Homogeneous distributed database
• Connection through dedicated data communication
  links with backup servers distributed to
  different locations.
• Client-server architecture
• Database connected to web sites for placing
  orders, accessing and updating information

39

• Database warehouse with informational systems
  that are separated from operational systems
  improving performance.

40
Chevrolet Database

• Student Questions

41
Jasons Question

• Chevrolet has a wide line of vehicles that many
  of us are familiar with. However, they produce a
  line of international products that many of us
  are not familiar with. Why does Chevrolet tailor
  their line of automobiles to suit the taste and
  culture of different countries?

42
Brians Question Answer

• How are E-R and EER diagrams helpful in the
  process of building a database?

43
Garys Question

• What were the differences between the 2nd normal
  form and 3rd normal form in the cars example?

44
Chriss Question

• Why would it be easier to query tables in
  Access than in SQL?

45
Student Question Nelson G.

• What type of database does Chevrolet use?

46
Amandas Question

• Has Chevrolet gained a competitive advantage and
  how? Do the features of the database support
  their competitive advantage goal?