114049

Demonstrate an understanding of Computer Database Management Systems

This unit standard is intended

• To provide a fundamental knowledge of the areas covered
• For those working in, or entering the workplace in the area of Information Technology
• As additional knowledge for those wanting to understand the areas covered

People credited with this unit standard are able to

• Describe data management issues and how it is addressed by a DBMS.
• Describe commonly implemented features of commercial computer DBMS`s
• Describe different type of DBMS`s
• Review DBMS end-user tools

LEARNING ASSUMED TO BE IN PLACE AND RECOGNITION OF PRIOR LEARNING

The credit value of this unit is based on a person having prior knowledge and skills to: Demonstrate an understanding of fundamental mathematics (at least NQF level 3). Demonstrate PC competency skills (End-User Computing unit Standards, at least up to NQF level 3)

SPECIFIC OUTCOME 1

Describe data management issues and how it is addressed by a DBMS.

What is data management?

Data management is the development and execution of architectures, policies, practices and procedures in order to manage the information lifecycle needs of an enterprise in an effective manner.

Describe data management issues

What is a database management system (DBMS)?

A Database Management System (DBMS) is software that allows users to create, manage, and interact with databases efficiently. It provides tools for storing, retrieving, updating, and securing data while ensuring consistency and integrity.

Ways in which database management systems (DBMS) can address the issues mentioned above.

• Data independence – Provides an abstract view of data in such a manner that applications are independent from how the data is physically stored.
• Efficient data access – Is crucial for optimizing performance, reducing latency, and ensuring smooth operations in databases and applications.
• Data integrity and security – Are essential for maintaining accurate, reliable, and protected information in databases and systems.
• Backup and Recovery Procedures – In a computer file-based system, the user creates the backup of data regularly to protect the valuable data from damage due to failures to the computer system or application program.
• Data administration – Centralized administration enables experienced DBMS administrators to manage data, tune the DBMS in accordance to its usage, and minimize data redundancy.
• Concurrent access and crash recovery – Enables concurrent accesses to data, thus two concurrent actions will not influence each other.
• Further, the DBMS has built-in fault tolerance and fault isolation that prevent further propagation of eventual failures or erroneous data.
• Controlling Data Redundancy – Is essential for maintaining efficiency, accuracy, and consistency in databases.
• Redundant data can lead to wasted storage, inconsistencies, and performance issues.
• Sharing of Data – Is the process of making data accessible to multiple users, applications, or organizations while ensuring security and integrity.
• It plays a crucial role in collaboration, decision-making, and innovation.
• Integration of Data – Is the process of combining data from multiple sources into a unified, coherent format for analysis, decision-making, and operational efficiency.
• It helps organizations eliminate data silos and inconsistencies, ensuring seamless access to information.
• Integration Constraints – Integrity constraints or consistency rules can be applied to database so that the correct data can be entered into database.

SPECIFIC OUTCOME 2

Describe commonly implemented features of commercial database management systems.

Commonly implemented features of commercial database management systems.

A typical DBMS has the following features

• Provides a way to structure data as records, tables, or objects
•  Accepts data input from operators and stores that data for later retrieval
• •Provides query languages for searching, sorting, reporting, and other “decision support” activities that help users correlate and make sense of collected data 
• Provides multiuser access to data, along with security features that prevent some users from viewing and/or changing certain types of information
•  Provides data integrity features that prevent more than one user from accessing and changing the same information simultaneously
• Provides a data dictionary (metadata) that describes the structure of the database, related files, and record information
• Represents complex relationship between data
•  Controls data redundancy. 
• Enforces user defined rules.
• Ensures data sharing. 
• It has automatic and intelligent backup and recovery procedures.
•  It has central dictionary to store information.

SPECIFIC OUTCOME 3

Describe different type of DBMS`s.

The various database management systems based on these data models are

SPECIFIC OUTCOME 4

Review DBMS end-user tools

• End-user tools in Database Management Systems (DBMS) help users interact with databases efficiently, whether for querying, reporting, or administration.
• A Federated Database System (FDBS) is a type of meta-database management system that integrates multiple autonomous databases into a single, unified system while allowing each database to maintain its independence.
• Real-time databases process transactions fast enough for the result to come back and be acted on right away.
• A terminology-oriented database builds upon an object-oriented database, often customized for a specific field.
• A knowledge database is a special kind of database for knowledge management, providing the means for the computerized collection, organization, and retrieval of knowledge.

Relationship between Visual Database Tools and Databases

Visual database tools and databases have a symbiotic relationship in data management. Visual database tools provide graphical interfaces that allow users to interact with databases without needing to write complex SQL queries. They enhance usability, making database management more intuitive.

Databases, on the other hand, store and manage structured data efficiently. They function as the backbone of various applications, handling data storage, retrieval, and processing. Visual database tools act as a bridge between users and databases, offering an intuitive and accessible way to manage data, design schemas, and optimize database performance.