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 is the purpose of using a heap table?
What is general log in mysql?
How to display odd rows in student table in mysql?
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
Does mysql support sequence?
What do I do if I forgot my mysql root password?
How can I compare two mysql databases?
How to escape special characters in sql statements?
Can you tell how many values can set the function of mysql to consider?
What is the difference between BLOB AND TEXT?
Can we store pdf files in mysql?
What is bigint in mysql?
What is tee command in mysql?
How to start mysql server?