Posts

BLOGPOST MODULE 6

Image
 A. ENGAGE Instruction: Based on your own understanding, kindly define the following terminologies:  A.XML  XML, or Extensible Markup Language, is a flexible and widely used format for storing and exchanging structured data. It is a plain-text language that uses tags to define elements and their relationships, allowing for the representation of complex information. XML provides a way to store data in a human-readable and machine-readable format, making it easy to understand and process.  B.JSON  JSON or JavaScript Object Notation, It is a text-based format that allows for the representation of structured data in a human-readable manner. JSON is built on key-value pairs, where data is organized into objects and arrays. It is easy to understand and manipulate by both humans and machines. JSON is widely supported across different programming languages and platforms, making it ideal for data exchange between systems. It is commonly used in web APIs, where data is transmitted between the se

BLOGPOST MODULE 5

Image
 A. ENGAGE 1st Normal Form 2nd Normal Form 3rd Normal Form 4th Normal Form BOYCE - CODD Normal Form B. EXPLORE AND EXPLAIN 1st Normal Form 2nd Normal Form 3rd Normal Form 4th Normal Form BOYCE - CODD Normal Form C. ELABORATE AND EVALUATION Answer the following questions: Identification  1. Many to one relationship or one to many relationship.  2. Many to many relationship.  3. It is a method used to eliminate redundancy in data definitions, especially for relationship models.  4. No fields may depend on other non-key fields.  5. There should be no repeating groups in a table.  Answers: 1. 4th Normal Form 2. Boyce-Codd Normal Form 3. Normalization/Rules of Normal Form 4. 3rd Normal Form 5. First Normal Form

BLOGPOST MODULE 4

Image
 A. ENGAGE     A. WHAT IS SQL? SQL or Structured Query Language is a programming  language used to interact with and manage data stored in relational databases. It allows you to retrieve, add, modify, and delete data from these databases, as well as create and modify tables, indexes, and other database structures. SQL is widely used in businesses and organizations of all sizes to manage large amounts of data efficiently and effectively. It's an essential tool for data analysts, software developers, and anyone who needs to work with databases. B. EXPLORE AND EXPLAIN 1. What are some sql commands? Some sql commands are: Select     -      Used to retrieve data from one or more tables. Insert     -      Used to add new data to a table. Update   -      Used to modify existing data in a table. Delete     -      Used to remove data from a table. Create    -      Used to create new database objects, such as tables, views, and indexes. Alter         -      Used to modify the structure of an
Image
 A. ENGAGE Instruction: Based on your own understanding, kindly define the following terminologies:  A. DATA DEFINITION LANGUAGE  Data Definition (DDL) is capable of creating a framework for database by specifying the schema of the database. Its common uses include the creation and alteration of tables, indexes, files and columns within the database. B. INTERACTIVE DATA MANIPULATION LANGUAGE  Interactive Data Manipulation Language or IDML is designed to allow users to manipulate data in a specified database, specifying a series of commands on what to be executed by the database. C. EMBEDDED DATA MANIPULATION LANGUAGE Embedded Data Manipulation Language or EDML is typically embedded within another programming or scripting language and provides a set of commands that an be used to manipulate data structures and perform data analysis tasks. B. EXPLORE & EXPLAIN 1. What are the basic sql expression?  The basic sql expressions: SELECT to extract data from the database, UPDATE to update

BLOGPOST #2 (Laboratory)

Image
   A. ENGAGE  Sample pic of database icon. A.WHAT IS A DATABASE? Collection of information organized and presented to serve a specific purpose. It is a collection of data or information, database has the ability to store any data or information and organize it.  Databases are structured to facilitate the storage, retrieval, modification, and deletion of data in conjunction with various data-processing operations. B.WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL? Sample of Excel logo. Microsoft Office Excel is a very useful software for the users to organize and calculate data in a spreadsheet. Excel can be very helpful when we have too many information and data, by using Excel, we can easily organize and calculate all the data we have. C.WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS? Sample of Access logo      Microsoft Access can help us to build or databases quickly. Access  can help us on reporting, analysis and reference. We can manage data more efficiently and analyze large am

BLOGPOST #1 (Laboratory)

Image
CLASS EXPERIENCE     My class experience in Information Management 1 with our kind professor, Ms. Mayer Sanchez. As an introduction, I want to say that my experience from our class is so much far from bad or worst, why? because first of all, Ms. Mayer is one of the nicest teacher/professor I've encountered from my experience on being a student for a long time, She's not just kind, she's also very good at discussing our topic. She makes sure that all of her student understand what she's saying, not just that, she's very easy to approach. There's one thing I'd like to share about our professor, after our class session, she always say nice stuff before ending her class, saying that we should always be careful, may the God bless us, and more. It's so kind that this is the first time I've heard it from a teacher/professor.  I also like to include Ms. Mayer's idea where she wants us to make our activity in a form of blog. Her idea is good for us, so th

BLOGPOST #2 (Lecture)

Image
A. ENGAGE A. Functions of DBMS or  Database Management Systems DBMS or Data Management Systems can grant an access for multiple users to an specific database. DBMS can be very reliable nowadays because of many stuff like data security, storing and organizing data, protecting data integrity, backing up data and recovering it quickly and many many more capabilities that are very useful. what's more is about the consistency, database management systems can perform consistently without causing problems because it is achieved by establishing rules. Lots of businesses can increase their access to data, they can use it to track their records from the past and think of a best solution for their success and also to prevent them from their past mistakes. Here's and example of DBMS granting access to multiple users. B. Advantages of DBMS The advantages of Database Management Systems is that it specializes data sharing, data organizing and data security. DBMS's productivity is increase