KANSAS STATE UNIVERSITY
CIS562 - ENTERPRISE
INFORMATION SYSTEMS
Fall 2014 Semester
PROJECT: Airline Flights Finder Application
Student: Pedro
Francisco Borges Pereira
Under the
guidance of
Professor
Stephane Faroult
Context
The MS-Access application we describe in this document is
intended to be a prototype.
It shall be used as a guideline, a specification, to build a
Web Application, using .Net, PHP, or other equivalent tool.
It is an “academic project”, it is not sophisticated enough
to a “real life” use, but, still, we think that everything that has been
implemented makes sense. Maybe you can
even find some interesting logical approaches and useful programming techniques.
Most of the application business logic has been built on the database layer - SELECT commands, views, User Defined functions. It can be easily converted to other databases - SQL Server, Oracle, MySQL.
There is some Visual Basic for Applications code to "fire" the database engines. We think it is easily implementable in Java, C#, PHP and other languages.
Most of the application business logic has been built on the database layer - SELECT commands, views, User Defined functions. It can be easily converted to other databases - SQL Server, Oracle, MySQL.
There is some Visual Basic for Applications code to "fire" the database engines. We think it is easily implementable in Java, C#, PHP and other languages.
Overview
This project’s goal is to build an application to find Flights between “City A” and “City
B”.
Has been developed as a homework in the course CIS 562 –
Enterprise Information Systems, under guidance of Professor Stephane Faroult,
at Kansas State University (Manhattan, Kansas) in the Fall 2014 semester.
If you want to see demonstrations of how to query a relational database, I'm sure you'll find this pretty interesting, with examples of simple SELECTs, JOINS, SELECT from views, aggregate functions, (reasonably) sophisticated filter criteria, and cartesian products.
User Defined Functions in SELECT lists - to calculate the distance between two Airports using Latitude and Longitude, and to calculate the Arrival Time taking in account the Timezones - are an useful feature, also.
As a by-product, the app also contains a recursive algorithm. That's how the app can find any number of needed connections.
To read more, download the PDF Document.
To run this application, download the MS-Access file.
No comments:
Post a Comment