Database Technologies and Techniques

COMPUTER
INFORMATION SYSTEM

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
1.1. Critically compare different data models.............................................................................1
1.2.Critically discuss the benefits and limitations of different database technologies................1
1.3 Various approaches to database design................................................................................2
TASK 2............................................................................................................................................2
2.1 Designing a relational database system.................................................................................2
2.2 Building a relational database system...................................................................................3
2.3 Database tools and techniques..............................................................................................3
TASK 3............................................................................................................................................4
3.1 Benefits of using manipulation and query tools....................................................................4
3.2 Implementing a query language in relational database management system........................4
3.3 Critically evaluating the quality of data through query tools................................................4
TASK 4............................................................................................................................................5
4.1 Critical analysis of the database implemented......................................................................5
4.2 Documentation of the implementation and testing...............................................................5
4.3 User documentation for relational database..........................................................................5
4.4 Concepts of verification and validation................................................................................6
4.5 Use of control mechanisms in developed relational database systems.................................6
CONCLUSION................................................................................................................................7
REFERENCES................................................................................................................................9

INTRODUCTION
There are various types of data models that are considered as an essential aspect of
information systems and have an influence on the processing of operations and processes.
Different database technologies include SQL, IBM etc. have advantages along with some
limitations as well (Paul, Bhuimali and Aithal, 2018). A relational database model can be
developed in an efficient database software application. Importance of various tools and
techniques of database have also been included in the report. Manipulation, query tools along
with its impacts and aspects for an efficient testing process has also been discussed in the report.
TASK 1
1.1 Comparing Different Data Models
It is regarded as the representation which is mostly done on the conceptual basis related
to various structures of data which are required in the database. For using common analogy, the
provided data model equals the building plans of architect. The data model is considered as an
independent regarding the hardware and software constraints. Data model represents graphical,
complex and data structures of the real world. It provides facilitation to the interaction among
those who are designers and applications by which the programmer and the end user shares.
Several end users have various different views and required certain data for processes.
There are certain types of data models which are hierarchical model, network model,
relational model, Entity relation model, object oriented model and deductive model. Hierarchical
model provides the data in an organised manner in the form of tabular rows. Network model has
the graphical structure in the form of graphs between various nodes whereas in the relational
model the data is provided in the form of table. So, on the basis of these models, Apadmi Ltd
can ensure involving the same as per the requirements of the company.
1.2 Benefits and limitations of different Database Technologies
In the particular database system there is storage of data in the databases which are large
whereas in the file system, the data stored is in the form of various files.
In the following file system, there are several tasks such as retrieval, storage and search which
can be done manually while the several DBMS are provided.
There are various types of database technologies and some of the well-known and
common examples of this can be considered as My SQL, OODBMS, Oracle database, IBM DB2
etc. Every single database have enormous number of advantages and beneficial factors that
1

somewhere helps in reducing the rate of complexity of the queries, thus solving them and making
the process and outcomes clear enough, so there are some factors that actually can act as a
limitation of the same (Powar, Kamath and Dhruv, 2018). In addition, on the basis of the
structural factors, the databases can be classified as hierarchical, object oriented, relational etc.
Here, a comparison can be made between the file systems and the database management system.
In case of the database management system, there is a possibility of avoiding and blocking any
sort of external or unauthorised access whereas in case of file systems, there are probably more
chances of the data and information to be lost. So, the same can be considered in Apadmi Ltd.
for having an effective rate of processing.
1.3 Various approaches to database design
There are various different approaches of database design and are discussed as below::
Top Down Approach
In top down approach, it keeps its focus on the fact that what are the basic requirements
of the system. While investigating this, different entities along with attributes are being achieved
as well.
Bottom Up Approach
Bottom up approach can be considered as reverse of top down approach. The main
difference is in its approach, attributes have been found before the entities. Apadmi Ltd. can
make involvement of the top down approach in order to achieve all the targets and objectives.
2