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
Does mysql case matter?
What is the difference between unix timestamp and mysql timestamp?
What is dblink?
How do I stop a mysql service?
How can we convert between Unix & MySQL timestamps?
How internally data stores in MyISAM and INNODB table types?
How do I restore a database in mysql workbench?
How do I know if mysql is installed on windows?
How do I create a schema in mysql?
What are the method you will follow while sql installing
What is normalization and list the different types of normalization?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
Why do we use pragma autonomous transaction?
What is slow query log in mysql?
What is mysql_connect?