in a database, what is the smallest unit of data a user accesses? This is a topic that many people are looking for. amritsang.org is a channel providing useful information about learning, life, digital marketing and online courses …. it will help you have an overview and solid multi-faceted knowledge . Today, amritsang.org would like to introduce to you What is Database. Following along are instructions in the video below:
In this video. We will cover the basics of database. So why do we need need a database data is all around us for example you might have all your and their phone numbers on your phone your emails are stored in your email app.
Your photographs are there on instagram we use our own youtube. You get the picture. If you think you have a problem.
Managing your data. Think of some large companies like google facebook or any large corporation or bank imagine where they are storing all their user data mails messages photos we use buildings vendor information etc and we as their customers want our data asap. All of these companies have databases.
A database is nothing but a collection of data or information. That is organized in such a way that it can be easily accessed managed and updated and dbms or database management system is a software that handles the storage retrieval and updation of data in a computer system some popular dbms are mysql sql server oracle etc.
Why cant we use our old file processing system file processing system has disadvantages like data. Redundancy data. Inconsistency.
Insurable. Data. Unstandardized data.
Insecure data. Etc. Well.
What ok. Lets understand each of them.
One. By one data. Redundancy means duplication of data.
Non database systems maintain separate copy of data for each application. This duplication of data may lead to inconsistency or incorrect data at times for example dbms stores. All data at one place and all the application programs that require this data can refer to the same central place this centralization makes sure that data remains consistent and secure data redundancy leads to data inconsistency multiple mismatching copies of same data is as data inconsistency when the redundancy is not controlled there may be occasions.
When the two entries about the same data do not agree at such times. The database is said to be inconsistent and inconsistent database will provide incorrect or conflicting information. Next comes sharing dbms makes sure that not only the existing applications can share the data in the database.
But also that new applications can be developed to operate against the same stored data. There may be certain standards laid by the company industry standards or national international standards.
Which need to be followed ppm is can ensure that all of the data follow the standard for storage and retrieval. The data information of an organization individual must be kept secure and private dbms. Ensures data.
Security and privacy by ensuring that the only means of access to the database is through the proper channel and also by carrying out authorization check whenever access to sensitive data is attempted there are different types of databases. They include hierarchical network object oriented and relational database. We will cover relational database here when the data is stored in multiple tables that are linked why a common field.
Then such a database called relational database. A table is data set that is organized into rows and columns a row is also called as record. Which represents one complete unit of information column is also called as field.
Which contains one type of information. It is the smallest unit of name data it may consist of any number of bits of bytes normally a table has one column or field.
Which uniquely identifies the record of the table. This field is called the primary key. A foreign key is a feeling that references.
The primary key of another table now that you have your data in databases. How do you work with it most large companies have dba or database administrator. Who is responsible for managing and maintaining the dbms they use sql or structured.
Query language. Which helps you to create access and manipulate databases you typically write queries in english. Like language to perform any of these tasks.
Most dbms display forms. Which is an interface in user specified layout that allows user to view interchange data directly in the table. The data is then used to present as reports to senior management.
It is a formal presentable printed document that lists data in a formatted manner music .
Thank you for watching all the articles on the topic What is Database. All shares of amritsang.org are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.