Most of us
encounter several activities in our daily life which involves database systems.
In the contemporary world, database has become an important part of our lives. In
the past few years database has introduced many new ideas in respective field
of information technology. Database is used to extract or analyze useful
information from large databases. Database systems are used in all fields of
life where computer is involved whether in business, medicine, law or
engineering and commerce. Most of the information stored in database systems
are either numeric or in the form of text, the data which fulfills this
criteria is called traditional databases.
Database
systems provides an organized way of managing and storing data. They store
their data in tables and set them according to the requirements. Tables of a
database systems are not different from excel tables because they contains
columns and rows just like excel. Tables of database systems are more dominant
than spreadsheets because they allow to manipulate data in the tables to
facilitate its users. Users can update their records in tables in the form of
bulks. Database systems are used in every field because they allow to access
cross – reference records in different tables of a single database. You can
perform complicated calculations in the database systems. Information in the
form of data which is entered into the database table from multiple tables of a
database by creating relationships of foreign keys of these tables.
In Database
fundamentals Access databases accepts excess spreadsheets if they bears tons of
data within them. The user should be well aware of all criterion and formats of
access files. The terms database systems, database server, database and
database management systems are often use for the same purpose.
Data can be
stored in various forms like tabular, hierarchical and graphical forms.
Relational database stores information in the form of tables and the
information which is present in the form of graphs which gives information
about relationships of different objects is called network database.
A database administrator should be capable of
following tasks:
A database administrator is responsible for fulfilling the needs and demands of a user, so that they can access through the database easily.
All data should be secured properly and the protection of the data should be ensured by the administrator.
In this era of technology database systems are rising day by day, the user should be expert in all new technologies related to database systems.
Database fundamentals covers developing, managing and testing of all data.
The developer should be skilful in soft wares related to database systems lie queries of SQL and Oracle.
Database fundamentals include monitoring and debugging of the database servers.
