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.


  

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...