Database Discussion

profilememzr1989
Data2lemonflowerz.r.docx

Running Head: DATA 1

DATA 2

My friends answer

1-

COLLAPSE

Application Where Databases are used

With an increase in the use of Information technology, it has become easy to gather data and store it I a server in the form of a database. In this database, the data is organized, stored and retrieved by multiple or end-user in several ways, making him benefit from this data for his work. Making the task easy, faster, efficient and reliable is the main reason that people create a database for use in an organization or even for personal issues. For organization, the database may be a straightforward cash sale, inventory, ticket reservation, accommodation services reservation or even data regarding the employee. In this case, the employee database will be considered, looking at its key attributes, and that makes such a system usable, thus serving the purpose they are created to do. Hotel reservation system is one such application using database for information processing. The database is used to calculate and determine how much the customer will be judged base on the services the client wish to utilizes while on board

Hotel Reservation System

Client name

Nationality/ID /PASSPORT NUMBER

Arrival date

Place to pick

Typo of room

Baggage weight and size

Number of beds

Accompanied by child /spouse

Departure date and time

John Vena

1234JDWE44

23 MAY

2PM

MK airport

executive

10kg 5m2

1

NA

25 MAY

3PM

.

The key attributes for this database application are arrival name of client, National ID/Passport, date arrival time, place to be picked from, baggage approximate weight and size, double or singe bed. Type of room needed (executive, business or economy class), departure time and date. Need to be escorted to airport and inclusive of meals. The Primary key for this database is the room number

The relation of the data collected here is the need to understand the kind of services suitable for this client and what he will be charged. The client will thus pay based on the services rendered or consumed.

2- Other friend answer

Example of the database is "Mawid" application by Ministry of Health‏

Name

National ID

Age

Gender

Phone number

City

Date

Time

Clinic

Doctor

Sara

5493692

22

Female

05794242

Riyadh

01/4

9:00 AM

General Medicine

Osama

Ahmad

4134098

2

Male

05487134

Riyadh

22/4

11:00 AM

Pediatric

Muhammed

Amal

5702345

41

Female

05952345

Riyadh

09/4

12:30 PM

Nutrition

Asma

Norah

5293548

69

Female

05323978

Riyadh

15/4

10:45 AM

Diabetes

Muna

The Keys can be National ID, Name, Time and Phone number.

Attributes are Name, National ID, Age, Gender, Phone number. City, Date, Time and Clinic.

___________________________

I need 2 line comment for these two answers please