Team 3SANYO Database

About This Presentation

Title:

Team 3SANYO Database

Description:

Together the two plants capacity is over 3 million televisions annually. CONT'D ... Under Entertainment (Televisions) Under Office Equipment (Projectors) OBJECTIVES ... – PowerPoint PPT presentation

Number of Views:55

Avg rating:3.0/5.0

Slides: 34

Provided by: tan975

Category:

more less

Transcript and Presenter's Notes

Title: Team 3SANYO Database

1
TEAM 3 Jonathan Baker Tonya Baker Shanddeikka
Beechem Visa Metcalf Elvin Turner
2
Introduction

From that dynamic start in the 1950's, SANYO grew
by leaps and bounds expanding to all corners of
the globe as was envisioned when the company was
named "SANYO", or three oceans. As an all around
consumer electronics and appliance manufacturer,
SANYO factories not only supplied the products
that revolutionized lifestyles, but it created
economic opportunities to people in 26 countries
across the world.

3
CONTD

SANYO Manufacturing Corporation's two facilities
in Forrest City, Arkansas and Tijuana, Mexico are
both ISO 9001 and ISO 14001 certified. Together
the two plants capacity is over 3 million
televisions annually

4
CONTD

Today, SANYO has evolved into a global leader,
championing a vast array of promising new
technologies, including PCS phones, alternative
energy sources, LCD display panels and digital
cameras to name just a few.

5
ITEMS CHOSEN FOR THIS PROJECT

Under Home Appliances (Microwaves)
Under Entertainment (Televisions)
Under Office Equipment (Projectors)

6
OBJECTIVES

Description of ER, EER, and OOD Diagrams
Description of the Normalization tables
Overview of Access Database
Brief look at some SQL queries
Summary and Conclusion of adv database concepts
that were applied in this project
Question by each team member

7
(No Transcript)
8
(No Transcript)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
(No Transcript)
16
1st NF TV
17
(No Transcript)
18
(No Transcript)
19
3rd NF Features
20
3rd NF Payment Method
21
Microsoft Access
22
SQL

SQL CREATE TABLE CUSTOMER_SANYO
2 (CUSTOMER_ID CHAR(5),
3 LAST CHAR(15),
4 FIRST CHAR(5),
5 STREET CHAR(15),
6 CITY CHAR(15),
7 STATE CHAR(2),
8 ZIP_CODE CHAR(5),
9 PHONE_NUMBER CHAR(11),
10 EMAIL CHAR(50))
Table created.
SQL CREATE TABLE SANYO_PLANT
2 (PLANT_NUMBER CHAR(3),
3 PLANT_NAME CHAR(30),
4 STREET CHAR(15),
5 CITY CHAR(15),
6 STATE CHAR(2),

SQL DESCRIBE CUSTOMER_SANYO
Name Null?
Type
-----------------------------------------
-------- ----------------------------
CUSTOMER_ID NOT
NULL CHAR(5)
LAST
CHAR(15)
FIRST
CHAR(5)
STREET
CHAR(15)
CITY
CHAR(15)
STATE
CHAR(2)
ZIP_CODE
CHAR(5)
PHONE_NUMBER
CHAR(11)
EMAIL
CHAR(50)
SQL DESCRIBE SANYO_PLANT
Name Null?
Type
-----------------------------------------
-------- ----------------------------
PLANT_NUMBER NOT
NULL CHAR(3)
PLANT_NAME
CHAR(30)
STREET
CHAR(15)

24
Advanced Database Concepts from MIS 3413

Client/Server Database Environment
Internet Database Environment
Distributed Database
Data and Database Administration

25
Client/Server Database Environment

Client/Server systems operate in networked
environments, splitting the processing of an
application between a front-end client and a
back-end processor

26
Internet Database Environment

Several characteristics of the Web environment
have supported the rapid adoption and
implementation of Internet and Intranet business
applications

27
Distributed Database

Distributed Database is a single logical database
that is spread physically across computers in
multiple locations that are connected by a data
communications link

28
Data and Database Administration

Data Facts, text, graphics, images, sound, and
video segments that have meaning in the users
environment
Database Administration A technical function
that is responsible for physical database design
and for dealing with technical issues

29
Visa Questions