Data Dictionary for Proposed System free essay sample

Data dictionary for proposed system Processes 1. Process: Accommodation and services Name| Accommodation and services| Description| Provide customer details and get accommodation and other services to the customer. System will provide confirmation details regarding reservations and tour organization. Provide dying and other events handle details to the customer. Input Data Flow| Customer and reservation details, Booking of dining/ conference or event details, Check in details, Check out details, Business centre receipt, Tour information, Reservation status, Agent registration details, Customer and reservation information| Output Data Flow| Availability and rate, Allocated room details, Business centre usage details, Customer details, Event booking details, Reservation and booking details, Confirmation of agent registration, Advance payment receipt for booking| Process| BeginRegister customerMake reservation or bookingConfirm reservation and bookingSend availability detailsRequest a t ourSend tour details to tour organizerSend a confirmation detailsEnd| 2. Process: Procumbent Name| Procumbent| Description| Make a request from suppliers about goods and get confirmation. Then send confirmation details to the management and do the payment for goods. | Input Data Flow| Quotation details, Delivery and payment receipt, Goods in stock information| Output Data Flow| Request goods details, Order confirmation and advance payment details, Payment details, Delivered goods details| Process| Check goods in storesRequest goods from suppliersGet quotation detailsOrder goodsDo the paymentsSend delivered goods details to the Goods Details fileEnd| 3. Process: Tour management Name| Tour management| Description| Get information from customers and send those details to the tour organization. Then provide confirmation detail to the customer and do the payment to the your organization| Input Data Flow| Tour information, Tour guide registration details, Acceptance details of tour, | Output Data Flow| Allocated agents details, Confirmation of registration, Guests tour information, Tour details, Tour guide information| Process| BeginRequest a tour Send tour details to the tour organizationSent the confirmation details Do the tour paymentsEnd| 4. Process: Payments Name| Payments| Description| Customers do the all payments regarding their services from the hotel and tour organization. Input Data Flow| Payment method details, Advance payment details,| Output Data Flow| Payment details, Payment receipt, Payment Information, Advance payment receipt| Process| BeginGiven payment methodDo the paymentProvide receipt detailsEnd| 5. Process: Employee management Name| Employee management| Descrip tion| Enter all employees registration details and give confirmation detail to the employee. Provide work schedule information, Payroll Details to the employee. | Input Data Flow| Employee details| Output Data Flow| Employee registration confirmation, Payroll Details, Work schedule information, Employee information| Process| BeginRegister employeeAssign work taskEnd| 6. Process: Report generate Name| Report generate| Description| Generates reports regarding customers, employees, payments, goods status, tour handling and etc. And provide those reports to the managers. | Input Data Flow| Accommodation and services details, Employee information| Output Data Flow| Status of goods, Generated reports| Process| BeginGenerated reportProvide them to managersEnd| Date stores 1. Customer file Name| Customer file| Description| Send customer registration details to the file| Input Data Flow| Customer details| Output Data Flow| | Data Structure | Customer_ID+c_name+c_address+c_contactNo+c_NIC+reg_date+guide_ID(FK)| 2. Employee file Name| Employee file| Description| Send Employees personal details, salary details, and assign task details. Input Data Flow| Employee details| Output Data Flow| Employee information, Employee registration confirmation, Payroll Details, Work schedule information| Data Structure | emp_ID+e_name+e_address+e_NIC+e_contact| 3. Goods details Name| Goods details| Description| Send request regarding goods. Get confirmation details and make the payments. | Input Data Flow| Delivered goods details| Output Data Flow| Goods in stock information| Data Structure | | 4. Agents file Name| Agents file| Description| Send every agent details to the file. | Input Data Flow| Agent details| Output Data Flow| -| Data Structure | a_ID+a_name+a_address+a_contact| 5. Reservations file Name| Reservations file| Description| Enter reservation details into the file| Input Data Flow| Reservation and booking details| Output Data Flow| Reservation status| Data Structure | res_No+ customer_ID(FK)+ DateAndTime+ Emp_No(FK)+ DateOfArrivel+ arrivelFor| 6. Event booking file Name| Event booking file| Description| Enter details regarding bookings all events| Input Data Flow| Event booking details| Output Data Flow| | Data Structure | booking_ID+ customer_ID(FK)+ Agent_ID(FK)+ dateAndTime+ Event+ NoOfPacks| 7. Tour guide file Name| Tour guide file| Description| Stored tour guides information| Input Data Flow| Tour guide information| Output Data Flow| -| Data Structure | guide_ID+ guide_name+ guide_address+ guide_NIC+ company_name| 8. Tours file Name| Tours file| Description| Insert customers’ tour details| Input Data Flow| Tour details| Output Data Flow| -| Data Structure | Tour_ID+ Tour_guide(FK)+ departureDate+ duration+ destination| Data flows Name| Customer and reservation details| Description| Send customer registration details and reservation details| Origin/Source| Customer, Reservations file| Destination/Sink| Accommodation and services | Name| Booking of dining, conference or event details| Description| Booking dining, conference and other events | Origin/Source| customer| Destination/Sink| Accommodation and services | Name| Reservation and booking details| Description| Stored reservation details in the reservation file| Origin/Source| Accommodation and services | Destination/Sink| Reservations file| Name| Reservation status| Description| Send reservation status | Origin/Source| Reservations file| Destination/Sink| Accommodation and services | Name| Event booking details| Description| Send event booking details to the file| Origin/Source| Accommodation and services | Destination/Sink| Event booking file| Name| Tour information| Description| Request send regarding a tour arrengment| Origin/Source| customer| Destination/Sink| Accommodation and services | Name| Guests tour information| Description| Send tour details to the tour organizer| Origin/Source| Tour management| Destination/Sink| Tour Guide| Name| Tour details| Description| Stored tour details into file| Origin/Source| Tour management| Destination/Sink| Tours file| Name| Request goods details| Description| Send a request to suppliers regarding goods| Origin/Source| Procumbent | Destination/Sink| supplier| Name| Goods in stock information| Description| Send details about the goods in the stores| Origin/Source| Goods details| Destination/Sink| Procumbent | Name| Agent details| Description| Send agents detail to the agent file| Origin/Source| Agent| Destination/Sink| Agents file| Name| Confirmation of agent registration| Description| Send confirmation details to the agent| Origin/Source| Accommodation and services | Destination/Sink| Agent| Name| Generated reports| Description| Send reports details to the customer| Origin/Source| Report generate| Destination/Sink| Manager| Name| Employee details| Description| Send employee personal details to the employee file| Origin/Source| Employee| Destination/Sink| Employee file| Name| Employee registration confirmation| Description| Send registration confirm details(EmployeeID)| Origin/Source| Employee management| Destination/Sink| Employee| Name| Payroll Details| Description| Send the payment details to the employee| Origin/Source| Employee management| Destination/Sink| Employee| Name| Work schedule information| Description| Send the assign task details to the employee| Origin/Source| Employee management| Destination/Sink| Employee| Entities Name| customer| Description| Give customer personal details and make reservation| Input Data Flow| Allocated agents details, Business centre usage details, Allocated room details, Availability and rate, Advance payment receipt, Payment Information, Payment receipt| Output Data Flow| Tour information, Check in details, Booking of dining, conference or event details, Customer and reservation details, Advance payment details, Payment method details| Name| Tour Guide| Description| Give confirmation details to the tour organization and send tour requests| Input Data Flow| Confirmation of registration, Guests tour information| Output Data Flow| Tour guide registration details, Acceptance details of tour | Name| supplier| Description| Send request of goods and get quotation details and send the payment details| Input Data Flow| Request goods details, Order confirmation and advance payment details, Payment details| Output Data Flow| Quotation details, Delivery and payment receipt| Name| Agent| Description| Send the agent details and get the confirmation details. Agents send the customer details and reservation details. Then get the reservation confirmation and send the payment details. Input Data Flow| Confirmation of agent registration, Availability details, Advance payment receipt for booking, Advance payment receipt| Output Data Flow| Agent details, Customer and reservation information, Agent registration details| Name| Manager| Description| Send g enerated reports details to the managers| Input Data Flow| Generated reports| Output Data Flow| | Name| Employee| Description| Send the employee details to the employee file. Send the registration confirmation details, Payroll Details, Work schedule information to the customers| Input Data Flow| Employee registration confirmation, Payroll Details, Work schedule information| Output Data Flow| Employee details|