**********************************************************************************


WHAT IS SQL?

SQL stands for Structured Query Language is the standard means of manipulating and querying data in relational databases, though with proprietary extensions among the products. 





Comments

Post a Comment

Popular posts from this blog

Proper Installation of Operating Systems

Image
 *********************************************************************************                                                              Proper Installation of Operating Systems           This Hierarchical Model used  Proper installation of Operating System data where in the model in the lower levels are sorted under a hierarchy of successively higher-level units. The  Proper installation of Operating System data are grouped into clusters at one or more levels, and the influence of the clusters on the data points contained in the datas from the installation of OS into a computer is taken account for the other statistical analysis. In this example, the top-most of the heirarchy table is the  Proper installation of Operating System, therefore it is where t...
Read more

What type of software is Microsoft office Access?

Image
 ********************************************************************************* What type of software is Microsoft office Access? MS Access is a database software application that is present in MS Office Package bundle. It is like MySQL, MongoDB, NoSQL used for storage of records in databases. It is simple and easy to use and maintain. Also allows both graphical interface for queries and the coding view for queries. It is commonly used to keep the databases that a program uses separate from the program so that each can be upgraded individually. Also, so that multiple apps on different platforms can access the data.
Read more

Functions of DBMS

Image
 ********************************************************************************** A     Functions of DBMS ·          Data Dictionary Management -   Data Dictionary is where the DBMS stores definitions of the data elements and their relationships (metadata).    The DBMS uses this function to look up the required data component structures and relationships. When programs access data in a database they are basically going through the DBMS. This function removes structural and data dependency and provides the user with data abstraction. In turn, this makes things a lot easier on the end user. The Data Dictionary is often hidden from the user and is used by Database Administrators and Programmers.   ·          Data Storage Management - This particular function is used for the storage of data and any related data entry forms or screen definitions, report definition...
Read more