Database and Database concepts explained .


Database is an structured collection of Data which is organised in such a way that allows users to efficient storage , retrieve and manipulation of the data .

Database is used to store and manage a wide range of data and informations such as financial data , business data , personal information and secret financial data also .

Here are the some advantages of Database .

Using Database to store information and details can be proven very useful for instance talking about 

Consistency - it provides a centralised location for storing of data which make sure the concept of data consistency between different users and applications . 

With a database it is stored accurately and in an standardised way .

Data accessibility - it makes the access easier and retrieve data and also provide powerful tools for searching and filtering the data . 

User can quickly find the data without having manually shift through large volumes and numbers of data . 

A database also provides built in security features and without authorisation and access control one cannot have access to the database stored (Berg , 2013).

A database can help to integrate data from different sources and systems, making it easier to analyse and manage large volumes of data. 

Scalability: A database can scale to accommodate large volumes of data and users, making it suitable for use in enterprise-level applications.

Databases can be designed to handle millions of records and support thousands of users simultaneously.

Database concepts 

Primary keys: A primary key is a unique identifier that is assigned to each record in a database table. Primary keys are used to ensure that each record can be uniquely identified and accessed(Revesz , p, 2010).

Foreign keys: A foreign key is a field in one table that refers to the primary key of another table. This allows data to be linked and referenced across different tables in a database.


Refrences -

Revesz, P., 2010. Introduction to databases. Springer, London, UK.

Berg, K.L., Seymour, T. and Goel, R., 2013. History of databases. International Journal of Management & Information Systems (IJMIS), 17(1), pp.29-36.

Comments

Post a Comment

Popular posts from this blog

Types of E-commerce websites .

Image
Types of e-commerce websites - 1.  (B2C) Business to consumer . Example - H&M Fashion industry has huge impacts on global environment . The demand to minimize the environmental pollution is not only from fashion firms but also consumers. (Shen2014). H&M is a very well renowned fashion website which is available in many countries and some countries also have many offline stores also. it provides customers with a wide range of selection from designed clothes .  2 . ( B2B) Business to business Example - Amazon business  Understanding the originality of their business models, and how this originality both enables  and  expresses the organisational form that supports them, allowing to develop and exploit work in an unprecedented way, (Harraca2017) .  Amazon business offers purchasing options for any registered enterprise of any way . one can buy supplies on amazon business on behalf of their employers . (Harraca , 2017).  ...
Read more