Team Seven Members

1
(No Transcript)
2
Team Seven Members

• Abdulkarim Al-Otaibi
• Lori Gillis
• David McElhaney
• Mohammad Mehkari
• David Nguyen
• Kashif Riaz

3
Why did we pick Six Continents?
4

• Six Continents is an established corporation with
  a large backbone of data. With an overabundance
  of information we were able to compile a greater
  resource of data for our database.

5
The Six Continents

• The three databases that we selected are
• Holiday Inn
• Holiday Inn Express
• Intercontinental Hotels

6
Six Continents Hotels History

• Heterogeneous Network
• Chains Employees in 94 countries
• Distributed Database
• Synchronous
• Local Autonomy
• Location Transparency

7
(No Transcript)
8
(No Transcript)
9

• Overview of Holiday Inn and Holiday Inn Express
  ERD and EERDs
• Presented by
• Kashif Riaz

10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14

• Overview of how Normalization Increased
  Efficiency of Six Continents
• Presented by
• David McElhaney

15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21

• Overview of Relationships and Queries using
  Oracle and Microsoft Access
• Presented by
• Lori Gillis

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
OUTPUT SQL CREATE TABLE CUSTOMERS 2
(CUSTOMER_ID CHAR(4) PRIMARY KEY, 3 LAST
CHAR(10) NOT NULL, 4 FIRST CHAR(8) NOT NULL,
5 STREET CHAR(15), 6 CITY CHAR(15), 7
STATE CHAR(2), 8 ZIP_CODE CHAR(5)) Table
created.
INPUT CREATE TABLE CUSTOMERS (CUSTOMER_ID CHAR(4)
PRIMARY KEY, LAST CHAR(10) NOT NULL, FIRST
CHAR(8) NOT NULL, STREET CHAR(15), CITY
CHAR(15), STATE CHAR(2), ZIP_CODE CHAR(5))
36
SQL SELECT 2 FROM CUSTOMERS CUST LAST
FIRST STREET CITY ST
ZIP_C ---- ---------- -------- ---------------
--------------- -- ----- 1000 Man Ima
481 Oak Lansing MI
49224 1002 Focker Gaylord 123 Nurse
Grant MI 49219 1003 Johnson Don
46 Vice Miami FL
49034 1004 Bond James 007 Cherry
Kent MI 48391 -------------------
------------------------------------------------
37
SQL SELECT CUSTOMERS.LAST, CUSTOMERS.FIRST, 2
RESERVATIONS.CONFIRMATION_NO,
RESERVATIONS.ARRIVAL_DATE 3 FROM CUSTOMERS,
RESERVATIONS 4 WHERE CUSTOMERS.CUSTOMER_ID
RESERVATIONS.CUSTOMER_ID LAST FIRST
CONF ARRIVAL_D ---------- -------- ----
--------- Man Ima 2000
15-MAY-02 Focker Gaylord 2001
18-MAY-02 Johnson Don 2002
21-JUN-02 Bond James 2003 14-AUG-02
38
Application of Advance Database Concepts

• Presented by
• Mohammad Mehkari

39
Six Continents Database

• The Six Continents is a distributed database
  because of the fact that all of its hotels and
  data are geographically dispersed.
• The Six Continents is a good example of a
  distributed database because its data for
  different hotels is spread physically across
  computers in many locations, which are connected
  by a data communications network.

40
Six Continents Database

• The site of a distributed system may be spread
  over a large area (in our case the United States
  and 94 other countries around the globe).
• Six Continent's distributed database is a
  heterogeneous distributed database environment.

41
Application of Advance Database Concepts
Continued

• Data are distributed across all nodes.
• Different DBMSs may be used at each node.
• Some users require only local access to
  databases, which can be accomplished by using
  only the local DBMS and schema.
• A global schema exists, which allows local users
  to access remote data.

42
Application of Advance Database Concepts
Continued

• The design of the distributed databases at Six
  Continents is synchronous
• With synchronous technology, if any copy of data
  item is updated anywhere on the network, the same
  update is immediately applied to all other
  copies.

43
Application of Advance Database Concepts
Continued

• A major objective of distributed database is to
  provide ease of access to data for users at many
  different locations. To meet this objective the
  Six Continents have provided what is called
  Location Transparency.
• The data at Six Continents is updated rapidly,
  for which it uses horizontal partitioning.

44
Application of Advance Database Concepts
Continued

• All the databases of Six Continents are connected
  to the web so that browsers may interact with the
  web sites by making reservations, and accessing
  updated room rates.
• In addition subjects such as security, data
  integrity, and error fixing all relate to our
  database project.

45
Summary and Conclusion

• Presented by
• Abdulkarim Al-Otaibi

46
Summary and Conclusion

• Each year, more than 150 million people find
  a warm welcome at a hotel or resort bearing one
  of Six Continents Hotels international lodging
  brands. Around the globe, more than 3,200 hotels
  flying the Holiday Inn, Holiday Inn Express,
  Crowne Plaza, Staybridge Suites by Holiday Inn
  and Inter-Continental Hotels and Resorts flags
  offer a variety of services, amenities and
  lodging experiences catering to virtually every
  travel occasion and guest need.

47
Summary and Conclusion Continued

• In order to integrate the information
  stored in such heterogeneous databases, it is
  necessary to form a single integrated schema.
  Conflicts may exist between the various source
  schemas, and the schema integration process must
  remove such conflicts by performing appropriate
  transformations on the participating schemas. In
  this regard, Six Continents adopted a distributed
  database because of the fact that all of its
  hotels and data are geographically dispersed.

48
Summary and Conclusion Continued

• As a matter of fact business conditions today
  encourage the use of distributed databases
  because of the dispersion and autonomy of the
  business units including the globalization of
  organizations.

49
Summary and Conclusion Continued

• In order to better understand the Six Continents
  database in our project we used Entity
  Relationship Diagrams (ERD) and Object Oriented
  Diagrams (OOD) to show the differences of both
  the domestic hotels as well as the international
  hotels. Moreover, in order to show when and how
  it would help a database administrator to utilize
  different criteria for the selected database, we
  used the Normalization techniques to better
  organize and normalize the data.

50
Student Questions
51
David Nguyens Question

• How has horizontal partitioning enhanced the
  database of Six Continents?

52
Kashifs Question
Define what a business rule is and what type of
business rule was used in the holiday inn/holiday
inn express enhanced E-R diagrams?
53
David McElhaneys Question

• Explain why Six Continents is a distributed
  database.

54
Loris Question

• Explain what location transparency is and its
  relationship to Six Continents.

55
Mohammads Question

• What techniques has Six Continents adopted to
  provide ease of access to data for users at many
  different locations?

56
Abdulkarims Question

• What is local autonomy?

57

• Questions Comments