Design and implementation of database management system case of an abiolian solution limited address book

Project Abstract

The Design and Implementation of a Database Management System (DBMS) for an Address Book application is crucial for organizing, storing, and managing contact information efficiently. In this project, we focus on the case of Abiolian Solution Limited, a fictional company requiring an address book solution to streamline their contact management processes. The primary objective of this research is to design and implement a robust DBMS that can effectively handle the storage and retrieval of contact information for the company. We aim to create a system that is user-friendly, secure, and scalable to accommodate future growth and evolving business needs. Our methodology involves analyzing the requirements of Abiolian Solution Limited, identifying the necessary data fields for the address book, and designing a suitable database schema to represent this information effectively. We will utilize SQL for database creation and management, ensuring data integrity and consistency. The implementation phase will involve developing a user interface for data input and retrieval, incorporating features such as search functionality, data editing, and contact categorization. We will also focus on data validation to prevent errors and maintain data accuracy within the DBMS. Security is a fundamental aspect of the DBMS implementation, and we will implement access control mechanisms to ensure that only authorized users can view and modify contact information. Encryption techniques will be employed to protect sensitive data, and regular backups will be scheduled to prevent data loss. Furthermore, scalability is essential to accommodate the expanding contact list of Abiolian Solution Limited. We will design the DBMS to handle a large volume of contacts efficiently, with optimization techniques such as indexing and normalization to enhance performance. In conclusion, the Design and Implementation of a DBMS for an address book solution for Abiolian Solution Limited is a critical project that aims to enhance contact management processes within the company. By creating a well-structured and secure database system, we can improve data organization, accessibility, and reliability for the users. This project serves as a model for developing DBMS solutions in various business contexts, emphasizing the importance of efficient data management for organizational success.

Project Overview

