Scribd
Upload
30 views2 pages

Queue Management System Design

The project involves developing a queuing system with a database structure containing tables to store office details, client logs, transaction types, and serving information. The requirements include a display, thermal printer, and installation server. The process flow shows client information being encoded, a queue number released, and the queue list/clients displayed. Offices can process papers, transfer clients, and the system records data. The proposed design displays the queue list and clients on a screen, prints queue slips with client name and number, and logs transaction details like date, time, and office.

Uploaded by

Adrimar Aquino
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
30 views2 pages

Queue Management System Design

The project involves developing a queuing system with a database structure containing tables to store office details, client logs, transaction types, and serving information. The requirements include a display, thermal printer, and installation server. The process flow shows client information being encoded, a queue number released, and the queue list/clients displayed. Offices can process papers, transfer clients, and the system records data. The proposed design displays the queue list and clients on a screen, prints queue slips with client name and number, and logs transaction details like date, time, and office.

Uploaded by

Adrimar Aquino
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Project Name: Queuing System

Database Structure
pgsnjn_office
id int 10 P/AI
office varchar 10
description varchar 50
status varchar 1 Y/N

pgsnjn_log
id int 10 P/AI
logdate varchar 12
timein varchar 12
timeoout varchar 12
office varchar 10
quecode int 3
clientname varchar 100
status varchar 1 Y/N

pgsnjn_transaction
id int 10 P/AI
transtype varchar 10
counter int 5

pgsnjn_serving
id int 10 P/AI
quecode int 3
office varchar 10

Requirements :
 Display Window / Monitor / TV preferably 32“ up
 Thermal Printer for issuing que stab
 Installation Server for record log
Process Flow

Information
Encode Client Name
Release Queue No. Display Window
Display Queue List
Display On-que Clients

Offices
Process Papers System
Transfer to other offices. Database

Propose Design Scheme


Information Offices

Client Name New Serving Ok


Client Name
Type
Transaction Type
Queue List
Queue No. Client Name

Service Date
No. Time

Display Window Queue Slip


Serving Date / Time
Date Time
Office Office Office Office Office

1
Office Office Office Office Office
Client Name
1
Queue No. Client Name

You might also like