Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to get the max/min of visible cells only in Excel?
Maximum values simply mean the highest data value, and minimum data value contains the least available data values. In this article, the user will learn two ways such as by using the subtotal method to calculate the max and min values, and another possible way is by using kutool to perform the same task. Please understand that both features are already provided by the Excel application software and the user only requires to use the available option, to achieve the possible results. Example 1: To obtain the maximum and minimum value from the visible cell in Excel by using ...
Read MoreHow to get the cell value based on row and column numbers in Excel?
In the article user will understand the process of generating a cell value by utilizing the row and column numbers in excel. The main purpose of the article is to describe two simple ways to solve the provided task. In the first example, an already defined formula is used, that is by utilizing the INDIRECT value, user can generate the required result. On the other hand, the second example is generating the same cell value by using the VBA code. After writing the VBA code, the user needs to generate a function call from a provided method. Example 1: ...
Read MoreHow to create a button which belongs to one or more forms in HTML5?
The form attribute of the HTML tag allows us to create buttons of this type that are applicable to multiple forms. The button's id can be specified using this attribute, which is helpful for initiating form submission or carrying out other form-related operations. Using a single button that is part of multiple forms prevents us from having to repeat the same button in each form. We can handle the data from each form's associated button at once by associating a button with multiple forms. Processing the data is made simpler as a result. The user experience can be enhanced ...
Read MoreHow to create a simple map using JQuery?
JQuery is a well-liked interactive component in the JavaScript library that makes it easier to create online web apps. It can be made interactive with plugins and is simple and configurable. It is the best option for producing simplistic maps that lack advanced capabilities because it is compatible with all popular web browsers. Additionally, it is the most used tool for creating google maps because a basic map can be quickly and easily created with jQuery to add visual appeal to your website and improve user experience. Approach - 1 Algorithm Step-1 Create your map's HTML. For this, you'll need ...
Read MoreObject Identity, and Objects versus Literals
DBMS supports object-oriented data. It ensures direct correspondence between real-world objects and their representations in the database. This correspondence ensures that objects retain their integrity and identity. It enables easy identification and manipulation. Object Data Management System (ODMS) assigns unique identity to each independent object stored in the database. This unique identity is implemented through a system-generated object identifier (OID). This OID serves as distinct value assigned to each object by the system. It is not visible to external users. However it is internally utilized by the system to ensure the unique identification of each object and to establish and ...
Read MoreOffset-Fetch in MS SQL Server
Offset-Fetch is feature in MS SQL Server. It helps to retrieve subset of rows from result set. It consists of two components: OFFSET and FETCH. The OFFSET clause specifies the number of rows to skip from the beginning of the result set. FETCH clause determines the number of rows to retrieve. Syntax SELECT column1, column2, ... FROM table ORDER BY column OFFSET {integer_value} {ROWS | ROWS ONLY} FETCH {FIRST | NEXT} {integer_value} {ROWS | ROWS ONLY} ONLY; Explanation of Syntax SELECT column1, column2, ...: Specifies the columns to be selected from the table. FROM table Specifies the table from ...
Read MoreOLAP Guidelines (Codd_s Rule)
OLAP (Online Analytical Processing) is data processing technique. It is used to query and analyze data. It analyze data in real time from multiple sources. In 1993, EF Codd introduced 12 rules for the relational database model for OLAP systems. These rules are known as "Codd’s rules". These rules serve as a guideline for the design and development of OLAP systems. In this article, we will explore these 12 rules developed by Codd. Codd’s rules These are 12 rules for OLAP systems, as proposed by E.F. Codd − Multidimensional Conceptual View OLAP system should provide multidimensional conceptual view of ...
Read MoreOther Primary File Organizations
Files of Mixed Records In DBMS, file organizations are designed to handle records of a single type. However, in most real-world applications, multiple types of entities are interconnected in various ways. To represent relationships among records in different files, fields are connected. For example, a STUDENT record may have a connecting field Major_dept, whose value gives the name of the DEPARTMENT in which the student is majoring. The Major_dept field refers to a DEPARTMENT entity, which should be represented by a record of its own in the DEPARTMENT file. Retrieving field values from two related records requires retrieving one of ...
Read MoreWhat is the Difference between Neurobiology and Physiology?
Introduction Neurobiology or Neuroscience is the scientific study of the nervous system (the brain, spinal cord, and peripheral nervous system), its functions and disorders. It is a multidisciplinary science that combines physiology, anatomy, molecular biology, developmental biology, cytology, psychology, physics, computer science, chemistry, medicine, statistics, and mathematical modeling to understand the fundamental and emergent properties of neurons, glia, and neural circuits. The scope of neuroscience has broadened over time to include different approaches used to study the nervous system at different scales. The techniques used by neuroscientists have expanded enormously, from molecular and cellular studies of individual neurons to imaging ...
Read MoreWhat is the Difference between Cloning and Molecular Biology?
Introduction Cloning is the process of producing similar populations of genetically identical individuals that occur in nature when organisms such as bacteria, fungi, insects, or plants reproduce asexually. Examples of such organisms are various trees such as hazel trees, blueberry plants, and the American sweetgum. Cloning in biotechnology refers to processes used to create copies of DNA fragments (molecular cloning), cells (cell cloning), or organisms. The term also refers to the production of multiple copies of a product such as digital media or software. Cloning can be natural or artificial. Examples of cloning that occur naturally are vegetative reproduction in ...
Read More