Educational Blog

                From all the teachings from Ms. Sanchez, I've learned that database is an organized collection of data. And this collection can be easily accessed and managed. The database handler is able to organize the data into tables, rows, columns, and index it for convenience to finding relevant information.           The user makes a database that is accessible to all other users providing data using a set of software program. Database is mainly used  to store, retrieve and manage data through operating a vast amount of information.               Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation. The software is a popular spreadsheet system, which manages data using columns and rows along with the formulas that allow the software to put mathematical function to the data inside the spreadsheet. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA) in order for

     The DBMS consists of five functions. Data definition, data manipulation, data security and integrity, data recovery and concurrency and data dictionary. Data definition is the first thing we do when structuring our databases. We will proceed first with our design view, we put the field name, data type or data format together with the record structure and file structure. Data definition's function is to put clearly defined data within our databases. After data definition, data manipulation comes in. Data manipulation already has the three major operations: add, edit or delete that basically gives you freedom to do whatever you want with the data. Data security and integrity has the function to secure your data with the connection of one entity to another through using the primary key or the ID. Data recovery and concurrency deals with the capability of recovering the data which is also known as data back-up. Lastly, the data dictionary. The data dictionary focuses on the record