Darryl J. Spinks

1

• Darryl J. Spinks
• Denise Poindexter
• Tiffani Ratchford
• Terrie Hawkins
• Alisha Cobbs

2

• Project Overview Tiffani Ratchford
• ER EER Diagrams Terrie Hawkins
• Normalization Darryl J. Spinks
• Database Design Alisha Cobbs
• Conclusion Denise Poindexter

3
Project Overview Tiffani Ratchford
4
Daimler Chrysler is one of the world's leading
automotive, transportation and services
companies. Its passenger car brands include
Maybach, Mercedes-Benz, Chrysler, Jeep, Dodge
and Smart. Commercial vehicles are produced under
the Mercedes-Benz, Freightliner, Sterling,
Western Star, Setra, Thomas Built Buses, Orion
and American LaFrance brands. It offers financial
and other services through Daimler Chrysler
Services. With 372,500 employees, Daimler
Chrysler achieved revenues of EUR 152.9 billion
(136.1 billion) in 2001.
5
Daimler Chrysler today has a global workforce, a
global shareholder base, global brand awareness
and a global outlook. Daimler Chryslers strategy
rests on four pillars Global Presence, Strong
Brands, Broad Product Range, and Technology
Leadership.
6
Daimler Chrysler is owned by European, U.S. and
other international investors approximately one
billion shares outstanding. Daimler Chrysler has
changed a great deal from wide-ranging
diversification to fully concentrating on the
development, manufacture and sale of the world's
leading automobiles. The aim has been clearly
stated Daimler Chrysler wants to become the
number one automobile manufacturer in the world
through continuous and economically sensible
growth
7
The biggest challenge in the coming years will be
to work with the considerable potential for
growth and profit of new technologies and growing
markets. We have adapted to the future by
focusing on our automotive business, through our
consistent strategy of globalization and by
developing our trademarks and business processes.
8
Our group decided to choose Daimler Chrysler
because we felt that car manufacturers have the
most extensive databases and it is a broad
subject in which we will have numerous categories
to choose from including Maybach,
Mercedes-Benz, Chrysler, Jeep, and Dodge.
9
We chose to focus on Chrysler, Dodge and Jeep
because many people do not know much about
vehicles until they actually go to the car
dealership and this will give some people
knowledge about selecting cars and other
vehicles. It is an extensive database as we also
found out. The information provided will be
beneficial for the consumer as well as someone
looking at the structure of the company.
10
In the Chrysler division we focused on Cars

• 300M
• PT Cruiser
• Concorde
• Sebring Coupe and Convertible

11
In the Jeep Division the focus was on SUVs

• Grand Cherokee
• Liberty
• Wrangler

12
In the Dodge division we focused on trucks

• Dakota
• Ram

13
ER, EER, and OO Diagrams Terrie Hawkins
14
SUV ER
15
Cars ER
16
Daimler-Chrysler EER
17
(No Transcript)
18
Object oriented diagram example
19
Normalization Darryl J. Spinks
20
First Normal Form The Key
21
Second Normal Form The Whole Key
22
Third Normal Form Nothing But the Key
23
Database Creation Design Alisha Cobbs
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
SQL table Creation
SQL CREATE TABLE CUSTOMERDC1 2 (CUSTOMER_ID C
HAR(9), 3 CUSTOMER_NAME CHAR(25), 4 ADDRES
S CHAR(25), 5 cITY CHAR(15), 6 ZIP CHAR(5)
, 7 STATE CHAR(2), 8 VIN CHAR(17)) Table
created.
30
SQL Table Data Population Commands
SQL INSERT INTO CUSTOMERDC1 2 VALUES 3 ('
581203423','Shemar Moore','3828 Lovers Lane,'Los
Angeles','90006','CA','8BC4532Z2014TS4S1')
1 row created. SQL SQL INSERT INTO CUSTOM
ERDC1 2 VALUES 3 ('281130591','Kylan Stron
g','504 Clearbrook','Oxford','38655','MS','541LM29
D66I873210') 1 row created.
31
SQL Single Table Query
SQL SELECT CUSTOMER_ID, CUSTOMER_NAME, STATE,
VIN 2 FROM CUSTOMERDC1 CUSTOMER_ CUSTOMER_NA
ME ST VIN --------- -----------------
-------- -- ----------------- 581203423 Shemar Mo
ore CA 8BC4532Z2014TS4S1
281130591 Kylan Strong MS
541LM29D66I873210 283412341 Seymour Butz
AR P9248JT357HO35KS1 348216728 Steven Segall
FL Z482PR305J2LO3TD1
362481177 Laurie Stokes TN
83ZWA359BU00243R2 429306288 Sara Johnson
TX 2079SGNT31280DDK7 519026743 Robert Brown
AR P81225KNB622LRP29
523675330 Jennifer Anderson TX
236DN17K54LM98G31 830621488 Tammy Allen
AR RCJC51997TMR19081 930763238 Kennidi Spenc
e NY 143WLCM2002B2KDCS
10 rows selected.
32
Advanced Database Concepts Denise Poindexte
r
33
Daimler-Chrysler is a distributed database
because it has a single logical database that is
spread physically across computers in multiple
locations that are connected by a data
communications network. The database is
centrally administered as a corporate resource
while providing local flexibility and
customization.
34
Data administration is responsible for a wide
range of functions, including database planning,
analysis, design, Implementation, maintenance, a
nd protection. Data administration is also resp
onsible for improving database
performance and for providing education,
training, and consulting support to users. The
data administrator must interact with top manage
ment, users, and computer applications specialist
s.
35
The purpose of Daimler-Chryslers data warehouse
consolidates and integrates from a variety of so
urces, and formats the data in context for makin
g accurate business decisions. This data warehou
se may be formally defined as an integrated and
consistent store of subject-oriented data obtaine
d from a variety of sources and formatted into a
meaningful context to support decision making i
n the Daimler-Chryslers corporation.
36
Student Questions
37
Denises Question
Daimler-Chryslers data administration is
responsible for what type of functions?
38
Alishas Question
Define first, second, and third normal form.
39
Tiffanis Question What type of workforce does
Daimler-Chrysler has and what strategy do they
apply to their company?
40
Darryls Question
What are three of the essential functions of a
distributed database?
41
Terries Question
42
(No Transcript)