Mary Small

1

• Presented by
• Mary Small
• Robert Acree
• Cedric Love
• Natasja Sambale
• Krissy Hickman

2
Introduction

• Who we chose
• Maserati
• Ferrari
• Accessories for both
• Decentralized Database
• No central point to collect information about all
  databases simultaneously.

3
Maserati

• Currently producing four different cars
• Standard features include
• Fire extinguishers
• Matching luggage
• Special features include
• Exterior color
• Thread color for leather seats
• Personalized skid plates

4
Ferrari

• Hard to find in America
• T-shirts
• Miniature cars
• Available through both Maserati and Ferrari

Accessories for Gruppo/Maserati /Ferrari
5
Maserati History

• Founding history
• by Alfieri Maserati
• on December 1, 1914
• in Bologna, Italy
• Played important role in sports car culture and
  development
• Sold to Orsi family in 1937
• Headquarters were move to Modena
• Sold to Citreou family in 1968
• Then sold to Fiat Auto in 1993
• Finally acquired by Ferrari on 1997

6
Important Moments in Maseratis History

• World speed record of 246.029km/h in 1929
• World Championship in 1957
• Laugh of Coupe Cambiocorsa in 2002

7
Ferrari

• Founding history
• by Enzo Ferrari
• in spring of 1947
• in Maranello
• Ferrari was ran by Enzo Ferrari until his death
  in 1988.
• In 1969 Ferrari sold 50 of stock to Fiat Auto
  Group
• In 1988 sold all but 10 to Fiat Auto Group
• Luca di Montezemdo was appointed president.

8
Important Moments in Ferraris History

• Won over 5000 races
• 25 world titles
• 1979 awarded Knight of the Republics Great Cross

9
Why we chose Gruppo/Maserati/Ferrari

• A challenge and glutton for punishment.
• Interesting databases about vehicles that we
  have only admired form a distance.
• They have very diverse range of both standard and
  optional features.
• Not only cars but there is a wide range of
  accessories to wear or display to match the cars.

10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
Object-Oriented for Ferrari
20
(No Transcript)
21
(No Transcript)
22
Create Table

• SQL CREATE TABLE CUSTOMER_20
• 2 (CUSTOMER_ID CHAR(4) PRIMARY KEY,
• 3 LAST_NAME CHAR(10) NOT NULL,
• 4 FIRST_NAME CHAR(10) NOT NULL,
• 5 STREET_ADDRESS CHAR(20),
• 6 CITY CHAR(15),
• 7 STATE CHAR(2),
• 8 ZIP_CODE CHAR(7),
• 9 PHONE_NUMBER CHAR(10),
• 10 EMAIL CHAR(25))
• Table created.

23
Table Describe

• SQL DESCRIBE CUSTOMER_20
• Name Null?
  Type
• -----------------------------------------
  -------- ---------------------------
• CUSTOMER_ID NOT
  NULL CHAR(4)
• LAST_NAME NOT
  NULL CHAR(10)
• FIRST_NAME NOT
  NULL CHAR(10)
• STREET_ADDRESS
  CHAR(20)
• CITY
  CHAR(15)
• STATE
  CHAR(2)
• ZIP_CODE
  CHAR(7)
• PHONE_NUMBER
  CHAR(10)
• EMAIL
  CHAR(25)

