Premium Essay

Efficient Passanger Service System Using Auto-Sync Database Updates

In: Computers and Technology

Submitted By arimi
Words 9838
Pages 40
-------------------------------------------------
WESTERN GOVERNORS UNIVERSITY
-------------------------------------------------
Submittal Cover Sheet
-------------------------------------------------

-------------------------------------------------
Date: 7-21-2015
-------------------------------------------------
Student Name:
-------------------------------------------------
Student ID Number:
-------------------------------------------------
Student Degree Program: BS-IT
-------------------------------------------------
Student Email: tryyg@wgu.edu
-------------------------------------------------
Four Digit Assessment/Project Code: ENT1
-------------------------------------------------
Mentor Name: Tiffany Trissel-Griffey
-------------------------------------------------
For Revisions Only Indicate Previous Grader:
-------------------------------------------------

-------------------------------------------------

-------------------------------------------------
Submit to:
-------------------------------------------------
Western Governors University
-------------------------------------------------
Attn.: Assessment Delivery Department
-------------------------------------------------
4001 South 700 East, Suite 700
-------------------------------------------------
Salt Lake City, Utah 84107-2533
-------------------------------------------------

------------------------------------------------- wgusubmittals@wgu.edu Capstone Project Cover Sheet

Capstone Project Title: Efficient Passenger Services System Using Auto-Sync Database Updates

Student Name:

Degree Program:

Mentor Name:

Signature Block Student’s Signature

Mentor’s Signature

Table of Contents

Table of Contents 3 List of Tables 5 List of Figures 5 Capstone Report Summary (Introduction) 6 Problem Statement 6…...

Similar Documents

Free Essay

Auto Navigation Systems Are for Work

...Auto Navigation Systems are for Work, Play, and Everything in Between Back in the dark ages, it was nearly impossible to navigate the shark-infested waters of Main Street or big city USA without the assistance of a road map or some other major navigational aid. Back then if you found yourself lost you either had to stop and ask for directions at a convenience store along the way or drive along until you found a payphone you could use in order to call for better directions. This process became a little easier once cell phones became prominent and affordable to the masses. Today it has become even better if you can believe it. Gone are the days when you drove around in circles hoping to find a place to stop and get directions to take you back to the beaten path before your gas tank uses the last of its fumes. Now you can simply use GPS tracking to find out where you are and then get directions to the nearest destination of choice or simply find your way back towards your destination. You can actually go on vacation now without taking a massive road atlas or a half dozen maps of a half dozen states along for the ride. Gone are the days of needing a tour guide in order to fold your maps back into their former positions. Vacations are now much more relaxed as a result of the lack of stress involved in merely getting there. Not only is getting there easier with the use of auto navigation systems, but getting around once you reach your vacation destination is much easier......

Words: 675 - Pages: 3

Premium Essay

Paper on Database Management Systems

...International Journal of Scientific & Engineering Research Volume 3, Issue 3, March -2012 ISSN 2229-5518 1 A Distributed Transaction Model for a Multidatabase Management System Omar Baakeel and Abdulaziz Alrashidi Abstract— This paper examines the distributed transaction issues that are present in multi-database management systems (DBMSs) and how the distributed transaction in database technology differs from other distributed processing systems. Some common issues that arise with the distribution of transactions over a multi-DBMS while dealing with concurrency control and recovery are highlighted, such as site failure, network failure, and time failure. This study proposes an exceptional distributed transaction model for processing transaction queries in multi-DBMS based on the idea that a complete database can be constructed at any stage. Index Terms— Database management system (DBMS), distributed transaction, transaction management, transaction network —————————— —————————— 1 INTRODUCTION ENERALLY, a distributed transaction is defined as a transaction that updates data on two or more networked computer systems. Different conceptual structures for processing transaction elements are required to meet certain needs of applications that must update distributed data in terms of peer to peer connection. Developing a transaction model is difficult because most of these techniques are customized for a single transaction point, and many types of failures, such as client......

Words: 2094 - Pages: 9

Premium Essay

Database Management System

... DATABASE S YSTEMS DESIGN, IMPLEMENTATION, AND MANAGEMENT CARLOS CORONEL • STEVEN MORRIS • PETER ROB Australia • Brazil • Japan • Korea • Mexico • Singapore • Spain • United Kingdom • United States Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Database Systems: Design, Implementation, and Management, Ninth Edition Carlos Coronel, Steven Morris, and Peter Rob Vice President of Editorial, Business: Jack W. Calhoun Publisher: Joe Sabatino Senior Acquisitions Editor: Charles McCormick, Jr. Senior Product Manager: Kate Mason Development Editor: Deb Kaufmann Editorial Assistant: Nora Heink Senior Marketing Communications Manager: Libby Shipp Marketing Coordinator: Suellen Ruttkay Content Product Manager: Matthew Hutchinson Senior Art Director: Stacy Jenkins Shirley Cover Designer: Itzhack Shelomi Cover Image: iStock Images Media Editor: Chris Valentine Manufacturing Coordinator: Julio Esperas Copyeditor: Andrea Schein Proofreader: Foxxe Editorial Indexer: Elizabeth Cunningham Composition: GEX Publishing Services © 2011 Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced, transmitted, stored or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as......

