Case Study Study Paper

1 . 0Overview of the case analyze

Background from the Study

Sweeney Tours is actually a holiday local travel agency offering package deal holidays into a number of areas in the Mediterranean. The holidays travel from many airports in britain and have a fairly complicated pricing Structure. There is a great deal of information in the brochures that Sweeney Travels produce along with a great Accompanying cost guide. A few of the information is definitely on computer system but this is somewhat troublesome as it is in separate systems that are contrapuesto, incomplete and difficult to use. It can be particularly difficult to get holidays that match a customer's specific requests until the leaflet is looked at carefully. Sweeney Tours decided to automate the information in their brochure and include reserving information to really succeed to: 2. Gather particular information coming from customers and answer questions about the holidays 2. Check availability of specific packages

* Provide costs of packages

* Take bookings

1 . 1Purpose

1 . To become familiar with MySql.

2 . To know and experience a data book

3. To be familiar with the info definition and manipulation language SQL. 4. To understand referential integrity

a few. To explore the existing database intended for the Sweeney Tour system.

1 . 2Problems

COUNTRY (country, language, timezone, currency)

LOCATION (region, landtype, country, scenery, page)

VACATION RESORT (resort, place, transfertime, seaside, beachnum, page) HOTELS (hotel_id, hotelname, sunbeam, ya, score, stdbasis, page, resort, resortloc, roomtotal) FACILITIES (facid, explanation, category)

FACINRESORT (resort, facid)

FACINHOTEL (hotelid, facid, numof)

1 . 3Normalization

1 . a few. 1 Initially Norm

REGION (countryCode, countryName, language, timezone, currency) REGION (regionNo, landtype, countryCode, scenery, resortID)

VACATION RESORT (resortID, resortloc, regionNo, transfertime, beach, beachnum, page) ACCOMMODATIONS (hotel_id, hotelname, sunbeam, en este momento, rating, stdbasis, resortID, roomtotal) FACILITIES (facid, description, category)

FACINRESORT (facsort_Code, resortID, facid)

FACINHOTEL (factel_Code, hotel_id, facid, numof)

1 ) 3. 2Second Norm

REGION (countryCode, countryName, language, timezone, currency) REGION (regionNo, landtype, scenery)

HOTEL (resortID, resortloc, transfertime, beach front, beachnum, page) HOTELS (hotel_id, hotelname, sunbeam, ya, score, stdbasis, roomtotal) FACILITIES (facid, description, category)

FACINRESORT (facsort_Code)

FACINHOTEL (factel_Code, numof)

1 . 3. 3 Third Tradition

COUNTRY (countryCode, countryName, vocabulary, timezone, currency) REGION (regionNo, landtype, scenery)

RESORT (resortID, resortloc, transfertime, beach, beachnum, page) RESORTS (hotel_id, hotelname, sunbeam, ya, rating, stdbasis, roomtotal) FEATURES (facid, explanation, category)

FACINRESORT (facsort_Code)

FACINHOTEL (factel_Code, numof)

countryCode (counrtyName, language, timezone, currency)

regionNo (landtype, countryCode, scenery, resortID)

resortID (regionNo, transfertime, beach front, beachnum, page)

hotel_id (hotelname, sunbeam, ya, rating, stdbasis, resortID, roomtotal) facid (description, category)

facsortCode (resortID, facid)

factelCode (hotel_id, facid, numof)

1 ) 3. 4 Fourth Usual

many to several relationsip allowed in ERD but not in Relational Database. country

countryCode

language

timezone

currency

features

landtype

regionNo

countryCode

surroundings

region

countryName

has

holiday resort

regionNo

web page

beachnum

seashore

transfertime

has

resortName

stdbasis

resortID

ranking

hotel_id

sunbeam

ya

resortID

hotelname

roomtotal

hotels

resortid

has

hotel_id

factelCode

numof

facid

explanation

has

facid

category

service

facsortCode

resortID

facinresort

facinhotel

has

provides

resortloc

1 . 3. five Fifth tradition

1 . 3. 6 6 norm

region

countryCode

dialect

timezone

money

has

landtype

regionNo

countryCode

scenery

area

countryName

features

resort

regionNo

page

beachnum

beach

transfertime

has

resortName...



Related

Category

News