Database and Information Management - Assignment

Running head: DATABASE
DATABASE
Name of the Student:
Name of the University:
Author Note:

DATABASE1
Database and information management
Database is data’s organized collection, generally electronically stored as well as
accessed from computer system. When there is more complexity in the databases, they are
developed often by using formal modeling and design techniques. It is information’s collection
which is organized that could be easily managed, accessed as well as updated. Databases possess
aggregations of files or data records, which contains information of interactions or transactions
(Arulraj and Pavlo 2017). It is data structure which stores the organized information. Databases
contain several tables which might include several separate fields for each table.
Database management system (DBMS) is software which interacts with the end users and
applications for capturing as well as analyzing data. In addition, DBMS software encompasses
core facilities that are provided for administering the database. Spreadsheet is a software to
create as well as manage databases, however there is no schema in spreadsheets. DMBS are quite
better than spreadsheets. There are many advantages of DBMS over spreadsheets. Redundancy
could be removed by normalization of data. No duplication of data saves storage as well as
improves accessing time (Islam et al. 2017). This is easier in applying access constraints within
database systems for making sure only the authorized user could access data of database. Every
user has different access set, hence data is safe from issues like data leaks, data’s misuse and
identity theft. DMBS provides limited access which means data’s privacy. Data is managed by
DBMS in a way data could be accessed easily with quick response times.
As DBMS keeps data’s backup, this is easier in doing full data recovery in case of failure.
DMBS are much more flexible when compared with spreadsheet. Information could be viewed at
much deeper level through DBMS than spreadsheet. Adopting DBMS allows to find perfect fit