Discussion W9 509

Week 9 Discussion

Ticket Reservations Sales LLC Company provides services to the commercial airlines from its data center.

Ticket Reservations Sales LLC IT System main parameters;

One headquarters and one data center (both are in the same building) Processing 500,000 Tickets a day

It has 520 employees in the headquarters and data-center

Headquarters has two databases

a) Ticket Reservations Sales database

b) HR Employee database

All member airlines were connected to the Ticket Reservations Sales database in the Headquarters via the Internet. Only people within the company can access to the HR Employee database

Consider the given case and answer the following question

Q1) There are two databases, indicate the primary key for each database

Q2) For the Database management system (DBMS);

· Write the advantages of DBMS

· List the DBMS Components for each database

· Interfaces you would have for each database

· Built-in control and security features for each database