rotpr.blogg.se - Computer database management system pdf

#Computer database management system pdf software#

So it is necessary to ensure that the data is correct and, consistent in all the databases and for all the users., All of these databases contain, data that is visible to multiple users. Data, Integrity is very important as there are multiple databases in a DBMS. Data Integrity:- Data integrity means that the data is accurate and consistent in the database.Many remote users can also access the database, simultaneously and share the data between themselves., Sharing of Data In a database: - the users of the database can share the data among themselves., There are various levels of authorisation to access the data, and consequently the data can only be, shared based with the authorized users.

This is, prevented in a database as there is a single database and any change in it is reflected immediately., Because of this, there is no chance of encountering duplicate data.,

Because of this, there were sometimes multiple copies of the same file which lead to data redundancy.

Reduces Data redundancy: - The database management systems contain multiple files that are to, be stored in many different locations in a system or even across multiple systems.

Such type of data access is referred to as a client-server model., Advantages of Database, Typically, databases available on the database servers are accessed through, command line or graphic user interface tools referred to as Frontends database servers are referred, to as Back-ends.

Relational: Data is stored in multiple tables and the tables are linked using a common field., Relational is suitable for medium to large amount of data,, Database Servers, Database servers are dedicated computers that hold the actual databases and run only the DBMS, and related software.

Usually suitable for less amount of data.,

Flat File: Data is stored in a single table.

#Computer database management system pdf software#

Computerized database, systems, commonly known as Database Management System (DBMS), also made the processes of, retrieving and updating data from the databases much easier and faster., Commonly used database applications or software are, Oracle, MySQL, Open office base, Microsoft access, Microsoft SQL SERVER, Data can be organized into two types:, Such a collection of information is termed as a database., With the arrival of computers, maintaining database became easier. As a student, you maintain, your daily work in your notebook or use any application on the computer to record your daily, activities.

UNIT 3 Database Management system, Class-10, Database is a collection of information or data in an organized manner.