Wednesday, June 2, 2021

what is XML, JSON and AJAX

  A. XML

The XML (Extensible Markup Language) markup language provides a set of rules for encoding documents in a human- and machine-readable format. Unlike HTML components, which are used to display data, XML is used to store and organize data rather than specifying how it should be shown.


B.JSON

JSON (JavaScript Object Notation) is a simple data communication format. Humans find it simple to read and write. Machines can easily parse and make it. When data is sent from a server to a web page, this term is commonly used.


C.AJAX

AJAX (Asynchronous JavaScript and XML) is a set of client-side web development techniques for developing asynchronous online applications. Ajax may be used by web applications to send and receive data from a database.

Sunday, March 28, 2021

DATA LANGUAGES

 What is DDL?

-A DDL is a language that is used to describe data structures and modify data.

What is Interactive Data Manipulation Language?


-IDML is used where users can browse and restore database contents using a data manipulation language in both immersive and embedded (in a host programming language) modes.

What is Embedded Data Manipulation Language?

-Embedded Data Manipulation Language is a way of integrating a programming language's processing ability with SQL's database manipulation capability.







Monday, March 1, 2021

DATABASE

 


A. What is a database?

A database is a logically ordered set of data that is usually collected and retrieved electronically by a computer system. Where databases are more complicated, systematic architecture and simulation methods are commonly used.

  B. What type of software is Microsoft Office Excel?

Spreadsheet Tools

Microsoft Excel is spreadsheet software that is part of the Microsoft Office suite. Spreadsheets are rows and columns of values that can be manipulated mathematically using both simple and complex arithmetic operations and functions.

C. What type of software is Microsoft Office Access?

Microsoft Access is a database management system (DBMS) from Microsoft that integrates a graphical user interface and software development tools with the relational Microsoft Jet Database Engine.

D. Think of at least two differences between access and excel.

The main difference between Excel and Access is that Excel is a spreadsheet to perform calculations and to represent data visually, while Access is a Database Management System that helps store and manage data easily


 

DBMS




A.  Function of DBMS

      For me, A DBMS's role is to arrange and gather data. It helps the company or an individual to organize their data and information. And also, DBMS is one of the most important systems in the world, small or big company uses DBMS for the databases they have.

B. Advantages of DBMS

     It improves data sharing, Minimized data inconsistency, Improved data access, Improved decision making, and also creates Better data integration.

The database management system (DBMS) assists in the development of an ecosystem in which end users have greater access to more and better-managed data.

End users can adapt easily to changes in their environment with this kind of access.


C. Disadvantages of DBMS

   For me, the Disadvantages of DBMS are the Increase in Costs, Database Failure, and Huge Size.

      Any organization's data is crucial; if data is destroyed, the whole organization will fail. Since all files in a DBMS are stored in a single directory, the chances of a database loss increase. 

      A database is very important, but it is not easy to achieve, you need to pay more because a good DBMS requires a large budget for a good result.


  

Sunday, February 14, 2021

My Experience in Information Management 1

        Good day everyone, my name is Ariel Yandan, 19 years old and currently studying at Gordon College, I live in Dinalupihan, Bataan.

         Information Management is one of the most helpful subjects because it will help you to know more about databases, information and etc. Our professor teaches us how ERD or Entity-Relation Diagram works. Here is the example of ERD:


       The first day of Second Semester classes is full of joy, new teachers, friends, and classmates. Information Management 1 professor Mayer Sanchez or we can call her Ma'am Yeng, she is kind and always asking us if we are okay. For me, Information Management is not an easy subject because the topics discussed are not familiar. Sometimes, internet connection ruins our online class. 


      My Information Management 1 class and other classes experiences are full of joy and new learnings about the technology today. This is my first time having this subject, last week we had lots of discussion about databases and other topics that Ma'am Yeng need to discuss on our subject.

     I hope that my joyful experience in Information Management 1 will continue until this second-semester end. 

what is XML, JSON and AJAX

  A.  XML The XML (Extensible Markup Language) markup language provides a set of rules for encoding documents in a human- and machine-readab...