Proiect Access - Agentie de Turism

Proiect
6/10 (1 vot)
Domeniu: Calculatoare
Conține 2 fișiere: doc, mdb
Pagini : 10 în total
Cuvinte : 740
Mărime: 205.40KB (arhivat)
Cost: 5 puncte
ACADEMY OF ECONOMIC STUDIES BUCHAREST -FACULTY OF BUSINESS ADMINISTRATION IN FOREIGN LANGUAGES-

Extras din document

- The verbal model

The TUI Travel Agency has specialized over the years to meets its customers' expectations and even to exceed them. The company has decided to optimize its booking service. Thus, a database was created in order to simplify and better coordinate the internal and external customers.

The TUI Travel Agency has Customers, which it accounts by their ID number, Name, Address, Nationality - which can be R (Romanian) or F (Foreign), Type (can be A-adult, U-under aged, S-senior, VIP) and Account (number).

The agency also provides Routes, which have an ID, a certain Length, Type (circuit - C or stay - S) and Destination.

For each route, there are Transportation Means, identified by the Transport ID, the Type of the transportation mean (it can be a plane, boat or bus), the Class (which can be E-economic, S-standard or B-business) and the Fee charged to the customer for using the transportation mean. The transportation strictly follows a certain Route (Route_ID).

The TUI Travel Agency also has records of the Personnel managing the transportation. Each member of staff is identified by an ID number, a Name, the Type (driver - for busses, captain - for boats or pilot - for planes). Each member of personnel drives a Transportation means (Transportation_ID).

When a client makes a reservation, it is accounted into Bookings. A booking contains a Client ID, the Route ID, the Hotel ID and the ID of the Transportation mean.

For each booking, a hotel must be available to accommodate the guests. For all Hotels, we have a Hotel ID, a Location, the length of the Stay and the Price charged to the guest.

Preview document

Proiect Access - Agentie de Turism - Pagina 1
Proiect Access - Agentie de Turism - Pagina 2
Proiect Access - Agentie de Turism - Pagina 3
Proiect Access - Agentie de Turism - Pagina 4
Proiect Access - Agentie de Turism - Pagina 5
Proiect Access - Agentie de Turism - Pagina 6
Proiect Access - Agentie de Turism - Pagina 7
Proiect Access - Agentie de Turism - Pagina 8
Proiect Access - Agentie de Turism - Pagina 9
Proiect Access - Agentie de Turism - Pagina 10

Conținut arhivă zip

  • Proiect Access - Agentie de Turism
    • Proiect Access - Agentie de Turism.doc
    • tui.mdb

Alții au mai descărcat și

Promovarea unei Pensiuni Turistice prin Intermediul unui Site Web

INTRODUCERE Motivatie Una dintre transformarile care caracterizeaza mediul actual - si care reprezinta o provocare de al carei raspuns depinde în...

Proiect Baze de Date - Microsoft Access - Evidenta Salariatilor unei Firme

Am ales ca tema pt acest proiect “Evidenta Salariatilor Unei Firme “. Pt aceasta am creat 4 tabele dupa cum urmeaza : 1. Salariati : IDSalariat,...

Baza de Date Access - Gestiune Farmacie

Notiuni introductive Bazele de date reprezinta colectii de date organizate într-un mod riguros, bine stabilit. Ele nu contin date care nu sunt...

Analiza Agentiti de Turism Golden Travel

Proiectul Excel Aceasta parte a proiectului contine un document numit "Index", din care prin link-uri utilizatorul este redirectionat catre toate...

Te-ar putea interesa și

Turismul rural în Banat

Prima definiţie a turismului datează din anul 1880 şi aparţine lui E. Guy Freuler: ”un fenomen al timpurilor moderne bazat pe creşterea...

Ai nevoie de altceva?