Introduction To Databases

The term database basically means a structured collection of simple records saved and stored in a replica.

However, Database Management System (DBSMS) is an inbuilt system involving the application installed to enable users to manage its resources and features.

The following are a few basics every user or a student studying database must know:

• How to add, remove, and update records
• How to retrieve data that match certain criteria
• How to cross-reference data in different tables
• And how to perform the complex aggregate calculation

In most cases, the database consists of columns (attributes) and rows, thus records.

Database Versus Spreadsheet

There is an easy manipulation of data. Though databases have the greatest advantages over other applications in the computer system, there are disadvantages too.

Disadvantages of a single table database:

• File or records redundancy of data
• Also, problems with complex data
• Shortcomings and problems in updating in bulk (new phone number)
• Problems in adding incomplete data (new publisher)
• Problems in removing groups of data (all books from the publisher)

Solutions:

Relational Database Management System(RDBMS) example, Microsoft Access. Real practicals would be given in our next article.

About Author

SURF

See author's posts