Posts

My blog2

Image
Hello everyone, and welcome to my second blog. So today I'm going to be discussing the function of a DBMS and then advantages and disadvantages of a DBMS So let's get started. First, the function of DBMS A Database Management System (DBMS) is used to store, organize, and manage data efficiently. It allows users to create and define databases, insert and update information, and retrieve data whenever needed. A DBMS also ensures data security by controlling access through passwords and permissions. It maintains data integrity by applying rules to keep the information accurate and consistent. In addition, it provides backup and recovery features to protect data from loss and allows multiple users to access the database at the same time without conflict. Now moving on to the advantages and disadvantages of DBMS The advantage of a DBMS is that it reduces data redundancy by storing information in a centralized system. It improves data consistency because any update made to the data i...

My blog

Image
Hello everyone, welcome to my first-ever blog. So today I'm going to talk about what a database is, what type of software Microsoft Office Excel and Microsoft Office Access are, and then the differences between Access and Excel.   first "What is a database?" -A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database. Data within the most common types of databases in operation today is typically modeled in rows and columns in a series of tables to make processing and data querying efficient. The data can then be easily accessed, managed, modified, updated, controlled, and organized. Most databases use structured query language (SQL) for writing and querying data. - A datab...