Answer Posted / shankey*
A database is similar to a data file in that it is a
storage place for data. Like a data file, a database does
not present information directly to a user; the user runs
an application that accesses data from the database and
presents it to the user in an understandable format.
Database systems are more powerful than data files in that
data is more highly organized. In a well-designed database,
there are no duplicate pieces of data that the user or
application must update at the same time. Related pieces of
data are grouped together in a single structure or record,
and relationships can be defined between these structures
and records.
When working with data files, an application must be coded
to work with the specific structure of each data file. In
contrast, a database contains a catalog that applications
use to determine how data is organized. Generic database
applications can use the catalog to present users with data
from different databases dynamically, without being tied to
a specific data format.
A database typically has two main parts: first, the files
holding the physical database and second, the database
management system (DBMS) software that applications use to
access data. The DBMS is responsible for enforcing the
database structure, including:
Maintaining relationships between data in the database.
Ensuring that data is stored correctly, and that the rules
defining data relationships are not violated.
Recovering all data to a point of known consistency in case
of system failures.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What do you understand by mysql terminal?
How many sql ddl commands are supported by 'mysql'?
How to convert character strings to dates?
What's the difference between mysql and sql server?
What is required to create mysql database?
Can mysql handle big data?
How do I restore a database in mysql workbench?
What can I do with mysql?
Is mysqli deprecated?
How does php communicate with mysql?
How do I start mysql client?
Define REGEXP?
What is timestamp in mysql?
How do I restart mysql on windows?
What sql does mysql use?