Information Management Blog Activity

 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

 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

 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