<p> </p><div><p>INTRODUCTION</p><p><strong>1.1 Background Of The Study</strong></p><p>A <strong>database</strong>&nbsp;is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.</p><p>A <strong>database management system</strong>&nbsp;(<strong>DBMS</strong>) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, MongoDB, MariaDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA, MemSQL and IBM DB2. A database is not generally portable across different DBMSs, but different DBMS can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Database management systems are often classified according to the database model that they support; the most popular database systems since the 1980s have all supported the relational model as represented by the SQL language. Sometimes a DBMS is loosely referred to as a “database”.</p><p></p><p>Following the technology progress in the areas of processors, computer memory, computer storage, and computer networks, the sizes, capabilities, and performance of databases and their respective DBMSs have grown in orders of magnitude. The development of database technology can be divided into three eras based on data model or structure: navigational, SQL/relational, and post-relational.</p><p>The two main early navigational data models were the hierarchical model, epitomized by IBM’s IMS system, and the CODASYL model (network model), implemented in a number of products such as IDMS.</p><p>The relational model, first proposed in 1970 by Edgar F. Codd, departed from this tradition by insisting that applications should search for data by content, rather than by following links. The relational model employs sets of ledger-style tables, each used for a different type of entity. Only in the mid-1980s did computing hardware become powerful enough to allow the wide deployment of relational systems (DBMSs plus applications). By the early 1990s, however, relational systems dominated in all large-scale data processing applications, and as of 2015 they remain dominant: IBM DB2, Oracle, MySQL, and Microsoft SQL Server are the top DBMS.[10] The dominant database language, standardised SQL for the relational model, has influenced database languages for other data models.</p><p>Object databases were developed in the 1980s to overcome the inconvenience of object-relational impedance mismatch, which led to the coining of the term “post relational” and also the development of hybrid object-relational databases.</p><p>The next generation of post-relational databases in the late 2000s became known as NoSQL databases, introducing fast key-value stores and document-oriented databases. A competing “next generation” known as NewSQL databases attempted new implementations that retained the relational/SQL model while aiming to match the high performance of NoSQL compared to commercially available relational DBMSs (<a target="_blank" rel="nofollow" href="https://en.wikipedia.org/wiki/Database)">https://en.wikipedia.org/wiki/Database)</a>.</p><p><strong>1.2 Statement Of The Study</strong></p><p>The problem currently facing the organization such as my case study (Abiolian Solution Limited) is that they easy loss or don’t know exact where they record or keep the information of a client / customer.</p><p>Till date, organization still keeps their information and customer data using the manual method of using biro to write their information on books. This particular manual process of keeps or storing information are face with much problem and issue like the following:</p><ol><li>Difficulty in Retrieving of information / record</li><li>Time wasting and occupy more space</li><li>Important documents may be altered by an unauthorized personal</li></ol></div><div><p><strong>1.3 Significance Of The Study</strong></p><p>The significance of this study includes the following:</p><ol><li>It helps in economic cost reduction in running a particular application.</li><li>It provides humans with effective resource management.</li><li>It will help organizations in focusing on core business in the sense that you only concentrate on what means most to you. Since your applications will be run over the internet, you do not have to worry about technical problems and other inconveniences associated with physical unified storage solution spaces.</li><li>It increases performance and support by updating the fact that all your software and applications automatically.</li><li>It provides security and compliance.</li><li>It provides anytime anywhere access to information.</li></ol><p><strong>1.4 Objective of the study</strong></p><p>The main objective of this project is to design and implement a database management system for Abiolian Solution Limited. The specific objectives are:</p><ol><li>To develop software that can be use to save customer information</li><li>To increase resource availability of Cloud Computing system.</li><li>To develop an address book application that will be launch as a cloud application.</li><li>To develop application that can reduces stress of looking paper or book in which a particular customer is save.</li></ol><p><strong>1.5 Scope Of The Study</strong></p><p>The scope of this proposed system is center on design and implementation of database management system for Abiolian Solution Limited address book.</p><p><strong>1.6 Limitation Of The Study</strong></p><p>Usually, every work has some limitations and this study is not exempted.</p><p>The two major limitations of this study are the high programming technique as well as financial constraints. The high programming technique constraint in PHP, JQUERY and MYSQL prevents the researcher to have an in depth study and analysis on the subject matter. While the issue of financial constraint limits the frequency of investigation to/from the institution toward gathering the necessary information relevant for the study.</p><p><strong>1.7 Definition Of Terms</strong></p><p><strong>Cloud Computing:</strong>&nbsp;the practice of using a network of remote servers hosted on the Internet to store, manage, and process data, rather than a local server or a personal computer.</p><p><strong>System:</strong>&nbsp;A method or set of procedures and even personnel working together as a whole to achieve a goal.</p><p></p><p><strong>Data:</strong>&nbsp;This are numbers, text or images which are in a form suitable for storage in a computer or processed by a computer, or an incomplete information/ unprocessed information.</p><p><strong>Information:</strong>&nbsp;This is a meaningful material derived from computer data by organizing it and interpreting it in a specific way.</p><p><strong>Input:</strong>&nbsp;Data entered into the computer for storage or processing.</p><p><strong>Output:</strong>&nbsp;Information produced from a computer after processing.</p><p><strong>Information System:</strong>&nbsp;A set of interrelated components that collect (or retrieve), process, store, and distribute information to support decision making and control in an organization.</p><p><strong>HTML CODE: &nbsp;</strong>HTML stands for Hyper Text Markup Language. It is a type of computer language that is primarily used for files that are posted on the internet and viewed by web browsers. HTML files can also be sent via email.</p><p><strong>Markup language</strong>: A markup language is a combination of words and symbols which give instructions on how a document should appear. For example, a tag may indicate that words are written in italics or bold type.</p><p><strong>Web browser:</strong>&nbsp;-A Web browser is a software program that interprets the coding language of the World Wide Web in graphic form, displaying the translation rather than the coding. This allows anyone to “browse the Web” by simple <em>point and click</em>&nbsp;navigation, bypassing the need to know commands used in software languages.</p><p><strong>File extension: </strong>&nbsp;A file extension is the suffix at the end of a filename that tells a computer, and the computer user, which program is needed to open the file. Also called a filename extension, this suffix preceded by at least one period, is generally one to five characters long but the norm is usually three characters in length.</p><p><strong>Email</strong>: Email, also sometimes written as e-mail, is simply the shortened form of electronic mail, a protocol for receiving, sending, and storing electronic messages. Email has gained popularity with the spread of the Internet. In many cases, email has become the preferred method of communication.</p><p><strong>TCP/IP: &nbsp;</strong>This often used but little understood set of operations stands for Transmission Control Protocol/Internet Protocol. TCP/IP is the combination of the two and describes the set of protocols that allows hosts to connect to the Internet. In actuality, TCP/IP is a combination of “more than those two protocols, but the TCP and IP parts of TCP/IP are the main ones and the only ones to become part of the acronymthat describes the operations involved.</p><p><strong>TEXT FILE: &nbsp;</strong>A text file is a computerfile that stores a typed document as a series of alphanumeric characters, usually without visual formatting information. The content may be a personal note or list, a journal or newspaper article, a book, or any other text that can be rendered accurately in typewritten form.</p><p><strong>Hyper Link:</strong>-A hyperlink is a graphic or a piece of text in an Internet document that can connect readers to another webpage, or another portion of a document. Web users will usually find at least one hyperlink on every webpage. The simplest form of these is called embedded text or an embedded link.</p><p><strong>WWW: </strong>&nbsp;acronym for World Wide Web</p></div> <br><p></p>