DDL, INTERACTIVE DATA MANIPULATION LANGUAGE, AND EMBEDDED DATA MANIPULATION LANGUAGE

 


A. DATA DEFINITION LANGUAGE


    It is used to provide commands for defining relation schemes, deleting relations, and creating indices, among others. 

B. INTERACTIVE DATA MANIPULATION LANGUAGE


It can be used to insert, delete, and update tuples in a relation.

 

C. EMBEDDED DATA MANIPULATION LANGUAGE


 The embedded form of the DML is used to incorporate SQL statements into programs created using other programming languages.


Comments

Post a Comment

Popular posts from this blog

FUNCTIONS, ADVANTAGES, DISADVANTAGES OF DBMS

Image
  DATA DEFINITION In a DBMS, data is what's being dealt with and data definition is the ability to clearly define what is stored in the tables of a database. As an example, SQL is utilized in order to instruct how to store the data.    DATA MANIPULATION   This means that the existing data within a DBMS can be easily manipulated. Modification is easy as users can insert, delete and update their database. DATA SECURITY AND INTEGRITY Enhanced protection is ensured in a DBMS. It prevents any type of unauthorized access and data alteration. On the other hand, integrity is the validation and it helps maintain the overall accuracy of the system's structure. DATA RECOVERY AND CONCURRENCY   System failures can be unavoidable and DBMS has the ability to retrieve the lost data. Other than that, concurrency means that it can be accessed at the same time as multiple users can view it.  DATA DICTIONARY  A data dictionary primarily consists information regarding the ...
Read more

MY CLASS EXPERIENCE

Image
  In our information management subject, I learned a lot about databases, different diagrams models and how to use Microsoft Access. However, I think I would have understood the topics better if it were in a traditional, face to face classroom setting because it is difficult for me to grasp information at a quick pace. It was quite challenging to learn in this type of class environment since this method of learning is still new to me but given the situation that we are in as of the moment, we are left with no choice but to study online instead for the safety of the students and the instructors. Dilemmas were faced during class as technical difficulties are unavoidable and it is understandable because everyone is still trying to get used to online classes. Just like everyone, I also experienced these as sometimes I had internet connectivity problems and it would be stressful on my part as it would hinder me from entering class and passing requirements on time. I look forward to atta...
Read more

XML, JSON, AND AJAX!

Image
    A. XML  WHAT IS XML?      Extensible Markup Language ( XML ) is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. The World Wide Web Consortium's  XML  1.0 Specification of 1998 and several other related specifications—all of them free open standards—define  XML . B. JSON WHAT IS JSON?      JSON is an open standard file format and data interchange format that uses human-readable text to store and transmit data objects consisting of attribute-value pairs and arrays. It is a very common data format, with a diverse range of applications, one example being web applications that communicate with a server.  C. AJAX WHAT IS AJAX?      AJAX is a set of web development techniques using many web technologies on the client side to create asynchronous web applications. With AJAX, web applications can send and retrieve data from a server...
Read more