how to design a database for an airlines industry?

Question

how to design a database for an airlines industry?

Answer 1

DESIGN A DATABASE FOR AN AIRLINE INDUSTRY? that sounds ambitious.



Follow the standard procedures of course.

Go to the site,

collect requirements,

get it approved,

explain it to your developers,

develop a design document,

get it approved,

codify the design,

unit test it,

integrate,

test,

send it under the name test release,

collect complaints and bug reports,

explain most of them are what they wanted in the requirements,

fix the rest,

send a second test release,

hope to get lesser complaints,

wrap the project and present the final package,

sign off.

Answer 2

David D. is correct (as always it would seem). Before you can design a usable database, you must first understand what your building the database against. Passenger listings? Personal info? Flight times, fuel loss, seating available, seating missing. The initial list could be endless.



If you work for a company you should have someone that handles customer requirements gather what it is the airline wants to track, then build from there. Good luck.

Answer 3

The same way you design any database.



Gather requirements to work out what data needs to be stored, and what the types of the data are. Work out the relationships between them. Represent that data structure in whatever database software you are using.

Answer 4

Or else you may contact a database design expert at websites like http://askexpert.info/

Answer 5

Make sure you include solutions that will help support key functional areas: Financials, Human Capital Management, Operations, and Coporate Services. SAP ER3 is an enterprise resource planning product that could provide a smooth transition. Education and training is offered at the site listed below.