ipl-logo

Fly Guys Company Case Study

1028 Words5 Pages

Through the database management system a business will enjoy access to quality information that is crucial for decision making. Fly Guys Company in this case requires a database management system which is accurate and which can be updated regularly. There is no doubt that both Microsoft access and Microsoft Access are incredible when it comes to creating a database. The CEO of Fly Guys Company was looking for Microsoft office application that he could use for database management. The system was required for keeping the details of passengers, booking details made by passenger as well as calculation of price of the passenger tickets based on departure point and destination. The trick on pricing model used by the company is that it offers discount to regular customer of the company and this has to be included in the system. The system would also be used to generate reports with details of number of bookings for each part of the journey. In addition the report would also detail the revenue that is generated in a flight schedule. Lastly the CEO was looking for a system that would generate up to date list of bookings for each day of the working week.
The tasks that the CEO is searching can be …show more content…

The data require a relational database since multiple tables were required for completeness of information. Even if at the moment there were no many passengers the planes could increase in the future as well as the passengers and therefore the growth of database in such a scale could not be accommodated by excel. This could translate into thousands of passengers in a given week and therefore access will be the most likely application to handle such a huge database. When database data need to be shared with other applications Access is more compatible with other database applications such as Microsoft SQL and therefore another reason I chose to use this

