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
How do I rename a procedure?
What is difference between oracle sql and mysql?
What is the maximum size of mysql database?
What is mysql optimization?
What is the maximum connection pool size?
What is mysql_query?
How to see the create table statement of an existing table?
What is difference between mysql and mariadb?
Which is best pdo or mysqli?
How to extract a unit value from a date and time?
How do we delete a row in a table?
What is the latest version of php and mysql?
What is dbms in mysql?
Which statement is used in a select query for partial matching?
What is a session in mysql?