Team 3Amazon'com Database - PowerPoint PPT Presentation

Title: Team 3Amazon'com Database


1
Established in 1994
TEAM 3 MEMBERS SETH BORTEY SIAU-WHEI
LIOUH RENARD LOVE DAVID HANCOCK
2
TOPIC OF DSCUSSION

• Description of database and why database was
  selected
• Database development
• Entity-Relationship Diagrams
• Object-Oriented Models
• Physical database Design
• Normalization
• DBSMS of ORACLE SQL and MS Access
• Summary and Conclusions

3
Amazon.com - Description of the database (Books)
Add some value Data mining Single mouse
click Reader satisfaction Travel between
retailers 24 hours delivery Help on how to order
Publishers/Distributors
Send
Release
Place_Order
Amazon.com 1600 employees
Inbound Logistics Support
Customer 30 million
Sell_Product
Outbound Logistics support
4
Reason for the selection of Amazon.com and some
history of the business.

• Core competence of Amazon .com
• -Selling goods and service using the internet.
  
• Low cost structure
• -No physical stores
• -No inventory
• -Only about 1600 employees.
• High cash flow from operating activities usage
  of customers money.
• Fast inventory turnover.
• Its global.

5
ENTITY-RELATIONSHIP DIAGRAMS Handouts
-DVD -Home Garden -Video Games
6
OBJECT-ORIENTED MODELING Handout -DVD -
Home Garden -Video Games
7
Enhanced E-R Diagrams

• Handouts
• -Supertype/Subtype Relationship
• -Specialization and Generalization
• -Partial Specialization
• -Disjoint and Overlap rules
• -Subtype Discriminators
• -Supertype/Subtype Hierarchy

8
NORMALIZATION SQL Create
Table Dvd

• SQLgt Create Table Dvd
• 2 Title Char(15) Primary Key
• 3 Rating Char(4) Not Null,
• 4 Price Char(8) Not Null,
• 5 Category Char(15),
• 6 In_Stock Char(15)

9
Create Table Video_Games

• SQLgt Create Table Video_Games
• 2 Rating Char(4) Not Null,
• 3 Price Char(8) Not Null,
• 4 Category Char(15),
• 5 In_Stock Char(15)

10
Create Table Home_Garden

• SQLgt Create Table Home_Garden
• 2 Price Char(8) Not Null,
• 3 Category Char(15),
• 4 In_Stock Char(15)

11
Insert into Dvd
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
Seths Question Draw a ER diagram indicating
the following Customer order a product from
Amazon.com. The customer has the following
attributes -Contact information (email,
phone) -Personal information (Name, Buying
history) -Address (City-State, Zip) -Customer
Account as the identifier The Product has
the following attributes -Item Name as the
identifier -Item Color -Item Size Hint
Amazon.com is an entity
26
Contract information
Customer Account
Customer
order
Email
Address
City-State
Personal information
Phone
Name
Zip
Product
Item Size
Buying History
Is provide
Item Name
Item Color
Amazon.com
Seth Answer
27
Siau-Whei Liouh Question Give an example of the
structure constraint of Amazon.com Taken the
supretype/subtype relationship into
consideration.
28
Siau-Whei Liouh Answer
PRESIDENT OF AMAZON.COM
VICE PREIDENT OPERATION
VICE PRESIDENT ADMINISTRATION
VICE PRISIDENT LEGAL
ADMINISTRATION DEPARTMENT
LEGAL DEPARTMENT
OPERATION DEPARTMENT
ADMINISTRATIVE PERSONNEL
LAGAL PERSONNEL
OPERATION PERSONNEL
29
Renards Question

• Whats is the SQL Statement for Amazon.com to
  query all rated R DVDs, and how would it benefit
  from the results?

30

• Renards Answer
• Select Dvd Title
• From DVD
• Where Rating R
• This query result will help Amazon.com categorize
  its DVDs by R ratings in order to provide
  parental control over those not suited for
  minors.

31
Davids QuestionHow can Microsoft Access
help some one how to read SQL?
32
Davids AnswerIt is possible to switch
back and forth between the two interfaces a
query that has been built using a QBE interface
can be viewed in SQL by clicking a button. This
feature may help the reader in learning SQL
syntax. 
33
SUMMARY

• Description of Amazon.com database
• Database development of Amazon.com
• Object-Oriented Diagrams
• Normalization
• Physical database design of Amazon .com
• Use of DBMS of ORACLE SQL and MS Access
• Entity-Relationship Diagrams