Charyll's Blog

Software is everywhere in the modern digital world and powers virtually everything we use today online, from apps on our phones to computer systems. However, How is this software developed? This is where Software Engineering helps. Designing and implementing quality software keeping in mind its ease of use. That's a process that software engineers follow to take our ideas and turn them into actual reality, ensuring they're the right versions we need and run well enough in real world. WHAT IS A SOFTWARE? SOFTWARE is a bundle of processors and information that tells a computer what to do, including software apps and operating system. Categories: System Software: It comprises the operating system (OS) versions, such as Windows, macOS or Linux and utility programs assistance to operate hardware components. Application Software– Typically, this is a set of programs that are designed for end-users by which they can perform various tasks like word processing, web browsing or gaming i....

Not who actually. JSON, or JavaScript Object Notation , is a lightweight format used for data exchange in web apps. It's easy to read and write for humans and can be parsed and generated by machines. JSON represents data using key-value pairs, arrays, and nested objects, making it popular in web development. It's widely supported by programming languages and frameworks, and its simplicity and compactness make it efficient for storing and serializing data. XML, or eXtensible Markup Language , is a markup language that encodes documents in a readable format for humans and machines. It uses tags to define elements and structures, allowing for complex data hierarchies. XML is commonly used in various domains for data representation and configuration files. It offers flexibility and supports features like namespaces and schemas for document validation, facilitating structured data exchange across systems and platforms. AJAX, or Asynchronous JavaScript and XML , is a web development ...

What SQL really is?  SQL, which stands for Structured Query Language, is a powerful programming language designed specifically for managing and manipulating relational databases. It allow users to efficiently store, retrieve, and modify data by providing a standardized approach for interacting with databases. At its core, SQL comprises a set of commands that enable users to communicate with a database. These commands perform various operations, including creating and modifying database structures, inserting, updating, and deleting data, and retrieving information through queries. One of the key strengths of SQL lies in its ability to handle data effectively. Using its data definition language (DDL) statements, it allows users to define the structure of a database, including tables, columns, data types, and constraints. By specifying these details, users can ensure the integrity of the data and enforce rules for data storage. On the other hand, SQL's data manipulation language (DML)...

SQL Statements DATA DEFINITION LANGUAGE Data definition language is also known as data description language  as it describes the fields and records in a database table and  define changes in the database schema. DDL  is  a subset of SQL or Structured Query Language which  implements database modifications.  DDL commands are used for altering the database structure such as creating new tables or objects along with all their attributes (data type, table name, etc.). DATA MANIPULATION LANGUAGE Data Manipulation Language or DML is a subset of operations used to insert, delete, and update data in a database. It is a sublanguage of SQL as it comprises some of the operators in the language. Selecting read-only data is closely related and is sometimes also considered a component of a DML, as some users can perform both read and write selection. EMBEDDED DATA MANIPULATION LANGUAGE Also known as Embedded SQL  is a method of combining the  computing ...

After the first semester, I get to relaxed myself for a few days. Thinking back at times I get very stressed in school taking a lot of pressure, I think it was really worth it naman because I get to be in the dean's lister yey! Now, second semester midterm exam is nearly behind. Also, lots of responsibilities comes up that overwhelm me shortly but I've been doing my best to do it responsibly and manageably. For me studying is not that hard, although some of my subjects are not that easy, still I can manage to learn efficiently. I'm gonna share my experience with our Information Management 1 class, our professor was Ma'am Meyer–she was nice and teaches us very good. Our classes shift from face-to-face to online learning every week, alternately. This subject is awesome, it gives us a review about our previous learnings and also teaches us new lessons which are related to managing information. When it comes to submission of activities through online platforms, I always man...

WHAT ARE THE FUNCTIONS OF DBMS? DATA DEFINITION - it accepts data definitions(external, internal and conceptual schemas, and all associated mappings) in source form and convert to the appropriate object form. DATA MANIPULATION - it handle request from the user to retrieve and update existing data or to add a new data to the database. DATA SECURITY AND INTEGRITY - it monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator. DATA RECOVERY AND CONCURRENCY - it has the capability to recover from, or minimize the effects of a system crash. DATA DICTIONARY - it provide a system database called the database dictionary. WHAT ARE THE PROS OF DBMS? REDUCED DATA REDUNDANCY - data redundancy is avoided by keeping a single copy of the data. DATA INTEGRITY - since a single copy of a particular data is stored in the database, you can be certain that the changes to the data will be reflected in all future uses of that data. ...

INTRODUCING : EXCEL & ACCESS WHAT IS A DATABASE?  It is a collection of information organized and presented to serve a specific purpose. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL ?  Microsoft Excel is a spreadsheet that features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA).  WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS?  Microsoft Access is a database management system (DBMS) that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. WHAT ARE THE DIFFERENCES BETWEEN ACCESS AND EXCEL? Excel is a spreadsheet software program that is traditionally used to manage numerical information, it is used to build models for analyzing data, write simple and complex formulas to perform calculation and present data in a variety of charts. Meanwhile Access is an RDBMS program that can link and extract info...