The Use of Relational Database in Air Indiana

100 views 2 pages ~ 340 words
Get a Custom Essay Writer Just For You!

Experts in this subject field are ready to write an original essay following your instructions to the dot!

Hire a Writer

Air Indiana Airlines and Relational Database

Air Indiana is an airline service provider that focuses on offering skydiving training and lessons to customers through a student program as well as providing recreational jumps for the customers who are not in the student program (Air Indiana n.p). The Air Indiana service can benefit from the use of the relational database as a result of the relationships that must be maintained for the services to be achieved. The first operation that will benefit from the use of relational database involves assigning pilots to flights. The flight number and the pilot ID will act as the primary keys to determine the relationship. Secondly, services offered to students and customers can be aligned in the database through the use of Student ID and Customer ID in relation to the flight number. The company can benefit from relational databases in the two operations, including pilot assignment to flights and skydiving training and services to students and customers respectively.

Requirement Analysis Phase

The requirement analysis phase is important for the provision of stakeholder data and information required to prevent future shortcomings in the use of the relational database (Rosenblum n.p). On the part of the students and customers, the most important information required to consist of names, ID numbers and type of service to be offered, that is either skydiving training for students or recreational jumping for customers. On the other hand, the pilot information will include names, pilot ID, level of experience and the flight number to the fight they will be assigned. Lastly, the flight information will consist of the flight number, departure time and arrival time. The information and data collected from the stakeholders will be significant for the creation of the foreign keys and primary keys during the preliminary design phase of the relational database.

Works cited

Air Indiana. "About Air Indiana". 2018, http://www.airindianaskydivingcenter.com/about

Rosenblum, Michael, and Paul Dorsey. "Knowing Just Enough About Relational Databases - Dummies". Dummies, 2018, https://www.dummies.com/programming/sql/knowing-just-enough-about-relational-databases/. Accessed 8 Sept 2018.

September 11, 2023
Category:

Business Economics Life

Subject area:

Company Customer

Number of pages

2

Number of words

340

Downloads:

59

Writer #

Rate:

4.8

Expertise Customer
Verified writer

I enjoyed every bit of working with Krypto for three business tasks that I needed to complete. Zero plagiarism and great sources that are always fresh. My professor loves the job! Recommended if you need to keep things unique!

Hire Writer

This sample could have been used by your fellow student... Get your own unique essay on any topic and submit it by the deadline.

Eliminate the stress of Research and Writing!

Hire one of our experts to create a completely original paper even in 3 hours!

Hire a Pro

Similar Categories