1 / 0

Travel Reservation System Design on Microsoft .NET Platform

This document presents a comprehensive overview of developing a Travel Reservation System using the Microsoft .NET platform. It outlines fundamental targets, summarizes the design approach, and discusses database design strategies. The comparison between Process Oriented and Object Oriented Database Systems is highlighted, along with an analysis of LINQ to SQL versus ADO.NET Entity Framework. Aimed at enhancing user experience, the system aims to streamline travel bookings through intuitive design and effective database integration.

leda
Télécharger la présentation

Travel Reservation System Design on Microsoft .NET Platform

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Travel Reservation System ----an Attempt on Microsoft .NET Platform Yuan Zhong@1011 PB10011004 zgkdzy@mail.ustc.edu.cn
  2. Outline Fundamental Targets Summary of Design Database Design Process Oriented VS. Object Oriented Database System LINQ to SQL VS. ADO.NET Entity Framework View of Travel System Relation Table User Interface User Guide and Presentation User Guide Presentation
  3. Outline Fundamental Targets Summary of Design Database Design Process Oriented VS. Object Oriented Database System LINQ to SQL VS. ADO.NET Entity Framework View of Travel System Relation Table User Interface User Guide and Presentation User Guide Presentation
  4. Fundamental Targets User Friendly High Portability Good scalability Database Interactivity
  5. Outline Fundamental Targets Summary of Design Database Design Process Oriented or Object Oriented Database System LINQ to SQL VS. ADO.NET Entity Framework View of Travel System Relation Table User Interface User Guide and Presentation User Guide Presentation
  6. Summary of Design Based on Microsoft .NET 4.0 Platform IDE: Microsoft Visual Studio 2012 Database System: Microsoft SQL Server 2012 User Interface: WPF(Windows Presentation Foundation) Programming Language: C Sharp Database Type: OODBS and ORM Design Linking to Database: LINQ to SQL
  7. Outline Fundamental Targets Summary of Design Database Design Process Oriented or Object Oriented Database System LINQ to SQL VS. ADO.NET Entity Framework View of Travel System Relation Table User Interface User Guide and Presentation User Guide Presentation
  8. PODBS VS. OODBS Potential Meritsof OODBS: Good inheritance, encapsulation and polymorphism Less code for object oriented applications Provide Object/Relation Mapping(ORM) mechanism Easier to handle Potential Drawbacks of OODBS: Lower efficiency with simple data and relationships Late binding may slow access speed Less stable standards for OODBS
  9. LINQ to SQL VS. ADO.NET Entity Framework Some Significant Differences 4/32
  10. View of Travel System Relation Table
  11. Outline Fundamental Targets Summary of Design Database Design Process Oriented or Object Oriented Database System LINQ to SQL VS. ADO.NET Entity Framework View of Travel System Relation Table User Interface User Guide and Presentation User Guide Presentation 2/32
  12. User Interface Microsoft Windows WPF GUI application: An easy way to bound data source with UI elements High development efficiency than MFC and WinForm Windows 8 Metro Style Excellent Color Coordination
  13. Outline Fundamental Targets Summary of Design Database Design Process Oriented or Object Oriented Database System LINQ to SQL VS. ADO.NET Entity Framework User Interface User Guide and Presentation User Guide Presentation
  14. User Guide “Travel Plan Designer” for users while “Database Management Studio” for administrator In the Travel Plan Designer Window: “Hotels” “Cars” “Flights” for showing relation tables Deletion should select a tuple and type “Delete” button “Reservation” button for making reservations In the Database Management Studio Window: Login first “Hotels” “Cars” “Flights” “Custs” for showing relation tables Implement insertion or update directly on tables Deletion should select a tuple and type “Delete” button.
  15. User Guide In the Travel Plan Designer Reservations Window “Hotels” “Cars” “Flights” for showing available relation tables Combobox for selecting location, travel source and travel destination After operations in Combobox, typing “Query” button for query “Confirm” button for acknowledging reservations “Check” button for the Integrity of Customers’ Travel Route Equals to whether the graph is connected Euler Circuit Equals to that the degrees of each vertex are even
  16. Presentation MainWindow
  17. Presentation Database Management Studio Login:
  18. Presentation Database Management Working Interface:
  19. Presentation Travel Plan Designer Login and Register
  20. Presentation Travel Plan Designer Working Interface
  21. Presentation Travel Plan Designer Reservation Interface
  22. Thank You! Yuan Zhong@1011 PB10011004
More Related