{"id":9978,"date":"2016-05-16T16:37:08","date_gmt":"2016-05-16T22:37:08","guid":{"rendered":"http:\/\/sanuja.com\/blog\/?p=9978"},"modified":"2016-05-16T16:37:08","modified_gmt":"2016-05-16T22:37:08","slug":"database-management-system-for-online-ticket-sales","status":"publish","type":"post","link":"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales","title":{"rendered":"Database Management System for Online Ticket Sales"},"content":{"rendered":"<p>Database Management System (DBMS) of online ticket sale for the <a href=\"http:\/\/www.ucalgary.ca\/news\/april2007\/Kusa-Paba\" target=\"_blank\" rel=\"noopener\">stage play \u201cKusa-Paba\u201d<\/a> at the <a href=\"https:\/\/scpa.ucalgary.ca\/theatre-services\/facilities\" target=\"_blank\" rel=\"noopener\">University of Calgary Theater<\/a>.<\/p>\n<h3>Abstract and Project Description<\/h3>\n<p>The University of Calgary Theater has 500 available seats. This particular DBMS is built to allow users to order and purchase tickets online. Tickets sold by agents can also be entered to the system using the agents\u2019 interface. Only a designated set of seats are available for sale. Some are as for reserved guests and others are designated as House Seats hence they are not available for sale. The designated seats for sale are categorized for different price levels; $50.00, $30.00 and $20.00 (Figure 1). The price levels are further broken down for adults and children.<\/p>\n<p><!--more--><\/p>\n<p>This project has following features:<\/p>\n<ul>\n<li> Children \u2013 Age 3 and under will be free of charge and no seats will be assigned.<\/li>\n<li> Children \u2013 Age 4 to 12 (inclusive) can purchase tickets for half of the applicable ticket price.<\/li>\n<\/ul>\n<p>Payments should be made to the ticket agents who will confirm the seats and issue requested tickets. There is no online credit card or money transfer system implemented in this particular system. However, the system can be modified to include third party payment processing companies such as PayPal. It is also possible to add direct payment system with site based SSL certificates, but this will require much greater degree of modification to the current DBMS.<\/p>\n<p>There are two (2) main databases<br \/>\n1. Tickets administration, agent details and login details<br \/>\n2. Seat details, seat price and ticket ordering details<\/p>\n<p>There are two (2) types of reports<br \/>\na. Reports for users<br \/>\nb. Reports for ticket masters and ticketing agents<\/p>\n<figure id=\"attachment_9979\" aria-describedby=\"caption-attachment-9979\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating.jpg\"><img decoding=\"async\" data-attachment-id=\"9979\" data-permalink=\"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales\/db_ticket_seating\" data-orig-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating.jpg\" data-orig-size=\"1125,712\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Seating Arrangement\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;University of Calgary Theater seating arrangement with designated sections.&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating-300x190.jpg\" data-large-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating-1024x648.jpg\" src=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating-1024x648.jpg\" alt=\"University of Calgary Theater seating arrangement with designated sections.\" width=\"1024\" height=\"648\" class=\"size-large wp-image-9979\" srcset=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating-1024x648.jpg 1024w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating-300x190.jpg 300w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating-768x486.jpg 768w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating-900x570.jpg 900w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating.jpg 1125w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption id=\"caption-attachment-9979\" class=\"wp-caption-text\">Figure 1: University of Calgary Theater seating arrangement with designated sections.  Click for enlarge image.<\/figcaption><\/figure>\n<h3>Introduction<\/h3>\n<p>The DBMS structure includes five (5) software components for;<br \/>\n1. Creating and changing the logical structure of a database<br \/>\n2. Querying and making changes to the information<br \/>\n3. Menus, data entry screens, reports and application software<br \/>\n4. Permission on who can use and see what information; backup and recovery<br \/>\n5. Queries to see the effect of structural changes<\/p>\n<figure id=\"attachment_9982\" aria-describedby=\"caption-attachment-9982\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" data-attachment-id=\"9982\" data-permalink=\"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales\/db_dbms_strusture\" data-orig-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_strusture.jpg\" data-orig-size=\"600,444\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"db_dbms_strusture\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;Database Management System (DBMS) Diagram&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_strusture-300x222.jpg\" data-large-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_strusture.jpg\" src=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_strusture.jpg\" alt=\"Database Management System (DBMS) Diagram\" width=\"600\" height=\"444\" class=\"size-full wp-image-9982\" srcset=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_strusture.jpg 600w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_strusture-300x222.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-9982\" class=\"wp-caption-text\">Database Management System (DBMS) Diagram<\/figcaption><\/figure>\n<p>DBMS engine has data definition subsystem, data manipulation subsystem, data administration subsystem, and application generation subsystem.<\/p>\n<h3>Procedure<\/h3>\n<p>Data structure includes the following;<br \/>\nDatabase name: Ticket_order<br \/>\nDatabase type: flat<br \/>\nDatabase Tables:<br \/>\n &nbsp;  &nbsp; Tickets<br \/>\n &nbsp;  &nbsp; User_description<br \/>\n &nbsp;  &nbsp; Accounting<\/p>\n<p>For this particular report we will only discuss the Ticket_order: Tickets parameter.<\/p>\n<p>Table name: Ticket_order=> Tickets<br \/>\n<figure id=\"attachment_9985\" aria-describedby=\"caption-attachment-9985\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" data-attachment-id=\"9985\" data-permalink=\"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales\/db_dbms_ticket_order_tb\" data-orig-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_ticket_order_tb.jpg\" data-orig-size=\"600,541\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"db_dbms_ticket_order_tb\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;Ticket_order=&gt; Tickets table with descriptions.&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_ticket_order_tb-300x271.jpg\" data-large-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_ticket_order_tb.jpg\" src=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_ticket_order_tb.jpg\" alt=\"Ticket_order=&gt; Tickets table with descriptions.\" width=\"600\" height=\"541\" class=\"size-full wp-image-9985\" srcset=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_ticket_order_tb.jpg 600w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_ticket_order_tb-300x271.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-9985\" class=\"wp-caption-text\">Ticket_order=> Tickets table with descriptions.<\/figcaption><\/figure><\/p>\n<h3>Description of the DBMS<\/h3>\n<p>Data definitions are preconfigured and parameters are assigned though the server SQL configuration. In this particular project, other variables and other options should be assigned before the ticket sales page is open. Once the ticket sales page is opened, the DBMS will carry 500 data records with each record relevant to each seat.<\/p>\n<p>DBMS engine itself generates confirmation numbers respect to each ordered ticket for each user. DBMS generates another separate record to the ticket agents and to the ticket masters.<\/p>\n<p>Table name: Ticket_order=>Tickets<br \/>\n<figure id=\"attachment_9986\" aria-describedby=\"caption-attachment-9986\" style=\"width: 338px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" data-attachment-id=\"9986\" data-permalink=\"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales\/db_dbms_tk_order_sample\" data-orig-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_tk_order_sample.png\" data-orig-size=\"338,279\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"db_dbms_tk_order_sample\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;Ticket_order table setup.&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_tk_order_sample-300x248.png\" data-large-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_tk_order_sample.png\" src=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_tk_order_sample.png\" alt=\"Ticket_order table setup.\" width=\"338\" height=\"279\" class=\"size-full wp-image-9986\" srcset=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_tk_order_sample.png 338w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_tk_order_sample-300x248.png 300w\" sizes=\"(max-width: 338px) 100vw, 338px\" \/><figcaption id=\"caption-attachment-9986\" class=\"wp-caption-text\">Ticket_order table setup.<\/figcaption><\/figure><\/p>\n<p>When a ticket is reserved, the following recoding process is carried out using the database structure shown below. There are twenty (20) fields in the data table; Ticket_order=>Tickets. When the ticket is being generated, it will update only seven (7) fields.<\/p>\n<p>rec_nmb_D<\/p>\n<table border=\"1\" width=\"100%\">\n<tr>\n<td bgcolor=\"#ffcc66\"> 1 <\/td>\n<td> A <\/td>\n<td> A <\/td>\n<td> 1 <\/td>\n<td> 50 <\/td>\n<td> 25 <\/td>\n<td> 1 <\/td>\n<\/tr>\n<\/table>\n<p>The record number is between 1 and 500 with each seat is assigned their own unique number.<\/p>\n<p>TICKET_SECTION<\/p>\n<table border=\"1\" width=\"100%\">\n<tr>\n<td> 1 <\/td>\n<td bgcolor=\"#ffcc66\"> A <\/td>\n<td> A <\/td>\n<td> 1 <\/td>\n<td> 50 <\/td>\n<td> 25 <\/td>\n<td> 1 <\/td>\n<\/tr>\n<\/table>\n<p>The main section of the theater between A to F (Figure 1).<\/p>\n<p>TICKET_ROW<\/p>\n<table border=\"1\" width=\"100%\">\n<tr>\n<td> 1 <\/td>\n<td> A <\/td>\n<td bgcolor=\"#ffcc66\"> A <\/td>\n<td> 1 <\/td>\n<td> 50 <\/td>\n<td> 25 <\/td>\n<td> 1 <\/td>\n<\/tr>\n<\/table>\n<p>The row of the relevant seat between A to L based on the theater seating plan (Figure 1).<\/p>\n<p>TICKET_SEAT<\/p>\n<table border=\"1\" width=\"100%\">\n<tr>\n<td> 1 <\/td>\n<td> A <\/td>\n<td> A <\/td>\n<td bgcolor=\"#ffcc66\"> 1 <\/td>\n<td> 50 <\/td>\n<td> 25 <\/td>\n<td> 1 <\/td>\n<\/tr>\n<\/table>\n<p>The sea number based on the theater seating plan (Figure 1).<\/p>\n<p>TICKET_PRICE<\/p>\n<table border=\"1\" width=\"100%\">\n<tr>\n<td> 1 <\/td>\n<td> A <\/td>\n<td> A <\/td>\n<td> 1 <\/td>\n<td bgcolor=\"#ffcc66\"> 50 <\/td>\n<td> 25 <\/td>\n<td> 1 <\/td>\n<\/tr>\n<\/table>\n<p>The price of the ticket for an adult.<\/p>\n<p>TICKET_CHILD_PRICE<\/p>\n<table border=\"1\" width=\"100%\">\n<tr>\n<td> 1 <\/td>\n<td> A <\/td>\n<td> A <\/td>\n<td> 1 <\/td>\n<td> 50 <\/td>\n<td bgcolor=\"#ffcc66\"> 25 <\/td>\n<td> 1 <\/td>\n<\/tr>\n<\/table>\n<p>The price of the ticket for a child.<\/p>\n<p>TICKET_CANORDER<\/p>\n<table border=\"1\" width=\"100%\">\n<tr>\n<td> 1 <\/td>\n<td> A <\/td>\n<td> A <\/td>\n<td> 1 <\/td>\n<td> 50 <\/td>\n<td> 25 <\/td>\n<td bgcolor=\"#ffcc66\"> 1 <\/td>\n<\/tr>\n<\/table>\n<p>Order restriction; value of 1 denotes a lock on the seat. This restriction allows guest\/special guest seats to be reserved. In this particular project, Section B and E seats 1 to 5 are reserved.<\/p>\n<h3>Data Manipulation<\/h3>\n<p>To make modifications and deletion of data, there are three (3) types of data manipulation avenues.<br \/>\na. By user<br \/>\nb. By ticket agent<br \/>\nc. By ticket master<\/p>\n<p><u>By user<\/u><\/p>\n<p>User can order tickets (seats) online though the web interfaces. The application software finds the record relevant to the selected seats and updates the database. To order tickets;<br \/>\n1. User should check the seating arrangement diagram (Figure 1)<br \/>\n2. Select the preferred section (A, B, C, D, E or F)<br \/>\n3. Check the available seats and ticket types (Figure bellow)<br \/>\n<figure id=\"attachment_9988\" aria-describedby=\"caption-attachment-9988\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" data-attachment-id=\"9988\" data-permalink=\"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales\/db_book_seat\" data-orig-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_book_seat.jpg\" data-orig-size=\"600,682\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"db_book_seat\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;Available tickets\/seats web display interface.&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_book_seat-264x300.jpg\" data-large-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_book_seat.jpg\" src=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_book_seat.jpg\" alt=\"Available tickets\/seats web display interface.\" width=\"600\" height=\"682\" class=\"size-full wp-image-9988\" srcset=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_book_seat.jpg 600w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_book_seat-264x300.jpg 264w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_book_seat-595x676.jpg 595w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-9988\" class=\"wp-caption-text\">Available tickets\/seats web display interface.<\/figcaption><\/figure><br \/>\n4. Input personal information such as Email, City, etc. and select payment option.<\/p>\n<p>After a ticket (seat) has been ordered, the Ticket_order=>Tickets table will be updated as;<br \/>\n13 AC1 20 10 11 Sanuja Senanayake (491) 111-1111 Calgary 0007 Sam 0703041220pm Sena | 7 | 8 | 9 | 10 | 11 | 13 | 14 | 15 | 16 |17 | 19 | 20 | 21 | 22 | 23<\/p>\n<p>Where, the | 7 | 8 | 9 | 10 | 11 | 13 | 14 | 15 | 16 |17 | 19 | 20 | 21 | 22 | 23 indicates one of the tickets of a 15 ticket set, which the user has ordered, and displays all associated ticket record numbers. This information is displayed under ORDER_COMMENTS<\/p>\n<p><u>By agent<\/u><\/p>\n<p>An agent updates the database records when a ticket has been sold and payment is made. If there are any issues, the agent can update the relevant ticket by adding comments.<\/p>\n<p>TO BE UPDATED&#8230;EXAMPLE ORDER PROCESS IMAGE<\/p>\n<h3>Ordering Tickets Example<\/h3>\n<p>The following user (person) has ordered three (3) tickets as a set. Once the order is placed, the database will be updated as follows. If an agent sold the ordered ticket, then the TICKET_ISORDERED value will be set to 2.<\/p>\n<figure id=\"attachment_9989\" aria-describedby=\"caption-attachment-9989\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" data-attachment-id=\"9989\" data-permalink=\"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales\/db_dbms_order_ex2\" data-orig-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_order_ex2.jpg\" data-orig-size=\"600,206\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"db_dbms_order_ex2\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;Example of a person who placed a ticket order for 3 seats.&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_order_ex2-300x103.jpg\" data-large-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_order_ex2.jpg\" src=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_order_ex2.jpg\" alt=\"Example of a person who placed a ticket order for 3 seats.\" width=\"600\" height=\"206\" class=\"size-full wp-image-9989\" srcset=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_order_ex2.jpg 600w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_order_ex2-300x103.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-9989\" class=\"wp-caption-text\">Example of a person who placed a ticket order for 3 seats.<\/figcaption><\/figure>\n<h3>Application Generation Subsystem<\/h3>\n<p>The application generation subsystem consists of menu, data entry screen, reports and the application software.<\/p>\n<p>The application software has the following characteristics;<\/p>\n<p>&#8211; Programing language: TCP\/IP, html, php (ver 5.1)<br \/>\n&#8211; Database: MySQL and flat (txt)<br \/>\n&#8211; OS: Linux Enterprise<\/p>\n<h3>Flow Charts of the DBMS<\/h3>\n<p>TO BE UPDATED&#8230;. ADD THREE FLOW CHARTS<\/p>\n<h3>Menus<\/h3>\n<p>a. Agents main menu<br \/>\n<figure id=\"attachment_9990\" aria-describedby=\"caption-attachment-9990\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" data-attachment-id=\"9990\" data-permalink=\"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales\/db_agnet_menu\" data-orig-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agnet_menu.jpg\" data-orig-size=\"600,454\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"db_agnet_menu\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;Menu for ticket agents.&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agnet_menu-300x227.jpg\" data-large-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agnet_menu.jpg\" src=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agnet_menu.jpg\" alt=\"Menu for ticket agents.\" width=\"600\" height=\"454\" class=\"size-full wp-image-9990\" srcset=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agnet_menu.jpg 600w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agnet_menu-300x227.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-9990\" class=\"wp-caption-text\">Menu for ticket agents.<\/figcaption><\/figure><br \/>\nb. Agents ticket confirm<br \/>\n<figure id=\"attachment_9991\" aria-describedby=\"caption-attachment-9991\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" data-attachment-id=\"9991\" data-permalink=\"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales\/db_agne_conf_menu\" data-orig-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agne_conf_menu.jpg\" data-orig-size=\"600,355\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"db_agne_conf_menu\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;Ticket agents utilities menu with ticket confirmation link.&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agne_conf_menu-300x178.jpg\" data-large-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agne_conf_menu.jpg\" src=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agne_conf_menu.jpg\" alt=\"Ticket agents utilities menu with ticket confirmation link.\" width=\"600\" height=\"355\" class=\"size-full wp-image-9991\" srcset=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agne_conf_menu.jpg 600w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_agne_conf_menu-300x178.jpg 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-9991\" class=\"wp-caption-text\">Ticket agents utilities menu with ticket confirmation link.<\/figcaption><\/figure><\/p>\n<h3>Data Administration<\/h3>\n<p>Backup and disaster recovery (DRS) has two (2) main types.<\/p>\n<p>1. System Backup<br \/>\nThe main system of the server includes OS and application scripts. Backup will be done only once since they are static. Backup will be taken immediately after an OS or script update.<\/p>\n<p>2. Dynamic Data Backup<br \/>\nDynamic data such as database and frequently modified data will be backed up under 3 categories.<br \/>\n &nbsp; a. Online: if a ticket has been ordered, then a backup copy (encrypt version) is sent to the ticket master with all user details including encrypted credit card information (if site based online payment is implemented). In an event of a database corruption or non-recoverable failure, ticket master can retrieve the data using this email.<br \/>\n &nbsp; b. Daily: server administrator with an admin account will manually backup the database.<br \/>\n &nbsp; c. Remote backup weekly: weekly backup can be setup as an automated online based backup through a script or by manually. The information will be kept at a remote location and this backup will be used to restore database in an event of physical damage to the server such as fire, flood, etc.<\/p>\n<figure id=\"attachment_9992\" aria-describedby=\"caption-attachment-9992\" style=\"width: 1024px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_dyn_backup.jpg\"><img decoding=\"async\" data-attachment-id=\"9992\" data-permalink=\"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales\/db_dbms_dyn_backup\" data-orig-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_dyn_backup.jpg\" data-orig-size=\"1500,474\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"db_dbms_dyn_backup\" data-image-description=\"\" data-image-caption=\"&lt;p&gt;Dynamic Data Backup from server.&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_dyn_backup-300x95.jpg\" data-large-file=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_dyn_backup-1024x324.jpg\" src=\"http:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_dyn_backup-1024x324.jpg\" alt=\"Dynamic Data Backup from server.\" width=\"1024\" height=\"324\" class=\"size-large wp-image-9992\" srcset=\"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_dyn_backup-1024x324.jpg 1024w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_dyn_backup-300x95.jpg 300w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_dyn_backup-768x243.jpg 768w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_dyn_backup-900x284.jpg 900w, https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_dbms_dyn_backup.jpg 1500w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption id=\"caption-attachment-9992\" class=\"wp-caption-text\">Dynamic Data Backup from server. Click for enlarge image.<\/figcaption><\/figure>\n<h3>Conclusion<\/h3>\n<p>This DBMS is not capable of recording cancelation of tickets individually by a user. The agent or the ticket master can put a note to allow other to resell the ticket. Cancelled tickets can be sold personally via other methods of communications such as by email or by phone between interested parties.<\/p>\n<p>This is for a non-profit organization and therefore no SSL \u201chigh secure\u201d system for online transaction payment is implemented. Cash or checks were manually collected by agents in advance or at the gate and cross referenced to the DBMS confirmation number.<\/p>\n<p>These drawbacks can be overcome either by using third party support such as PayPal or by improving the current DBMS itself.<\/p>\n<h3>Acknowledgement<\/h3>\n<p>The primary server developer involved in this project would not like to have his name published. The project was conducted between March and April of 2007 at the request of the client, the Sri Lankan Buddhist Society, Calgary (NGO).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Management System (DBMS) of online ticket sale for the stage play \u201cKusa-Paba\u201d at the University of Calgary Theater. Abstract and Project Description The University of Calgary Theater has 500 available seats. This particular DBMS is built to allow users to order and purchase tickets online. Tickets sold by agents can also be entered to &hellip; <a href=\"https:\/\/sanuja.com\/blog\/database-management-system-for-online-ticket-sales\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Database Management System for Online Ticket Sales<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":9979,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,36],"tags":[24,7,30],"class_list":["post-9978","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computer-science","category-projects","tag-php","tag-server","tag-sql"],"jetpack_featured_media_url":"https:\/\/sanuja.com\/blog\/wp-content\/uploads\/2016\/05\/db_ticket_seating.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/sanuja.com\/blog\/wp-json\/wp\/v2\/posts\/9978","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sanuja.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sanuja.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sanuja.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sanuja.com\/blog\/wp-json\/wp\/v2\/comments?post=9978"}],"version-history":[{"count":0,"href":"https:\/\/sanuja.com\/blog\/wp-json\/wp\/v2\/posts\/9978\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sanuja.com\/blog\/wp-json\/wp\/v2\/media\/9979"}],"wp:attachment":[{"href":"https:\/\/sanuja.com\/blog\/wp-json\/wp\/v2\/media?parent=9978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sanuja.com\/blog\/wp-json\/wp\/v2\/categories?post=9978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sanuja.com\/blog\/wp-json\/wp\/v2\/tags?post=9978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}