Words: 189848 - Pages: 760

Premium Essay

Database Systems

...DATABASE SYSTEMS To understand what drives database design, you must understand the difference between data and information. Data are raw numbers or other findings which, by themselves, are of limited value to decision makers. Information, on the other hand, is the result of organizing, processing, and interpreting data, thus transforming the findings into facts that are useful to decision makers. For example, the number of new users your clinic serves in a month means little until you compare it with the number of new users from previous months and years to see whether there has been an increase or decrease in the trend over time. Data are transformed into information by: Selection: Choosing the data that are useful and adequate for answering the questions that have been posed, and ignoring the data that are useless or inadequate for that purpose. Interpretation: Analyzing the data to put them into context, uncover patterns or problem areas, and reflect on the meaning of these patterns in relation to the questions being asked. The overall objective of converting data to information is to describe, explain, predict, and/or evaluate a program and its results. In this “information age” production of accurate, relevant and timely information is the key to good decision making. In turn, good decision making is the key to business survival in a global market. We are now said to be entering to “knowledge age”. Data are the foundation of information which is bedrock of......

Words: 4278 - Pages: 18

Free Essay

New Updates for Service Pack Features

...files_________. 4. The servers in a network load balancing cluster continually exchange status messages called ________heartbeats__. 5. Windows Server 2008 servers can maintain multiple versions of a volume’s files using a feature called __shadow copies________. 6. The process by which servers are automatically added to and removed from a network load balancing cluster is called __convergance________. 7. A failover cluster stores its configuration database on a ___witness disk_______. 8. The role service that enables disconnected Terminal Services clients to reconnect to the same server is called _____TS session broker_____. 9. The application high availability mechanism that uses redundant servers, with all running simultaneously, is called ___network load balancing_______. 10. The Windows Server 2008 feature that enables a computer to verify an application before launching it is called _windows installer 4.0_________. Multiple Choice: Select one or more correct answers for each of the following questions. 1. In addition to the application data, which of the following is stored on a failover cluster’s shared storage? a. the Failover Cluster management console b. the witness disk c. the TS Session Broker database d. the Shadow Copies database 2. Which of the following Windows Server 2008 features enables users to access files that they have accidentally overwritten? a. Offline Files b. parity-based RAID c. Windows......

Words: 1225 - Pages: 5

Premium Essay

Using a Database

...amazingly simple thanks to their use of databases. Now rather than calling or driving around to various video stores to attempt to find the movie you desire, it’s as simple as logging on to the website or app. Once logged on you have a choice of searching your favorite kiosk or searching them all within a particular mile radius of where you are that you specify and find the movie of your choice. This involves the use of multiple bases, one for usernames and passwords, one that has listings of movies where they are located and if they are available as well as keeping your credit card information in a database and charging it when you decide to checkout. The applications use of these databases makes it easier on the user to find what they are looking for and checkout in just a few easy steps. Now if driving to the kiosk could be as simple. One way that I would improve on what Redbox already uses is to add these same features to the kiosk itself. For example if I happen to walk up to a Redbox kiosk without having a reservation, that kiosk my not have the movie I’m looking for and cannot suggest a kiosk nearby like the website or apps can. I would like to see a kiosk that can tell me they do not have the video that I am looking for available but one nearby does and that I can choose to reserve it at the kiosk I am at and drive over to the other kiosk to retrieve it. This simple addition to the database would make an already great database even better....

Words: 314 - Pages: 2

Premium Essay

Database Systems for Business

...Introduction In the following assignment I will present an introduction to databases which will demonstrate my knowledge through creating reports, defining key terms and there advantages and disadvantages, as well as designing an entity model. These will support my knowledge. TASK 1 Diagram 1: Marks & Spencer’s three-layer relational database architecture related to their online activities. Internal Schema (Server) Conceptual Schema (Programmer) External (Customer) External (Supplier) External (Business partners) External (Departments) As shown in diagram 1, a 3-layer Relational database separates the physical database from the user applications. The following schemas are defined at each of the following levels: * Internal * Conceptual * External “The DBMS is responsible for mapping between these three types of schema. It must also check the schemas for consistency.” (Connolly, T. 2005 Pg. 37) This means the DBMS must ensure that each set of data relates to each other e.g. the information used from the conceptual schema needs to map between both the internal and external schemas. Internal schema: Within this level, the internal schema shows “physical representation of the database on the computer. This level describes how the data is stored in the database.” (Connolly, T. 2005 Pg. 36) This uses a physical data model......

