Tolgay Parlakyigit

1

• Tolgay Parlakyigit
• Philbert Amuzu
• Maria Bramer
• Dries Habex
• Matt Bell

2
INTRODUCTION

• Dell was founded in 1984 by Michael Dell out of
  his college dorm room.
• They sell computer systems directly to customers
  eliminates retailers that add unnecessary time
  and cost
• Understands customers needs by letting them
  customize their own computer setup.
• Used in many American institutions as well as ASU

3
Four Major Options

• Home Home Office
• Small Business
• Medium Large Business
• Government, Education, and Health Care

4
DATABASE STRUCTURE

• Centralized database all orders placed from a
  central location on the website.
• Multiple servers at the Dell facilities allowed
  for load balancing and expandability.
• Hierarchical database technology The Homepage is
  the point of entry and branches out from there.

5
continued

• Dells databases run Oracle database server on a
  Windows 2000/2003 platform
• Some of the servers include
• www1.us.dell.com
• catalog.us.dell.com
• configure.us.dell.com
• ecomm.dell.com

6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
Desktop
14
Notebook
15
Workstation
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
(No Transcript)
26
(No Transcript)
27
Access Relationships
28
Access Order Table
29
Access Standard Features Table
30
Access Optional Features Table
31
Customer query design table
32
Customer query table
33
SQL
CREATE TABLE ORDERS ( ORDER_ID CHAR(4) PRIMARY
KEY, CUST_ID CHAR(4) REFERENCES
CUSTOMER, DATES CHAR(10) NOT
NULL, SERIAL_NUMBER CHAR(25) REFERENCES
DEVICE, AMOUNT CHAR(9) NOT NULL )
34
Queries
SQLgt select first_name,last_name,state 2
from customer 3 where state
'AR' FIRST_NAME LAST_NAME
ST -------------------- ----------------- ---
-- David Heck
AR Dina Smith
AR
35
SQLgt select o.amount,c.last_name,c.first_name 2
from orders o, customer c 3 where
o.amount gt 600 and 4 o.cust_id
c.cust_id AMOUNT LAST_NAME
FIRST_NAME ------------- ------------------
------------------ 649
Heck David 674
Canster Mark 674
Pane
James 1099 Mikael
Juliet 974 Smith
Dina
36
Phils Question

• What are some advantages of stored procedures
  that Dell computer uses to implement application
  logic?

37
Matts Question

• What measures does Dell take to ensure network
  security?

38
Marias Question
How do you select the customer names that have a
balance higher than 600 in the orders table?
39
Driess Question
What does this picture mean?
40
Tolgays Question
How do you make a relationship in Access?