Midterm Learning Task Module 1 (Lec)
Information Management

Zyvrex John R Perez
BSIT - 1A

Function of DBMS

The database management system (DBMS) must be able to receive data definitions in source form (external, internal, and conceptual schemas, as well as all related mappings) and convert them to the proper object form. It must be able to respond to user requests to access and maybe edit current database data, as well as to add new data to the database.

Advantage of DBMS

Data redundancy is avoided in database systems by keeping a single copy of the data. Because a single copy of a particular data is stored in the database, you can be sure that any changes to the data will be reflected in all future uses of that data.The database system's structure requires that data be independent of other data in the database and the software used to access the database. In a database context, data is easier to utilize. The database will take up less storage space since data redundancy is reduced, if not eliminated.

Dis-Advantage of DBMS

Databases and their accompanying database management systems (DBMS) are exceedingly complicated. Because extra hardware may be required, the installation of the DBMS and its databases into the present system requires careful planning. Because data in a database is stored in a central location, it might be lost in part or whole if hardware components fail or if software errors occur. The size of a typical mainframe database is enormous. When a firm buys a database product, it must first train one or more people to be the product's database administrator. Most database systems have incompatibilities with other database systems, which is one of its flaws.