Menu

5

0 Comment

5. STRUCTURAL DESIGN

5.1INPUT DESIGN

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

The input to the system was designed So that the required information can be collected
and corrected quickly. The data collected are entered into the system through input screens, when
a data is to be entered the description of the data is displayed at the bottom of the screen.

Input design is given through selection-based links. The input design is the process of
converting an external user oriented description of the input to a system in to a machine-oriented
format. Data processing involves the usage of accurate data. Errors entered by the data entry
operation can be controlled by the input design. The goal of designing input data is to make data
entry an easy operation. An efficient input designing will avoid the frequent occurrence of
errors.
• To provide a cost effective method of input.
• To achieve the highest possible level of accuracy.
• To ensure that the input is acceptable to and understood by the user.
In this system following input screens are designed to get user’s information.
• Authentication
• Patient Details
• Staff details
• Privacy details
• Staff registration
• Patient Registration

Authentication
Authentication screen provide the security to the system. It get username and password
from the users.
Patient Details
Patient details screen is used to get the patient details and it includes the details of patient
id, name, address, contact, email. Admin can enter the details of the patient and admin only have
permission to add, edit and delete permissions.

18

Staff Details
Staff details screen is used to get the staff details and it includes the details of staff id,
name, address, contact, email and department. Admin can enter the details of the staff and admin
only have permission to add, edit and delete permissions.
Privacy Details
Privacy details screen get sensitive information from the admin. In this screen admin can
enter privacy data of the patient. This screen includes the details of the patient id, consultation
date and medical history. These details are encrypted on this screen.
Staff Registration
Staff registration screen allow staff to register on this site. In this screen staff can enter
staff id, it will show staff name and it get the username and password from the staff.
Patient Registration
Patient registration screen allow Patient to register on this site. In this screen patient can
enter patient id, it will show patient name and it get the username and password from the patient.

5.2 OUTPUT DESIGN

The ultimate goal of the development of the system is to produce effective outputs. In
output design, it is determined how the information is to be displayed for immediate need. It is
the most important and direct source of information to the user. Efficient and intelligent output
design improves the system’s relationships with the user and help in decision making.
This system produces following reports.

• Patient Details
• Privacy Details
Patient Details
Patient details screen is used to display the patient details and it includes the details of
patient id, name, address, contact, email. All users can see this report.
Privacy Details
Privacy details screen shows the sensitive information. In this screen admin and user can
view privacy data and their medical history. These details are decrypted and download by the
patient.

19
Field Name Data Type Size Description
Dcode Varchar 5 Doctor Code
Dname Varchar 30 Doctor name
Special Varchar 50 Specialization
Cont Varchar 15 Contact
Email Varchar 30 Email

5.3 DATABASE DESIGN

Database design is the process of producing a detailed data model of a database. This data
model contains all the needed logical and physical design choices and physical storage
parameters needed to generate a design in a data definition language, which can then be used to
create a database. A fully attributed data model contains detailed attributes for each entity. The
term database design can be used to describe many different parts of the design of an
overall database system. Principally, and most correctly, it can be thought of as the logical design
of the base data structures used to store the data. In the relational model these are the tables
and views. In an object database the entities and relationships map directly to object classes and
named relationships. However, the term database design could also be used to apply to the
overall process of designing, not just the base data structures, but also the forms and queries used
as part of the overall database application within the database management system (DBMS).

The process of doing database design generally consists of a number of steps which will be
carried out by the database designer. Usually, the designer must:

• Determine the data to be stored in the database.
• Determine the relationships between the different data elements.
• Superimpose a logical structure upon the data on the basis of these
relationships.

Table Name : Doctor
Primary Key : Dcode

20

Field Name Data Type Size Description
Patid Varchar 5 Patient Id
Pname Varchar 30 Patient name
Dob DateTime 8 Date of Birth
Gender Varchar 7 Gender
Cont Varchar 15 Contact
Addr Varchar 150 Address
Email Varchar 30 Email Id
Field Name Data Type Size Description
StaffId Varchar 5 Staff Id
Sname Varchar 30 Staff name
Desi Varchar 30 Designation
Cont Varchar 15 Contact
Email Varchar 30 Email Id
Field Name Data Type Size Description
Uname Varchar 30 Username
Pwd Varchar 30 Password
Utype Varchar 30 User Type(Staff or patient)
Uid Varchar 5 User Id

Table Name : Patient
Primary Key : Patid

Table Name : Staff
Primary Key : staffed

Table Name : regtable

21

Field Name Data Type Size Description
Patid Varchar 5 Patient Id
Condate DateTime 8 Consulting date
Dcode Varchar 5 Doctor code
Condet Varchar 300 Consultation details

Table Name : metadata
Reference Key : Patid

5.4 Entity Relationship Diagram

22

5.5 Data Flow Diagram

Admin

Stores

Doctor

Stores

Register

Product
Mainte
nance

Patient

User
Registration

View

Meta Data

23

6. RESULTS AND DISCUSSION

A triple DES algorithm is followed in the proposed system. Since a three level security
mechanism is used to encrypt the patient diagnostics file. The encrypted file is uploaded
successfully to the cloud. From the cloud, patient receiver can download the data which is the
form of cipher text. Each patient then decrypts the cipher text to the original data.
Any number of patient, doctor and staff can be registered first. Then all the register details
are stored in the cloud. Once the user registered, each time they can access the details based on
id. Only the registered users can access the file, otherwise they are not allowed to access site. K-
anonymity algorithm is used to protect the privacy information.

Fig 6.1 Upload Privacy File

24

Fig 6.2 Download Privacy File

25

7. CONCLUSION AND FUTURE WORK

Privacy is very important to protect the sensitive data from the attacker. To provide
privacy to the data anonymization methods can be used. In this system is done by using K-
anonymity method and Triple DES algorithm using .net. These techniques are applied in the
hospital domain and its works efficiently and secure patient data are shared with in the hospital
environment. In Future the system will add advance security techniques to used patient details.

26

x

Hi!
I'm Kim!

Would you like to get a custom essay? How about receiving a customized one?

Check it out