Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10:35 Answer 1 of 1 Basically DBMS have following characteristics ACID Properties-DBMS follows the concepts of Atomicity, Consistency, Isolation, and Durability (normally shortened as

image text in transcribed

10:35 Answer 1 of 1 Basically DBMS have following characteristics ACID Properties-DBMS follows the concepts of Atomicity, Consistency, Isolation, and Durability (normally shortened as ACID). These concepts are applied on transactions, which manipulate data in a database ACID properties help the database stay healthy in multi- transactional environments and in case of failure Stores any kind of data-A database management system kind of data that exists in the real world can be stored in Pred to work with all kinof Backup and recovery-There are many chances of failure of whole database. At that time no one will be able to get the database back and for sure company will be in a big loss. The only solution is to take backup of database and whenever it is needed, it can be stored back. All the databases must have this characteristic But from this Provied artical i can call out the following as characteristics Alational dia DMS that prosents the data tabular form of rows and cols table is a pation of ity. A table is a combination of column and rows. Each colle stribute of the entity, also known as fields or properties ROBSES allow Create, Read Update, and De (CRUD) operati SQL provides DMI (Data Manipulation Lang commands that are used insert, update and deleted Common DML commands are INSERT, UPDATE DELETE SQL DDL (Data Definition Language command a ed to manipulate the database objects such as data tell, table, and other object RDBMS, but also provides functionality for Cloud, Document Store, Graph DBMS, Keyalar g BLOG, and PDF Sages Recently Oracle just ced as feature that allows the PostgreSQL is for its architecture, reliability dedication of the community behind the IBM DB2 database is relational database that deli advanced data management and analytics capabilities for your transactional and warehousing workload. This operational database is designed to deliver high perfarms, actionable insights, data availability, and The Dbl database software includes advanced features such as in-memory technology, advanced manag and development tools, storage optimization, workad management, actionable compression, and conti In short Real-world entity- Relation-based tables- Isolation of data and application- Less redundancy Consistency Query Language ACID Properties Multiuser and Concurrent Access- Multiple views Security- Examples proved in artical consider and works on all this characterstics Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting and Reporting a Global Perspective

Authors: Michel Lebas, Herve Stolowy, Yuan Ding

4th edition

978-1408066621, 1408066629, 1408076861, 978-1408076866

More Books

Students also viewed these Accounting questions

Question

Define self, self-image, and identity.

Answered: 1 week ago

Question

By definition the break-even point is?

Answered: 1 week ago

Question

How do successful business professionals use IS? LO.1

Answered: 1 week ago