Team

1

• Team 3 Amanda Cooper
• Marcus Gragg
• Rachael Hagan
• Amber Hallmark
• Shontay Scruggs
• Jovita Simon

2
Best Buy
Best Buy Co., Inc is North America's number-one
specialty retailer of consumer electronics,
personal computers, entertainment software and ap
pliances.
3
Best Buy Cont

• The company current operates over 567 stores in
  the United State of America not including their
  distribution centers.
  
• Best Buy has a variety of products like video
  games, videos, camcorders, cameras, office
  products, home appliances, phones, and
  electronics.

4
Best Buy Cont

• As a team, we selected Best Buy website because
  we as future home buyers are interested in
  electronics and household appliances.
  
• The closest store we have is located in Memphis,
  TN.
  
• We decided to choose refrigerators, televisions,
  and laptops databases to do our project.

5
Best Buy Cont

• Distributed database
• Synchronous distributed database
• Heterogeneous Database
• Client/ Server System
• Security Policy

6
E-R Diagramsand Enhanced E-R Diagrams
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
Object-Oriented Diagrams
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
Normalization

• Notebooks/ Laptops
• Televisions
• Refrigerators

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
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
(No Transcript)
34
(No Transcript)
35
(No Transcript)
36
(No Transcript)
37
(No Transcript)
38
(No Transcript)
39
(No Transcript)
40
(No Transcript)
41
(No Transcript)
42
(No Transcript)
43
(No Transcript)
44
(No Transcript)
45
(No Transcript)
46
(No Transcript)
47
(No Transcript)
48
(No Transcript)
49
Access and Oracle Databases
50
Access Database
51
Create Customer Table
52
Insert Data Into Customer Table
53
SQL Database

• BEST_BUY_STORE
• CUSTOMER
• CUSTOMER_ORDER
• FINANCE
• PAYMENT
• Laptops
• COMPAQ_PRESARIO
• COMPAQ_PRESARIO_SPECIAL
• COMPAQ_PRESARIO_STANDARD
• HEWLETT_PACKARD_PAVILLION
• HP_PAVILLION_SPECIAL
• HP_PAVILLION_STANDARD
• LAPTOP_ACCESSORIES
• SONY_VAIO
• SONY_VAIO_INTEL
• SONY_VAIO_INTEL_SPECIAL
• SONY_VAIO_INTEL_STANDARD
• SONY_VAIO_SPECIAL
• SONY_VAIO_STANDARD

• Refrigerators
• BTM_MT_FRIGE_SPECIAL
• BTM_MT_FRIGE_STANDARD
• COMPACT_FRIGE_SPECIAL
• COMPACT_FRIGE_STANDARD
• SIDEBYSIDE_FRIGE_SPECIAL
• SIDEBYSIDE_FRIGE_STANDARD
• TOP_MT_FRIGE_SPECIAL
• TOP_MT_FRIGE_STANDARD
• WATER_COOLER_FRIGE_SPECIAL
• WATER_COOLER_FRIGE_STANR
• Televisions
• FLAT_PANEL_SPECIAL
• FLAT_PANEL_STANDARD
• PROJECTOR_SPECIAL
• PROJECTOR_STANDARD
• STANDARD_TV_SPECIAL
• STANDARD_TV_STANDARD

54
Create Tables

• CREATE TABLE COMPACT_FRIGE_SPECIAL_442
• (MODEL_NUMBER CHAR(20) PRIMARY KEY,
• HEIGHT CHAR(10),
• WIDTH CHAR(10),
• LENGTH CHAR(10),
• DOOR_STORAGE CHAR(10),
• ICE_MAKER CHAR(3),
• WATER_FILTER CHAR(3),
• WARRENTY CHAR(20),
• PRICE DECIMAL (8,2))

• CREATE TABLE COMPACT_FRIGE_STANDARD_442
• (MODEL_NUMBER CHAR(20) PRIMARY KEY,
• SKU_NUMBER CHAR(10),
• CAPACITY CHAR(10))

55
Create Tables

• CREATE TABLE FLAT_PANEL_SPECIAL_442
• (MODEL_NUMBER CHAR(10) PRIMARY KEY,
• SCREEN CHAR(15),
• SCREEN_SIZE CHAR(10),
• HEIGHT CHAR(10),
• WIDTH CHAR(10),
• COLOR CHAR(10),
• SOUND CHAR(20),
• REMOTE_CONTROL CHAR(3),
• DIGITAL_COMPATIBILITY CHAR(3),
• PRICE DECIMAL(8,2))

• CREATE TABLE FLAT_PANEL_STANDARD_442
• (MODEL_NUMBER CHAR(10) PRIMARY KEY,
• SKU_NUMBER CHAR(10),
• STORE_NUMBER CHAR(10),
• WARRENTY CHAR(10))

56
Create Tables