Show More
Related

  • Microsoft EN1420 Unit 1 Assignment 1

    67 Words  | 1 Pages

    Microsoft Access is used to stream the database and generate a donor list for 2015. In the beginning, four queries named as: Decreased in this year, Decreased in this year summary, possible and zero donations are created in order to identify the data (show in figure 1). Afterward, I have to import the file to Microsoft Excel and continue the analysis and predictions of future year parts.

    Read More

  • Royal 750 Copier Case Study

    1437 Words  | 6 Pages

    • Finance: Depending on how much the customised solution costs The benefits of each of the products/services to the user

    Read More

  • Comerica Inc: Case Study

    333 Words  | 2 Pages

    1. Which bank is Mike Mayo pushing to sell itself? Mike Mayo is pushing to a sale on Comerica Inc. 2. Do you think the bank would be able to better cut costs as part of a larger bank? Why or why not?

    Read More

  • Cango Strategic Plan Paper

    641 Words  | 3 Pages

    Strategies a. CEO and department directors develop the vision and mission statement b. CEO and department director inform staff of the vision and mission statement Organization Objective 2 Define the levels of

    Read More

  • Nt1330 Unit 3 Essay

    573 Words  | 3 Pages

    A customer demand module would be used to schedule the flight timings based on the customer demand. E.g., if more number of customers traveled from Pakistan to Dubai in the timings of 1:00 pm to 6:00 pm, then system will automatically schedule flights from Pakistan to Dubai with in these timings.  Flight Scheduling Flights will be scheduled using the weather forecaster and customer demand modules.  Database

    Read More

  • Essay Explain The Need For Safe Storage And Efficient Retrieval Of Information

    1229 Words  | 5 Pages

    The information or data that needs to be stored could relate to personal employee information that would need to be password protected so only the relevant people can gain access. Only if date if stored in a procedural manner can it be easily retrieved. This can also help if an external body needs to gain access to records for example auditors. Describe the features of different types of systems used for storage and retrieval of information. There are many different ways in which you can store and retrieve information; the main purpose of storing any information is for easy retrieval in the future when it is

    Read More

  • Sky Factory Case Study

    898 Words  | 4 Pages

    Student’s name Date submitted Course Name and Section Number Unit Number AB207-01-Unit6-Assignment Page Numbers Many successful companies practice open-book management that includes disclosing financial information to all employees. What are the potential benefits of this disclosure? Disclosing financial information to the staff and assisting them in understanding the statistics, because not every employee has economic education and can understand a database, they can observe company’s operations from inside and be aware of the path towards its objectives. When there is some bonus or income distribution plan, workforce will better value program’s performance and see how its labor helps the company achieve these objectives.

    Read More

  • Merlin Entertainments Case Study

    1294 Words  | 6 Pages

    I feel that after my research I can justify that Merlin Entertainments operates by the divisional (diversified) organisational type. I feel this way because the central headquarters of Merlin Entertainments supports a number of different divisions and venues that operate differently and in different locations throughout the world, Merlin have multiple divisions e.g. Alton Towers, Thorpe Park and Madame Tussauds. These operate throughout the world in numerous locations. Merlin Entertainments have a central board of directors who make the decisions that will affect Merlin Entertainments on a wide scale and all of their divisions respectively. These board of directors have the responsibility to make the correct decisions so that Merlin Entertainments

    Read More

  • Case Study Of Snead's Dry Cleaning Company

    1577 Words  | 7 Pages

    Snead’s strategy development plan and financial analysis Snead’s dry cleaning has been successfully operating near downtown Washington, DC for the past thirty years under the sole proprietorship of Sheldon’s uncle. The company provides dry cleaning service to both men and women clothing and has successfully built a great customer base. The company offers two service transaction options to its customers. The service transaction is handled by credit cards and cash payment at the point of picking up items. Customers are sent invoice statements listing service fee and the charge for their service to their credit cards for payment at the end of the month.

    Read More

  • Strand Housing: Job Evaluation Essay

    3641 Words  | 15 Pages

    A tailor – made or “home – grown” scheme might serve the purpose better, since it will be specifically designed by the organization or for the organization based on its own particular needs, culture and operational purposes. Alternatively a “ready – made scheme” could be used, develop by consultants, offering analytical approaches that according to Armstrong (2010) might also “be linked to a market rate database” (p.242). On the other hand, the third option is to employ consultants’ hybrid schemes which can be adjusted to serve the organizations own particular context and

    Read More

  • Hong Kong Dragon Airlines Case Study

    2150 Words  | 9 Pages

    Hong Kong Dragon Air is Hong Kong-based international airline, belonging to of the Cathay Pacific Group. The airline was established in 1985, and operates a fleet of narrow-body A320s and A321s, which were both powered by V2500 engines manufactured by International Aero Engines AG (“IAE”) for both passenger and cargo service to destinations to destinations across the Asia-Pacific region, and China. Their vision is to be the World’s best regional airline serving China and beyond. Their missions; places emphasis on safety and operational excellence with customer focus. The airline seeks to embrace innovation by implementing ideas that improve their business.

    Read More

  • Dbm Comparison Analysis

    1010 Words  | 5 Pages

    Case in point, dynamic sites, bookkeeping data frameworks, finance frameworks and stock administration frameworks depend on inward databases as a compartment to store and deal with their information. Numerous product improve-ment firms today are creating and delivering DBMS frameworks that cost between zero dollars if there should arise an occurrence of free and open-source DBMSs, and a huge number of dollars in the event of exclusive DBMSs. Specifically, every DBMS is por-trayed by an arrangement of assorted utili-tarian and non-practical components and specs each having their favorable circum-stances and detriments. One of which is exe-cution which decides how quick a DBMS can process and execute inquiries. Paper displays a near study from an execution viewpoint between five distinctive DBMSs accessible today available.

    Read More

  • Southwest Airlines Management Accounting System

    1505 Words  | 7 Pages

    One of the fundamental points of interest of the balanced scorecard is capacity for representatives and supervisors to see the relationship between their own execution assessment and money related measures identified with the authoritative objectives. Activity based costing system: To be fruitful in business operations, each organization needs to synchronize its exercises and forms with the corporate statement of purpose, being steady in conveying the item. Southwest Airlines advances itself as an on-time, ease supplier of air travel, conveying the guaranteed essential services to the clients. Organization successfully adjusts its authoritative structure and every single related operation on giving these purchaser services on the reported mission and objectives. Therefore, Southwest Airlines is the best minimal effort supplier of air travel in the United States.

    Read More

  • SWOT Analysis Of Flydubai: Low Fist Airlines

    1467 Words  | 6 Pages

    The airports provide the airline with information such as; the destinations preferred by the customers in the particular

    Read More

  • Advantages And Disadvantages Of Relational Database Management System

    1110 Words  | 5 Pages

    In a relational database management system the data access is privileged which means that the database administrator has the authority of giving access of data to some particular users which makes the data secure. 3. Easy to use: This type of database uses tables which is better and easy to create and use. Disadvantages of RDBMS: 1. Slow:

    Read More

More about Fly Guys Company Case Study

Open Document