Below is a brief overview of this Project Work.
Format: MS WORD
| Chapters: 1-5
| Pages: 75
Design And Implementation of Database Management System Case of an Abiolian Solution Limited address Book
CHAPTER ONE
INTRODUCTION
1.1 Background Of The Study
A database 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.
A database management system (DBMS) 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”.
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.
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.
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.
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.
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 (https://en.wikipedia.org/wiki/Database).
1.2 Statement Of The Study
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.
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:
1.3 Significance Of The Study
The significance of this study includes the following:
1.4 Objective of the study
The main objective of this project is to design and implement a database management system for Abiolian Solution Limited. The specific objectives are:
1.5 Scope Of The Study
The scope of this proposed system is center on design and implementation of database management system for Abiolian Solution Limited address book.
1.6 Limitation Of The Study
Usually, every work has some limitations and this study is not exempted.
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.
1.7 Definition Of Terms
Cloud Computing: 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.
System: A method or set of procedures and even personnel working together as a whole to achieve a goal.
Data: 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.
Information: This is a meaningful material derived from computer data by organizing it and interpreting it in a specific way.
Input: Data entered into the computer for storage or processing.
Output: Information produced from a computer after processing.
Information System: A set of interrelated components that collect (or retrieve), process, store, and distribute information to support decision making and control in an organization.
HTML CODE: – 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.
Markup language: – 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.
Web browser: -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 point and click navigation, bypassing the need to know commands used in software languages.
File extension: – 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.
Email: – 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.
TCP/IP: – 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.
TEXT FILE: – 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.
Hyper Link:-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.
WWW: – acronym for World Wide Web.
CHAPTER ONE
INTRODUCTION
1.1 Background Of The Study
A database 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.
A database management system (DBMS) 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”.
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.
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.
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.
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.
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 (https://en.wikipedia.org/wiki/Database).
1.2 Statement Of The Study
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.
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:
1.3 Significance Of The Study
The significance of this study includes the following:
1.4 Objective of the study
The main objective of this project is to design and implement a database management system for Abiolian Solution Limited. The specific objectives are:
1.5 Scope Of The Study
The scope of this proposed system is center on design and implementation of database management system for Abiolian Solution Limited address book.
1.6 Limitation Of The Study
Usually, every work has some limitations and this study is not exempted.
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.
1.7 Definition Of Terms
Cloud Computing: 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.
System: A method or set of procedures and even personnel working together as a whole to achieve a goal.
Data: 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.
Information: This is a meaningful material derived from computer data by organizing it and interpreting it in a specific way.
Input: Data entered into the computer for storage or processing.
Output: Information produced from a computer after processing.
Information System: A set of interrelated components that collect (or retrieve), process, store, and distribute information to support decision making and control in an organization.
HTML CODE: – 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.
Markup language: – 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.
Web browser: -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 point and click navigation, bypassing the need to know commands used in software languages.
File extension: – 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.
Email: – 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.
TCP/IP: – 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.
TEXT FILE: – 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.
Hyper Link:-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.
WWW: – acronym for World Wide Web.
How to Download the Full Project Work for FREE
- You can download the Full Project Work for FREE by Clicking Here.
- On the other hand, you can make a payment of ₦5,000 and we will send the Full Project Work directly to your email address or to your Whatsapp. Clicking Here to Make Payment.