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.
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.
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: