Software Implementation of Encrypted Database System

PRELIMINARY PAGES

• Title page
• Approval page
• Dedication
• Acknowledgement
• Table of Contents
• Abstract

CHAPTER ONE

INTRODUCTION

• 1.1 Introduction
• 1.2 Background of the Study
• 1.3 Statement of the Problem
• 1.4 Aim and objective of the Study
• 1.5 Scope of the Study
• 1.6 Significant of the Study
• 1.7 Limitations of the study
• 1.8 Definition of Terms

CHAPTER TWO

LITERATURE REVIEW

• 2.1 Introduction
• 2.2 The Concept of Crypto security
• 2.3 Cryptography
• 2.3.1 DES – Data Encryption Standard
• 2.4 PGP – Pretty Good Privacy
• 2.5 Diffe-Hellman-Merkel Key Exchange
• 2.6 RSA- Rivest, Shamir and Adleman
• 2.7 The Impact of Modern Electronics On Crypto-graphical Systems
• 2.8 Application of Cryptology in Private and Commercial Life
• 2.9 Cryptography Keys
• 2.9.1 Symmetric-Key Cryptography
• 2.10 Theoretical Framework
• 2.10.1 Ciphers
• 2.10.1.1 Substitution Ciphers
• 2.10.1.2 Transposition Cipher
• 2.10.2 Public Key Cryptography
• 2.10.3 Public-Key Certification
• 2.10.4 Certification Authority (CA)
• 2.10.5 Message Security
• 2.10.5.1 Message Privacy
• 2.10.5.6 Privacy with Symmetric-Key Cryptography
• 2.10.5.7 Privacy with Public Cryptography
• 2.10.5.8 Message Authentication
• 2.10.5.9 Integrity
• 2.10.5.10 Non-repudiation or Data origin
• 2.10.6 Digital Signature
• 2.10.7 Signing the Digest
• 2.10.8 Key Management
• 2.10.8.1 Symmetric Key Distribution
• 2.10.8.2 Certification Authority (CA)
• 2.10.8.3 Session Keys
• 2.10.8.4 Diffie – Hellman method
• 2.10.8.5 Prerequisites
• 2.10.8.6 Procedure
• 2.10.9 Client-Server and Other Models
• 2.10.10 Client-Server Communication
• 2.10.11 Hosts Identification and Service Ports
• 2.10.12 Sockets and Socket-Based Communication

CHAPTER THREE

SYSTEM ANALYSIS AND DESIGN

• 3.1 Methodology Adopted
• 3.1.1 Problem Identification Using SSADM
• 3.2 Analysis of the Existing System
• 3.2.1 Dataflow of the Existing System
• 3.2.2 Disadvantages of the Existing System
• 3.3 Analysis of the Proposed System
• 3.3.1 Data Flow Diagram of the Proposed System
• 3.3.2 Advantages of the Proposed System
• 3.3.3 Justification of the Proposed System
• 3.4 Functional Requirements
• 3.5 Data Requirements
• 3.6 High Level Model of the Proposed System

CHAPTER FOUR

SYSTEM DESIGN AND IMPLEMENTATION

• 4.1 Objectives of the Design
• 4.2 Cohesion and Decomposition High level Model
• 4.3 Control Center / Overall Dataflow Diagram
• 4.3.1 Proposed System Operation Flowchart
• 4.4 System Specification and Design
• 4.4.1 Input and Output Specification
• 4.4.2 Database Specification and Design
• 4.4.3 Data Dictionary
• 4.5 Choice and Justification of Programming Language
• 4.6 Program Documentation
• 4.7 Implementation Techniques
• 4.8 Programming Module Specification
• 4.8.1 Installation
• 4.9 Computer Hardware Minimum Requirement
• 4.10 Software Requirement
• 4.11 Personnel / User Training

CHAPTER FIVE

SUMMARY, CONCLUSION, AND RECOMMENDATION

• 5.1 Summary
• 5.2 Conclusion
• 5.3 Recommendation

REFERENCES

APPENDIX A - "SOURCE CODE"

APPENDIX B - "OBJECT PROGRAM"

1.1 Introduction

In the past, security was simply a matter of locking the door or storing files in a locked filing cabinet or safe. Today, paper is no longer the only medium of choice for housing information. Files are stored in computer databases as well as file cabinets. Hard drives and floppy disks hold many of our secret information. In the physical world, security is a fairly simple concept. If the locks on your house’s doors and windows are so strong that a thief cannot break in to steal your belongings, the house is secure. For further protection against intruders breaking through the locks, you might have security alarms. Similarly, if someone tries to fraudulently withdraw money from your bank account but the teller asks for identification and does not trust the thief’s story, your money is secure. When you sign a contract with another person, the signatures are the legal driving force that impels both parties to honor their word. In the digital world, security works in a similar way. One concept is privacy, meaning that no one can break into files to read your sensitive data (such as medical records) or steal money (by, for example, obtaining credit card numbers or online brokerage accounts information).

