COM5005 Database Implementation: Tools and Techniques Report

This report delves into the critical phase of database implementation, focusing on the installation of a database management system on specific hardware and its optimization for both software and hardware platforms. It explores various tools and techniques that support database development, including Microsoft Access and StarUML. Microsoft Access is highlighted for its relational database engine and graphical user interface, its ability to link with other databases, and its compatibility with various applications. StarUML is presented as a tool for UML diagrams and ERD generation. The report provides a detailed overview of the tools and techniques used to support the development and implementation of databases, offering insights into their functionality and benefits. It concludes by emphasizing the importance of these tools for efficient database management and providing references to relevant research.

Database Implementation
INTRODUCTION
The implementation of database is considered as the phase in which a proper
database management system is being installed on a specific hardware. Also, it
helps in optimising the database so that it can perform well on the software as well
as hardware platform. Thus, a database is created and thus loads all the information
and data. The poster is about discussing all the tools and techniques that are being
used for supporting the development of the database.
Tools and techniques used for supporting database development
Although there are various tools that are being used for providing support to the
development of database and also in its implementation such as draw.io, Ms access,
SQL lite, My SQL work bench, start UMLs etc., but discussing a few of them as under
:
Star UML
 Star UML is considered as a very well known and popular tool that has been developed
by the MKLab and after various failures have proved to be successful enough for an
efficient implementation of the database.
 It is specially known for supporting various types of diagrams that are specified in
UML 2.0.
 The first version of Star UML was written in Delphi, which became one of the reason
that it didn't work well but a new version has been created as Star UML2.
 Also, it has been observed that this new version is compiled of various new features
like as there are extensions present in the database, so it can help in providing support
to such extensions.
 Also, it has been compiled of the new and completely updated graphical user interface
that can help in providing an efficient and appropriate implementation of the database.
 The new feature is also compatible enough with the OS X so it can act as a very
beneficial feature. Star UML is considered as one of the efficient tools because it helps
in a better ERD generation.
 Also, from the extension registry, the ERD generation extension can be downloaded
because it provides a sort of support in the generation of the entity relationship data
model from the available schema of the database.
 So, this can be considered as an appropriate option for supporting the development of
the database.
 Along with these features, this tool is compatible enough with a variety of features
such as it acts supportive enough for almost 11 types of UML diagrams.
 There are various types of UML diagrams such as class diagrams, profile diagram, use
cases, state charts, composite structures etc. and star UML2 is compatible with all these
types, so it can provide a better implementation and as a support as well for an
appropriate development of the database.
Microsoft Access
 Microsoft access can be considered as an efficient database
management system in which the Microsoft jet database
engine that is relational is being merged with the graphical
user interface and various other tools that are associated
with the development of software.
 One of a special feature of using Ms access is that it can get
easily linked with all the other information and data stored
in different databases and applications as well. Also, it can
bring in the data very easily.
 It is usually classified as a type of relational database
management system. Although it is known for using its self
storage information of the database, it comprises various
other factors as well.
 There are various products such as SQL Server that act as
the back end for the tables. Also, like this, Sybase and
Oracle acts the same but Microsoft access acts as the front
end of the programs and tables.
 Thus, it can be considered as an efficient option for a
successful implementation and development of the database.
 There are some applications as well that are being used by
the Microsoft access such as ASP.NET, visual studio etc.
The tables that are being created in the access provides
support to various field types such as deferential integrity,
indices, for updating, deleting etc.
 There is a query interface present as well that helps in
entering as well as displaying the information. The database
is usually referred to as multi handling user and also
manages an efficient record locking.
 So, Microsoft access can be considered as an efficient
option for a successful development and implementation of
the database.
 With Microsoft access, placing a database on a network
seems easy enough and also, various number of users can
act at the same time.
 Thus, at the time of development of the database, various
number of users can take part at a single time and it can be
termed easy enough because it supports almost all field
types, whether it is about the cascading updates or about the
referential integrity, it provides support to both.
 It has been designed in a way that it is able enough to run
even the complicated and complex queries. For such an
organisation, the most important factor that is required is a
high bandwidth and a great memory, so the Microsoft
access provides both of them thus providing a great amount
of support to the development and implementation of the
database.
CONCLUSION
It can be concluded that when a complete and efficient database management system is being installed on a hardware, that stage is classified as the implementation
of the database. Also, there are enormous number of tools and techniques that helps in providing a sort of support in the development of the database such as draw.io, SQL
lite, Microsoft access etc. and some of these have been defined well in order to provide an efficient and appropriate amount of support in the development of the database.
REFERENCES
Rajakumari, S. B. and Nalini, C., 2014. An efficient data mining dataset preparation using aggregation in relational database. Indian Journal of Science and Technology. 7(S5). pp.44-46.
Star UML2. A sophisticated software modeller., 2018. Available through: <http://staruml.io/>.