Information Management Blog 2

  SQL is a comprehensive language that has its own DDL and DML components: A.  DATA DEFINITION LANGUAGE Data Definition Language ( DDL ) is used to provide commands for defining relation schemes, deleting relations, and creating indices, among others.  DDL is also used to specify additional properties of the data. The storage structure and access methods used by the database system by a set of statements in a special type of DDL called a data storage and definition language. These statements define the implementation details of the database schema, which are usually hidden from the users. The data values stored in the database must satisfy certain consistency constraints.    DATA MANIPULATION LANGUAGE The SQL commands that deal  with the manipulation of data present in the database belong to DML or Data Manipulation Language and this includes most of the SQL statements. It is the component of the SQL statement that controls access to data and to the ...

  What is a Database? A database allows you to store information related to a specific topic in an organized way. You can sort, extract, and summarize data-related information in addition to storing the data itself. Microsoft Office Access, a database program, is among the software tools that enable you to achieve this program for production and administration. What type of Software is Microsoft Office Excel? Excel is a  spreadsheet software   program that is  traditionally used to   manage numerical  information graphic tools, and pivot tables. What Type of Software is Microsoft Office Access? Access is called a  relational database  management  program, because the  tables are linked, or  related .  The real power of Access comes in being able  to link and extract information from multiple  tables to answer specific questions. Differences between Access and Excel The main difference between Excel and ...