Ask a question from expert

Ask now

Database Management System DBMS Assignment

11 Pages3356 Words286 Views
   

Added on  2019-12-03

Database Management System DBMS Assignment

   Added on 2019-12-03

BookmarkShareRelated Documents
Informationsystemsmanagement
Database Management System DBMS Assignment_1
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1Concept of Database Management Systems................................................................................1Aspects of information storage and management........................................................................2Need of Data Storage...................................................................................................................2Threats related to Database management:...................................................................................3Solutions for database security threats........................................................................................5CONCLUSION................................................................................................................................7REFERENCES................................................................................................................................8
Database Management System DBMS Assignment_2
INTRODUCTIONDatabase management has become a very key component of business efficiency. In thepresent business environment, huge amount of data has been generated by the companies. Soconcern about data security and data efficiency is increasing. The purpose of this report is toanalyse how firms are dealing with the security threats related to data. The study will help inunderstanding how and why database systems are specified, designed, implemented, tested andmaintained. It will analyse the requirement for data storage and information gathering for firms. Concept of Database Management Systems It is evident that in the present context, companies are having large amount of data tostore and analyse. DBMS is a software tool which helps in organizing the data in a database inan effective manner (Dhillon, 2007). The ultimate purpose of this tool is to store and transformthe data into information to support in making decisions. This concept has come into limelightbecause it is really difficult for companies to store such high volume of data. Due to this, they arefacing many issues related to storage and security. DBMS consists of following three elements:Physical Database – It is a collection of files which contain the data Database engine – It is a software which ensures editing of the information (Eliasson,2014)Database scheme – It shows the specification of the logical structure of the data stored inthe database The system facilitates the users to create, edit and update data in the database files. There is aconcurrent access to the same database by multiple users. Security rules are determined in orderto access the rights of the users. Backup and recovery of data is possible constantly in case if aproblem occurs (Kovacich, 2013). The database structure and rules helps in improving theintegrity of data. A data dictionary offers a description of the data. It is to be noted thatdevelopment of the database is controlled by DBAs (Database Administrators). It ensures thatdatabase structure is efficient and reliable. These people are also responsible for controllingsecurity aspects. For instance, different personnel within the company use databases in differentways. Some of them just simply want to view the data and perform basic analysis (Maier, 2007).However, other employees are actively involved in adding data to the database or updating theexisting data. It is required that administrators needs to set user permissions. 1
Database Management System DBMS Assignment_3
Aspects of information storage and management Data management – The first aspect of information management is the data management.The raw data is in large volume and requires to be structured properly. At this phase theinformation is then extracted (Medhi, 2013). Information delivery – This aspect is responsible for development of solution related tomanagement as well as delivery of the data. The DBMS possess the advantage of havingboth real time and historic data manipulation. This makes the information deliveryprocess much faster (Shingo and Chong 2007). Information usage – The use of the data depends upon the nature of the information. Itcould be used for business analytics or business intelligence. All things must be handledby using a specific system.Need of Data Storage Today all are living in an information-centric world. As a part of society, all have anincreasing reliance on development and consumption of data. It is considered important becausethere is a need to complete wide range of activities (Milne and Witten, 2013). In the presentcontext, data storage and management has become the activity which has to be pursued by everyorganization. Information management is many times harder as compared to data analytics.There is no need to collect the data which has no value for the companies. They are carrying outmore and more analytics on data in order to gain a better understanding of their clients orcustomers and also to gain a higher share in the market (Yates and Paquette, 2011). The collectedinformation aids in finding solution, solving issues and selling more products or services. It is tobe noted that analytics has become a widely recognized trend in the industry facilitating cross-pollination of the data. Many of the firms are now making millions from simply collecting andselling information. For instance, store cards collect the shopping habits of the customers(Becker, Greve and Albers, 2009). A business can use this data to understand which products arepopular and which ones are not. Further it can be tracked what time of the day and what days ofthe week are popular for shopping. As companies are growing an expanding across the world, the need for instant andeffective communication of data is also increasing. It has become essential for the success. One2
Database Management System DBMS Assignment_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Information Management System: Assignment
|12
|3467
|412

Data Modelling and SQL Language
|16
|2546
|97

Data & Information Management
|7
|1496
|79

Database and Information Management - Assignment
|5
|1165
|18

Database Management: Components, Security, and Countermeasures
|15
|2284
|327

Data Modelling and SQL Language : Report
|31
|4640
|88