CS403: Database Management System Handouts
A database is a collection of related data used to retrieve, enter and delete data correctly. It is also used to organize data in the form of a table, schema, ideas, reports, etc. CS403 HANDOUTS
Course Category: Computer Science/Information Technology
Introduction to Basic Database Concepts, Database Architecture, Database Planning, Conceptual Database Design, Logical Database Design, Transforming E-R Design to Relational Design, Data Definition Languages, Data Manipulation Languages, Normalization and Denormalization, Physical Database Design, Database Tools, Structured Query Language (SQL), Data Storage Concepts, Indexes and Views, Transaction Management, Concurrency Control. CS403 HANDOUTS
JOIN VU ASSIGNMENT SOLUTION GROUPS AND ALSO SHARE WITH FRIENDS. IN THESE WHATSAPP GROUPS WE SEND A SOLUTION FILE AND LINK FOR YOU. TO JOIN WHATSAPP GROUPS CLICK THE BELOW LINK.
JOIN VU STUDY GROUPS
CS403: Database Management System
What is Database
A database is a collection of related data used to retrieve, enter and delete data correctly. It is also used to organize data in the form of a table, schema, ideas, reports, etc. A database, also called an electronic database, with any data collection, or information is specially designed for fast search and computer access. e.g., an online phone directory uses a website to store personal data, phone numbers, and other contact information.
Types of Database
Here are some popular types of Databases. CS403 HANDOUTS
It is centralized, and users from different domains can access this data. This type of computer system maintains system processes that help users to access data even from a remote location.
A distributed database is a type of database that has contributions from a standard database and information captured by local computers. In this type of database system, data is not in one place and is distributed to various organizations.
This type of database defines a site relationship in the form of tables. It is also called the Relational DBMS, which is the most popular type of DBMS on the market. Examples of RDBMS program databases include MySQL, Oracle, and Microsoft SQL Server databases.
A cloud database is a database developed or built for such a virtual environment. There are many benefits to a cloud database, some of which can pay for storage capacity and bandwidth. It also offers reduced demand, as well as higher availability.
This type of database supports the storage of all types of data. Data is stored in the form of objects. Items to be stored in a database have attributes and methods that define what to do with the data. PostgreSQL is an example of DBMS focused on objects.
Database Management Systems (DBMS)
Database Management Systems (DBMS) are software programs used to store, retrieve, and use queries in data. DBMS acts as a visual link between the end-user and the site, allowing users to create, read, update, and delete data on the database.
A database management system (DBMS) is software or tool used to manage a database and its users. DBMS provides a visual interface for performing various tasks such as database creation, data storage, data recovery, table creation, and much more. It provides security and security to the database. In the case of multiple users, it also maintains data consistency.
The two basic functions performed by the DBMS are:
- Management of Data in the Database
- Management of Users associated with the database. .
Data management means specifying how data will be stored, organized, and accessed on a database. Database user management means managing users in such a way that they can perform the tasks they want on the database. DBMS also ensures that the user is not able to perform any functionality that is not permitted. Also, an authorized user is not allowed to perform any restricted action on that user.
Benefits of Database Systems
Data consistency means that changes made to different data appearances must be managed and controlled in such a way that all events have the same value as any particular data object. Data incompatibility leads to many problems, including loss of information and incorrect results. On the database, the path is controlled because data is shared and consistency is controlled and maintained.
Better Data Security:
All application programs access data via DBMS, Therefore DBMS can best monitor which user is taking action and accessing which part of the data, therefore DBMS effectively manages and maintains data security stored on the site.
Better Backup and Recovery:
Data is a very important resource and very important to any organization, losing a valuable resource can lead to a major strategic disaster. As Data is stored on modern storage devices such as hard disks etc., it is necessary to retrieve data from time to time so that in the event of a storage device losing data due to any damage we should be able to retrieve data locally, Database systems and a good way to restore those backups to restore based data.
It happens that for some time the site used and the most important transaction took place after the backup was done, suddenly due to any dangerous site, crash the site (improper closure, invalid disk access, etc.) Now in that dangerous situation transactions made after saving the last copy are not lost.
Databases and database programs are designed to share the same data for many different purposes, therefore do not need to be stored as often in different ways as it is used, for example, the data used by the Admissions Department of any educational institution is used to keep student attendance records and student exam records. Therefore, it saves us a lot of effort and resources that provide a quality economy.