As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitation of the study and Definition of technical terms.

1.2 Background of the Study

Before the modern era, cryptography was concerned solely with message confidentiality (i.e., encryption) − conversion of messages from a comprehensible form into an incomprehensible one, and back again at the other end, rendering it unreadable by interceptors or eavesdroppers without secret knowledge (namely, the key needed for decryption of that message). In recent decades, the field has expanded beyond confidentiality concerns to include techniques for message integrity checking, sender/receiver identity authentication, digital signatures, interactive proofs, and secure computation, amongst others.

Encryption attempts to ensure secrecy in communications, such as those of spies, military leaders, and diplomats, but it have also had religious applications. Steganography (i.e., hiding even the existence of a message so as to keep it confidential) was also first developed in ancient times. An early example, from Herodotus, concealed a message − a tattoo on a slave’s shaved head − under the regrown hair. More modern examples of steganography include the use of invisible ink, microdots, and digital watermarks to conceal information.

1.3 Statement of the Problem

The problem is security. The password method used in almost all commercial operating systems is probably not very strong against a sophisticated or unsophisticated attacker.

The choice of data encryption comes next in the minds of those that want reduction of unauthorized access on confidential files or data. Security provided by the computer operating systems come with a preset super user account and password.

The super user may have a password to control network functionality, another to conduct or access nightly backups, create accounts, and so on. For a cracker, logging on to a system as the super user is possibly the best way to collect data or do damage. If the super user has not changed an operating system’s preprogrammed passwords, the network is vulnerable to attack.

Most crackers know these passwords, and their first attempt to break into a network is simply to try them. If an attacker cannot log on as the super user, the next best thing might be to figure out the user name and password of a regular user.

It is used to be standard practice in most Universities and colleges, and in some commercial companies, to assign every student or employee an account with user name and initial password − the password being the user name. Everyone was instructed to log on and change the password, but often, hackers and crackers logged on before legitimate users had a chance.

1.4 Aim and objective of the Study

The aim of the study is to design and implement an Encrypted Database System. In achieving this aim, the following specific objectives of study were considered to design and develop an application software that will;

1. Understand and improve the computer networking data security through encryption of data.
2. Enable communication between two or more computers on the network.
3. Allow the computers in the network communicate without the need for a central server.
4. Allow the computers connected in the network perform the function of both a server and a client on the network i.e. they are given the administrative right to both send and receive data.
5. Create a network for each computer to easily upload and download files over the peer to peer network, and this can be done without having access to the internet.

1.5 Scope of the Study

The scope of this research is focused on the Design and Implementation of Encrypted Database System.

1.6 Significant of the Study

Data security in these contemporary times is a must. For your secrets to be secure, it may be necessary to add protections not provided by your computer operating systems. The built-in protections may be adequate in some cases. If no one ever tries to break into or steal data from a particular computer, its data will be safe. Or if the intruder has not learned how to get around the simple default mechanisms, they’re sufficient. But many attackers do have the skills and resources to break various security systems. If you decide to do nothing and hope that no skilled cracker targets your information, you may get lucky, and nothing bad will happen.

One of the most important tools for protecting your data from an authorized access is Data Encryption, any of various methods that are used to turn readable files into gibberish. Even if an attacker obtains the contents of the file, it is gibberish. It does not matter whether or not the operating system protections worked.

1.7 Limitations of the Study

During the course of this study, many things militated against its completion, some of which are:

1. Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
2. Research material: availability of research material is a major setback to the scope of the study.
3. Frequent power failure: This made the researcher append more money on fuel to ensure sustainable power.
4. Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).

1.8 Definition of Terms

Based on this research work, the following terms are used, and briefly defined bellow;

Encryption: A process of converting data/information into another form.

Decryption: A process of converting data/information (multimedia) back to its Original form.

Clear-text/plaintext: Original data/information before it is enciphered / scrambled.

Ciphered text/cryptogram: Information (multimedia) that has been converted into other symbols or form.

Account Details - For USSD / POS Transfer

Account Name: Sparklyn Services Account No: 1222599051 Account Type: Current Bank Name: Zenith Bank PLC

Proposal Writing Format under Computer Science

Design and Implementation of Encrypted Database System is a proposal topic for final year research work, which comprises the major and elective project proposal writing sections for Design and Implementation of Encrypted Database System research work.

Major Sections

• Motivation for Embarking on the Project

• Brief Background of Study

• Statement of Problems

• Aim of the Study

• Specific Objectives of the Study

• Significance of the Study (Who benefits from the project and how?)

Elective Sections

• Methodology and Reason for Using It (such as; models, SSADM, or OOADM)

• Tools (programming languages and software used)