Words: 2877 - Pages: 12

Premium Essay

Cloud Database Management System

...Cloud Database Management System IS508E group NO.6 project Group NO.6 members: PENG Yu KALAI Kumaraguru KUTTIKKAT VENUGOPAL Sreehari Contents General business case ............................................................................................................... 1 Introduction and problems ....................................................................................................... 1 The existing technology ............................................................................................................ 2 Challenges of Implementation: ................................................................................................. 9 Reference: ............................................................................................................................... 10 General business case Thanks to the successful management, the business of the company expands very fast. However, the database management system cannot withstand the quickly and greatly increased work load, the break-down frequency increases, which make the decision-making efficiency and customer experience drop. The company tries to turn around this bad trend and poses two solutions: one is to update the present DBMS including hardware, software and human resource; the other one is to make use of SQL Azure from Microsoft to set up cloud environment and transfer the DBMS there. After cost analysis, we find that to reach the same efficiency standard, the cost......

Words: 3594 - Pages: 15

Premium Essay

Database System

...Hector Platon Carol Segura Fundamentals of Database Systems CS251-1303B-03 20 Aug 2013 According to Mike Chapple, Server Base Databases (Microsoft SQL, Oracle or IBM DB2) are commonly used in large organization as this type of database is able to handle sufficient amount of data simultaneously within reach of any users. This data is being updated to the server once a user resaves the file (Chapple, 2013). Server Base Database offers flexibility, powerful performance and scalability for its users which makes it a major choice for servers in most organizations. File Database (QSYS, SQLite) uses simple functions and generally uses single disk file. File Database can use several platforms. File Database can be used in 32 bit and 64 bit systems. File Database offers an excellent array of stability to its users as it functions cross platforms. Data sharing is better processed in bigger line of database management systems such as server base, wherein throughout the organization the synchronization of data is immense and constant changes is created simultaneously while File database may offer and give out cross formatting features for its clients however it can only handle minimal amount of data and is rather less reliable than the server base (Hip, 2013). My recommendation to my supervisor is to use a single database in both receiving and shipping area. The conflict begins with the shipping department that uses a Cobol program that is a stand-alone and......

Words: 480 - Pages: 2

Premium Essay

Database System

...Only. Computer Science Volume 1 Silberschatz−Korth−Sudarshan • Database System Concepts, Fourth Edition Front Matter 1 1 11 11 35 35 36 87 140 140 141 194 229 260 307 307 308 337 363 393 393 394 446 494 529 563 563 564 590 637 Preface 1. Introduction Text I. Data Models Introduction 2. Entity−Relationship Model 3. Relational Model II. Relational Databases Introduction 4. SQL 5. Other Relational Languages 6. Integrity and Security 7. Relational−Database Design III. Object−Based Databases and XML Introduction 8. Object−Oriented Databases 9. Object−Relational Databases 10. XML IV. Data Storage and Querying Introduction 11. Storage and File Structure 12. Indexing and Hashing 13. Query Processing 14. Query Optimization V. Transaction Management Introduction 15. Transactions 16. Concurrency Control 17. Recovery System iii VI. Database System Architecture 679 679 680 705 750 773 773 774 810 856 884 Introduction 18. Database System Architecture 19. Distributed Databases 20. Parallel Databases VII. Other Topics Introduction 21. Application Development and Administration 22. Advanced Querying and Information Retrieval 23. Advanced Data Types and New Applications 24. Advanced Transaction Processing iv Silberschatz−Korth−Sudarshan: Database System Concepts, Fourth Edition Front Matter Preface © The McGraw−Hill Companies, 2001 1 Preface Database management has evolved from a specialized computer application to a......

Words: 301237 - Pages: 1205

Premium Essay

Database Systems for Business

...How can Play On Toys ensure its information technology systems are ready for growth? Issue: Play On Toys has enjoyed 5 years of success in the European market, experiencing strong growth, particularly in the past year, increasing its staff from 16 to 60 employees. With 200 customers, Play On Toys fulfils 3000 orders annually, with a turnover of 5million Euro and 1.4 million in pre-tax profit. Having expanded its range from 2 to 20 products, Play On Toys now works with 30 suppliers to acquire the 110 parts required to manufacture its wares. Expansion into Asia, Africa and America is planned over the coming three years, with the accompanying growth and challenges of moving into new markets and expanding the operation, Play On Toys is at a critical junction. Ensuring that internal systems are functioning at highest efficiency and are prepared for growth are essential elements for the continued success of Play On Toys. Currently, records and information for critical areas including sales, financial, production, and customer relations are held in isolated electronic and paper files as well as some small databases. Essential reporting and transaction processing are highly dependent on manual inputs. Critically, sales orders submitted via the website must be manually processed by sales administrators in a process requiring printing orders and entering them into a spreadsheet manually. The current system of record keeping and reporting lacks cohesion and efficiency, and......

