what is SQL? SQL stands for Structured Query Language, as it is the special purpose domain specific language for querying data in Relational Database Management System (RDBMS).
The term “Data Warehouse” was first coined by Bill Inmon in 1990. According to Inmon, a data Warehouse is a subject oriented, integrated, time-variant, and non-volatile collection of data. This data helps analysts to take informed decisions in an organization. A data warehouses provides us generalized and consolidated data in multidimensional view Along with generalized […]
Social justice is justice in terms of the distribution of wealth, opportunities and privileges within s society. justice means truth, morality, equality, fairness and mercy. Social Justice concerns obligation of individual to community and its end of the common good. components of social justice equitable society, distribution of profit/loss without prejudice. healthy social relation, participation […]
Comparison Centralized database Distributed database Meaning The relation of powers and authority with relevance planning and decisions, with the highest management, is understood as centralization. The dissemination of authority, responsibility and accountability to the assorted management levels is understood as decentralization. involves Systematic and consistent reservation of authority Systematic dispersal of authority Communication flow Vertical Purely Open & free […]
MS-Access is a DBMS that helps to create, update, Modify and delete database file. It is a complete database package of MS-Office developed by Microsoft Corporation. It is a software system provides the operating interfaces to manage the database file. It provides record management features for addition, deletion, modification of records on the database. Followings […]
Database management system is a software which defines a database, stores the data, supports query language, generates reports and creates screens for data entry. The collection of software is also known as DBMS to make it easier for the user to manage, build, delete and modify their data in a data base. MS-Access, MySQL, SQL […]
A database is a set of data that is stored in a structured format, designed for multiple users to access. The database is designed to handle a wide variety of data. Data management requires both the concept of the information storage system and the provision of data manipulation mechanisms. Examples of a database include a […]
Data mining is that the method of analyzing secret data trends from various viewpoints for categorizing into usable knowledge collected and installed in common locations, like data warehouses, for efficient research , data processing algorithms, enabling business decision-making and other information requirements to eventually reduce costs and increase revenue. Data mining is additionally called the exploration and development of information which suggests data discovery and knowledge discovery. […]