Information Systems Analysis and Design - Essay Example

Analysis and Design using Traditional Techniques Data Flow Model 0 Context Diagram for the Booking process In case of booking process activity,the actors to that are customers, staff in the overseas, marketing, finance and administration. Customers collect information on the various holiday plans, their cost, etc., before booking one. Overseas staff collect the needed villas and fix their rates which are then passed on to the clients. Accountant and the administration take care of the back office processing. 2.0 Level 1 DFD - Exploding the booking process - 1. The level 1 DFD indicates the five major processes that form the part of the booking process. The entities are marked with the blue and are labeled A to J. Three database Tables are also pictured in the drawing above. 3.0 Level 2 DFD Exploded Booking Administration In the level 2 diagram, Booking module has been exploded and the processing is shown in more detail. The customers may make contact either through the internet or over the phone. In case of the internet they go through the available data and could possibly send an email asking for data to the marketing who in turn could pass it on to the telephone handling process. Else the customer himself might directly call up and land at the call center to get his queries answered. The marketing people handling the telephone calls are supported by data from the airline company and from the overseas staff by providing them with the villa details. Once the process is through, the marketing makes a provisional booking and passes the information to the accounts. On receipt of the payment from the customer, accounts confirms the booking. LDS Grid Villas Bookings N to 1 Accounts N to N N to N Clients N to N 1 to 1 1 to 1 Villas Bookings Accounts Clients LDS Diagram would, therefore, appear as below: Database Model would appear as follows: Entities and their attributes Table Name : Clients No Attribute Remarks 1 Customer id Primary key 2 Customer name 3 Staff id Foreign key 4 Booking Number Foreign key 5 Villa id Foreign key 6 Date of travel 7 Date of arrival at destination 8 Return journey date 9 Flight no - To Foreign key 10 Flight no - From Foreign key And other attributes Table name: Accounts No Attribute Remarks 1 Account No Primary key 2 Account name 3 Table name: Villas No Attribute Remarks 1 Villa Id Primary key 2 Villa Name 3 Availability date 4 Booking status 5 Table name: Bookings No Attribute Remarks 1 Booking number Primary key 2 Date of booking 3 Invoice Amount 4 Advance received 5 Final payment 6 Select attributes for these entities have been mentioned and not an exhaustive list of attributes given. Foreign keys are more defined in the client list and they are connected to the rest of the entities for complete information. 2.2 To access any client detail, we will accessing the same using any of these numbers: 1. Client id 2. Booking number. Since most of the times we will require to use the client name and id, we will take that as an example to understand accessing of the client list table. From the client id, we can realize the exact booking operation fully. Client id relates to the client table since it is the primary key. The foreign keys there lets you know who handled the client ( staff id ), booking number relates to the bookings table telling you the date and time of the booking, his / her payment status, etc., Similarly, the entire line to other tables like the villas, the flights are all closed and we will be able to pick up all information corresponding to one client for that specific season. Ideally, if the same system spans over years, then we need to have a composite key including year along with the client id as the primary key for the client entity. 3.0 List of Requirements The requirements are listed as business requirements, sub classified as functional and non-functional requirements. Business Requirements Functional Requirements Non Functional Requirements Marketing Brochure Preparation Airline Contracts Pricing of the villas Business Forecasting Direct Mailers Ads in the targeted national newspapers Analysis of bookings Maintain the web site Overseas Operation Short list and negotiate villas Managing the villas Short term direct rentals Finance Financial Accounting Banking of all cash and cheques Salary and expense processing Budgeting and control Reconciliation of accounts Management accounting Membership in regulatory organization Booking Administration Call management Terms of the vacation and travel Provisional booking Confirmed booking Invoice Preparation Receipt of payments - Deposit / Final Dispatch of flight tickets 4.0 Diagrams 4.1 State Diagrams of entities on receipt of Provisional booking receipt. 4.2 CRUD matrix Villa Client Bookings Accounts Telephonic Enquiry R C R Internet Enquiry R Provisional Booking R U CUD CUD Final Booking R U UD UD 5.0 Specifications for 'Provisional Booking' function If the client would like to provisional book or block the booking then Advance amount is requested. An optional or a provisional booking is done. If the deposit amount is received then Confirmed booking is done Invoice for the complete amount is prepared in triplicate and one copy sent To the client. Else If more than ten days since optional booking and the deposit is not received then The optional or provisional booking is cancelled. Read More