Words: 3888 - Pages: 16

Premium Essay

Database Management Systems

...Database Management System Basith Shaik Southern New Hampshire University September 7, 2015 Abstract The intent of this paper is to design and propose a database management system solution to Grandfield College for tracking software installed. I have analyzed the organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal Compliance, Ethical Practices, Security Needs and Security Plan Keywords: Grandfield College, Database Design, Recommendations, Business Rules, Data model, Security Plan Database Management System Grandfield College is in need of Database Management System as law requires that any business, including a school, track its software. It is important to know what software the school owns, in what versions, and what the license agreement for that software is. For this purpose I have developed a Software Tracking database for Grandfield College. Problem Grandfield College is in need of a database for effectively tracking faculty and staff computers, the software installed on those systems, User access to each computer, and requests for new software......

Words: 4672 - Pages: 19

Premium Essay

Database System

...Chapter 1 Databases and Database Users Copyright © 2011 Pearson Education, Inc. Publishing as Pearson Addison-Wesley Chapter 1 Outline         Types of Databases and Database Applications Basic Definitions Typical DBMS Functionality Example of a Database (UNIVERSITY) Main Characteristics of the Database Approach Types of Database Users Advantages of Using the Database Approach When Not to Use Databases Copyright © 2011 Ramez Elmasri and Shamkant Navathe Types of Database Applications  Traditional Applications:   Numeric and Textual Databases in Business Applications More Recent Applications:      Multimedia Databases (images, videos, voice, etc.) Geographic Information Systems (GIS) Data Warehouses Real-time and Active Databases Many other applications  Initial part of book focuses on traditional applications  A number of recent applications are described later in the book (for example, Chapters 26,27,28,29) Copyright © 2011 Ramez Elmasri and Shamkant Navathe Basic Definitions      Database:  A collection of related data. Data:  Known facts that can be recorded and have an implicit meaning. Mini-world:  Some part of the real world about which data is stored in a database. For example, student registration, grades and transcripts at a university. Database Management System (DBMS):  A software package/system to facilitate the creation......

Words: 1892 - Pages: 8

Premium Essay

Database Systems

...Database Systems name 3-12-2012 Web-407 Advanced Web Development instructor's name Introduction Most companies need some type of database. A company may be small or extremely large but they all share one thing in common, if they make any type of product, sell anything, keep contacts, balance the books, pretty much anything a business can any will do, they need some type of database or multiple databases to store and later retrieve the data a typical business generates. Choosing the right database is even more important in the age of the Internet, products and services can be sold around the world now and the data from shopping carts and other payment and shipping needs a database too. This article will go into a bit more detail on some of the types of databases that are available and how to pick the right one for your company. Open Source vs. Proprietary This is the big question on a lot of businesses minds these days. Rather to try and cut costs by integrating an Open Source database or a proprietary one. First off let us go over what open source means. Open source software, in this case a database, is software that generally has a limited license for free using. The software is developed and maintained by developers and coders around the world that continuously work at improving the software but providing security upgrades and bug fixes. Proprietary software on the other hand is generally developed, upgraded and patched by a company that sells or licenses the......

Words: 1313 - Pages: 6

Premium Essay

Database Systems

...Database Systems Adam Fabian DBM / 380 Database Systems Database Systems are emerging as an essential technology in today’s digital society. As human dependence on technology continues to evolve, databases continue to provide the backbone to any customer or data based system and assist organizations in storing vast amounts of information in a reference-able and organized manner. Database systems are specially designed pieces of software that store and organize vast amounts of data in a logical way that users can understand. The size of a database can range anywhere from a few simple records to millions of user accounts with detailed information and data. At my work, databases play an integral part in our company’s success. My current employer, Phoenix Diagnostic Imaging, handles thousands of records related to patient examinations conducted at our facility. The data for each patient is stored in a patient object within the database and referenced using the functionalities provided within the database application. Each one of these objects stores personal information, insurance information, examination data and images, paperwork from each visit, and referring doctor contact information. Employees use this system constantly to access patient records and insert new data into the patient records. Database architecture plays an important role in the success of a database. The three main types of database architecture are the one-tier, two-tier,......

Words: 792 - Pages: 4