24
Table Insert
1 row created. SQL SQL INSERT INTO
CUSTOMER_20 2 VALUES 3 ('07','Majestic','Sta
cy','4574 Belle Dr','Sunnyville','TN','89554','895
3246571','stacmaj_at_mail.c 1 row created. SQL
INSERT INTO CUSTOMER_20 2 VALUES 3
('08','Jones','Russell','5837 Microsoft
Ave','Jonesboro','AR','72401','8709338546','rjones
_at_asta 1 row created. SQL INSERT INTO
CUSTOMER_20 2 VALUES 3 ('09','Gates','Willia
m','574 Swift St','Jonesboro','AR','72401','870902
5874','wgates_at_microsoft. 1 row created. SQL
INSERT INTO CUSTOMER_20 2 VALUES 3
('10','Walker','Chuck','4323 Dusty
Ln','Houston','TX','48755','8992542365','walkerc_at_r
angers.org 1 row created. SQL INSERT INTO
CUSTOMER_20 2 VALUES 3 ('11','Charmed','Pipe
r','6669 Craft Ln','Jonesboro','AR','72467','87097
26666','charmedone_at_aol.c 1 row created.

• SQL INSERT INTO CUSTOMER_20
• 2 VALUES
• 3 ('01','Doe','John','3214 Anywho
  St','Weirdsville','WI','12345','5805564534','jdoe_at_
  hotmail.com')
• 1 row created.
• SQL INSERT INTO CUSTOMER_20
• 2 VALUES
• 3 ('02','Brandish','Comelia','2154 Brown
  St','Willa','ME','56832','9877884583','cornbrand_at_y
  ahoo.c
• 1 row created.
• SQL INSERT INTO CUSTOMER_20
• 2 VALUES
• 3 ('03','Segall','Richard','4858 State
  St','Oracleville','AR','72654','8708924522','rsega
  ll_at_astat
• 1 row created.
• SQL INSERT INTO CUSTOMER_20

25
Table Select

• CUST LAST_NAME FIRST_NAME STREET_ADDRESS
  CITY ST ZIP_CODPHONE_NUMB EMAIL
• ---- ---------- ---------- --------------------
  --------------- -- ------- ----------
  --------------
• 01 Doe John 3214 Anywho St
  Weirdsville WI 12345 5805564534
  jdoe_at_hotmail.c
• 02 Brandish Comelia 2154 Brown St
  Willa ME 56832 9877884583
  cornbrand_at_yaho
• 03 Segall Richard 4858 State St
  Oracleville AR 72654 8708924522
  rsegall_at_astate
• 04 Segall Steven 4530 Sunshine Dr
  Los Angeles CA 82544 8736568475
  ssegall_at_aol.co
• 05 Jokes Riddler 4321 Batcave Blvd
  Gotham City NY 78954 4455556666
  ruajoke_at_sinist
• 06 Grinch Jim 556 Snow Cave
  Whoville NY 78922 5875585987
  ruthegrinch_at_wh
• 07 Majestic Stacy 4574 Belle Dr
  Sunnyville TN 89554 8953246571
  stacmaj_at_mail.c
• 08 Jones Russell 5837 Microsoft Ave
  Jonesboro AR 72401 8709338546
  rjones_at_astate.
• 09 Gates William 574 Swift St
  Jonesboro AR 72401 8709025874
  wgates_at_microso
• 10 Walker Chuck 4323 Dusty Ln
  Houston TX 48755 8992542365
  walkerc_at_ranger
• 11 Charmed Piper 6669 Craft Ln
  Jonesboro AR 72467 8709726666
  charmedone_at_aol

26
Query Customer Table

• SQL SELECT CUSTOMER_ID, LAST_NAME, FIRST_NAME,
  CITY, STATE
• 2 FROM CUSTOMER_20
• 3 WHERE CITY 'Jonesboro' AND STATE 'AR'
• CUST LAST_NAME FIRST_NAME CITY ST
• ---- ---------- ---------- --------------- --
• 08 Jones Russell Jonesboro AR
• 09 Gates William Jonesboro AR
• Charmed Piper Jonesboro AR
• SQL

27
Summary

• Brief history of
• Maserati
• Ferrari
• Included
• Dates started
• Who started them
• Who has control of them now
• Special Moments

28
Summary cont.

• ER diagrams
• EER diagrams
• Normalization
• 1st
• 2nd
• 3rd
• SQL commands
• Access database

29
Summary cont.

• End with group questions
• Questions form the audience

30
Krissys Question
How many families or companies have owned
Maserati and who were they?
31
Krissy s Answer

• There have been 5 owners of Maserati since it was
  founded. They are in order Alfierei Maserati,
  the Orsi Family, the Citreou Family, the Fiat
  Auto Group, and finally Ferrari.

32
Roberts Question

• In the EER diagram, what are the supertypes in
  the diagram and what are the supertypes subtypes?

33
Roberts Answer

• Supertypes Item, Accessories, Payment
  Transaction, Special Features
• Subtypes Item subtypes are Ferrari, Maserati,
  Accessories Accessories subtypes are Jacket,
  Backpack, Perfume Payment Transaction subtypes
  are Check, Cash, Credit Card Special Features
  subtypes are Exterior, Interior, Color

34
Marys Question

• If you were creating a table for dealers in SQL,
  for this database,what would it look like?
•  

35
Marys Answer

• SQL CREATE TABLE DEALERS_20  2  (NAME CHAR(20)
  NOT NULL PRIMARY KEY,  3  STREET_ADDRESS
  CHAR(20),  4  CITY CHAR(20),  5  STATE
  CHAR(20),  6  ZIP_CODE CHAR(5),  7 
  PHONE_NUMBER CHAR(15),  8  WEB_ADDRESS
  CHAR(30))
• Table created.

36
Cedrics Question

• Why are the subtypes Cash, Credit Crad, and
  Check important to the supertype Payment Method
  in EER Diagram?

37
Cedrics Answer

• The approach explains the common properties of
  Payment Methods and recognizes the distinct
  properties of each type of payment method so it
  is easier to understand by the reader.