Electronic databases allow centralised use of information amongst many users over a network and therefore reduce duplication, e.g in banks.Electronic databases can easily share the information with other software applications/programs.Electronic databases format, arrange and present information in customizable ways.Electronic databases make it easier to query, search, filter and retrieve required data.Electronic databases enable automatic updating and recalculating of data.Electronic databases allow easy input and editing of data.Electronic databases store very large amounts of data.
TRADESKILLMASTER GUIDE DATABASE MANUAL
Īdvantages of Electronic Databases over Manual databases.Built-in functions (similar to those available in spreadsheet applications) that simply calculations.Import/Export commands to enable sharing of data between the database program and other programs that use similar structured data.Sort commands/tools that arrange data values in a certain order.Relationships/associations between data objects/ tables.Data validation commands: that ensure the integrity of data entered and stored in the database.Filter Commands- that display data which satisfy certain conditions.A query language (such as SQL) used to manipulate or extract data.Logical Data structures / Objects – such as tables, forms, queries and reports, used to store and manipulate structured data.A DBMS typically have the following features: Examples of DBMS software include: Microsoft Office Access, dBase, SQL Server, Oracle, MySQL, Informix, DB2, Paradox, FoxBase, FileMaker Pro, Lotus Approach, etc. It provides users with tools used to add, delete, access, modify, and analyze data stored in one location. A Database Management System (DBMS) is a software program used to create and manage an electronic database.