• CREATE TABLE COMPAQ_PRESARIO_442
• (MODEL_NUMBER CHAR(10) PRIMARY KEY,
• HARD_DRIVE_TYPE CHAR(10),
• HARD_DRIVE_SIZE CHAR(10),
• PROCESSOR_SPEED CHAR(10),
• BATTERY_TYPE CHAR(20),
• MAX_CD_ROM_SPEED CHAR(10),
• SCREEN_SIZE CHAR(10),
• LENGTH CHAR(10),
• WIDTH CHAR(10),
• HEIGHT CHAR(10),
• WEIGHT CHAR(10),
• POINTING_DEVICES CHAR(20),
• WARRENTY CHAR(10))

• CREATE TABLE COMPAQ_PRESARIO_SPECIAL_442
• (MODEL_NUMBER CHAR(10) PRIMARY KEY,
• FLOPPY_DRIVE CHAR(3),
• GAME_PORT CHAR(3),
• VIDEO_CARD CHAR(3),
• SOUND_CARD CHAR(3),
• CD_RW CHAR(3),
• DVD_RW CHAR(3),
• MEMORY CHAR(10),
• PRICE DECIMAL(8,2))

57
Create Tables

• CREATE TABLE COMPAQ_PRESARIO_STANDARD_442
• (MODEL_NUMBER CHAR(10) PRIMARY KEY,
• MODEM CHAR(10),
• INCLUDED_SOFTWARE CHAR(20),
• NETWORKING_TYPE CHAR(10),
• SYSTEM_SPEED CHAR(10))

58
Select Queries
59
Select Queries
60
Select Queries
61
Joining 2 Tables

• SELECT SKU_NUMBER, CAPACITY, COMPACT_FRIGE_SPECIAL
  _442.MODEL_NUMBER, HEIGHT, WIDTH, LENGTH, PRICE
  
• FROM COMPACT_FRIGE_STANDARD_442,
  COMPACT_FRIGE_SPECIAL_442
  
• WHERE COMPACT_FRIGE_STANDARD_442.MODEL_NUMBER
  COMPACT_FRIGE_SPECIAL_442.MODEL_NUMBER

62
Joining 2 Tables

• SELECT SKU_NUMBER, STORE_NUMBER,
  FLAT_PANEL_SPECIAL_442.MODEL_NUMBER, SCREEN_SIZE,
  PRICE
  
• FROM FLAT_PANEL_STANDARD_4422, FLAT_PANEL_SPECIAL_
  442
  
• WHERE FLAT_PANEL_STANDARD_442.MODEL_NUMBER
  FLAT_PANEL_SPECIAL_442.MODEL_NUMBER

63
Joining 3 Tables

• SELECT HARD_DRIVE_SIZE, SCREEN_SIZE, WEIGHT,
  COMPAQ_PRESARIO_STANDARD_442.MODEL_NUMBER,
  SYSTEM_SPEED, COMPAQ_PRESARIO_SPECIAL_442.MEMORY,
  PRICE
• FROM COMPAQ_PRESARIO_442, COMPAQ_PRESARIO_STANDARD
  _442, COMPAQ_PRESARIO_SPECIAL_442
  
• WHERE COMPAQ_PRESARIO_442.MODEL_NUMBER
  COMPAQ_PRESARIO_STANDARD_442.MODEL_NUMBER
  
• AND COMPAQ_PRESARIO_442.MODEL_NUMBER
  COMPAQ_PRESARIO_SPECIAL_442.MODEL_NUMBER

64
Conclusion

• We concluded Best Buy to be a heterogeneous
  distributive database, because it is ideal for
  the data sharing. We used local transparency,
  three layered data warehouse, synchronize
  distributed database, horizontal and vertical
  partitioning was used to access data, and other
  applications as described in one previous detail
  discussion

65
Conclusion Cont

• To regulate security, end users and employees do
  not have access to the data warehouse. They do,
  however, have access to data in the warehouse,
  which comes from the data mart.
• With technology improving every year, again, Best
  Buy has daily think of ideas that would improve
  the service to all their customers. Their
  security system is equipped with applications
  that provide users authorizations and
  authentication

66
Ambers Question

• You have 2 tables, Customer and Purchase. You
  want to know the ID Number, Phone Number, and
  Address from the Customer table. You also want to
  know the Purchase Order Number, Purchase Amount,
  and the Order Date from the Purchase table. You
  want this information for Customer 1002, and you
  want it all in one table, how would you do that?

67
Amandas Question

• What are some of the advantages Best Buy has by
  using a distributed database?

68
Shontays Question

• Why does Best Buy use data replication?

69
Jovitas Question

• Will a view increase data security? Why or why
  not.

70
Jovitas Answer

• Yes, it does. The view can be built to present
  only the data to which the user requires access,
  effectively preventing the user from viewing
  other data that may be private or confidential.
  The user may be granted the right to access the
  view, but not to access the base tables upon
  which the view is based.

71
Rachels Question

• What is e-commerce?
• What are some of the security measures Best Buy
  use to protect their
  
• e-commerce security?

72
Marcuss Question

• Best Buy has millions of customers and has to
  make sure its database up to date and running
  well so they can keep their customers happy.
  What are the five areas of DBMS management that
  should be addressed to keep a well maintained
  database and tell a little about all five?