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 Determine Magnetic Flux Density?
The magnetic flux density is the measure of amount of magnetic flux in each square meter of the magnetic field. Therefore, the magnetic flux density is defined as the magnetic flux passing normally (at 90°) per unit area and is denoted by B, i.e., Magnetic flux density, $$B=\frac{\phi}{A}$$Where, Φ is the magnetic flux, A is area normal (or perpendicular) to flux.The magnetic flux density is a vector quantity i.e. it possesses both magnitude and direction.Unit of Magnetic Flux DensityAs we know, the magnetic flux density is$$B=\frac{\phi}{A}=\frac{Weber}{meter^{2}}=Wb/m^{2}=Tesla(T)$$Therefore, the magnetic flux density is measured 𝑊𝑏/𝑚2 or Tesla (T), named in honour of Nikola ...
Read MoreHow to Calculate the Capacitance of Different Types of Capacitors?
Capacitance - DefinitionThe ability of a capacitor to store charge is known as its capacitance. In other word, the capacitance can also be defined as the property of a material by virtue of it opposes the any change in voltage applied across it.Capacitance: FormulaExperimentally, it has been found that, the charge Q stored in a capacitor is directly proportional to the voltage across it, i.e.$$Q\propto\:V$$$$Q=CV$$Where, C is a constant and is called as capacitance of the capacitor.$$\Rightarrow\:C=\frac{Q}{V}$$Thus, the capacitance (C) of a capacitor can also be defined as the ratio of the charge on the either plate to the voltage ...
Read MoreElectromechanical Relays – Types and Working Principle
Electromechanical RelayAn electromechanical relay is a type of relay which function using a magnetic field produced by an electromagnetic coil when a control signal is applied to it. It is called as electromechanical since it has moving contacts in the output circuit which are operated by applying an electrical signal.Electromechanical Relay: Working PrincipleAn electromechanical relay transfers signals between its contacts through a mechanical movement. It has three sections viz. input section, control section and output section.The input section consists of input terminals where a small control signal is to be applied. The control section has an electromagnetic coil which gets energised ...
Read MoreExplain Mapping the ER diagrams with binary and ternary relationships(DBMS)?
It is the relationship between the instances of two different entity types. Two entities will participate in the relationship.ExamplePerson and events are two different entity types which are related by using the relationship called “attends”.Mapping ER diagram with binary relationshipMapping one to many relationshipExampleHere, Create two tables for two entities.Primary key of one side relation is a foreign key for many side relations.One side relation is customer and many side relations is Order.The primary key cutomerID of the customer is a foreign key of order.The equivalent relations for the above ER diagram are as follows −One-one, many-one, many-many can be ...
Read MoreWhat is a composite attribute in DBMS?
The attributes that cannot be divided into sub-parts are called simple attributes. The attributes which can be divided into sub-parts are called composite attributes.ExampleBalance, account number are simple attributesName, address is called composite attributesLet’s consider an example of how to convert Entity Relationship (ER) model of composite attribute to Relational model.Methods for mappingName of relation = Entity set of ER diagramName of column = Attribute of ER diagramExampleIn this example, Name of the relation =studentName of columns=StdID, name, BranchThe equivalent relation for the above ER diagram is −StudentStdIDNameBranchNow apply this technique for Mapping ER diagram with a composite attribute as ...
Read MoreExplain the concept of key attributes with an example in DBMS?
Key is a data item which is used to identify a record or a value used to identify a record in a database is called a key. It helps uniquely to identify an entity from an entity set.Key allows us to identify a set of attributes that make it sufficient to distinguish entities from each other.ExampleAccount number, employee number, customer number are used as key fields because they specifically identify a record stored in a database.Different types of keysThe different types of keys in the database management system (DBMS) are as follows −Primary keySuper keyCandidate keyAlternate keyArtificial keyForeign keyPrimary, super, ...
Read MoreWhat is the degree of relationship set in DBMS?
The number of entity types which took part in the entity relationship is called the degree of relationships.There are three different types of degree of relationships, they are as follows −Unary relationshipBinary relationshipTernary relationshipUnary relationshipIt is the relationship between the instances of a single entity type. It is also called a recursive relationship.ExampleA person is married is a one-to-one relationship between the instances of Person entity type of unary relationship.Binary relationshipIt is the relationship between the instances of two different entity types. Two entities will participate in the relationship.For ExamplePerson and events are two different entity types which are related ...
Read MoreExplain the cardinality concept in DBMS?
In the view of databases, cardinality refers to the uniqueness of data values that are contained in a column. High cardinality is nothing but the column contains a large percentage of totally unique values. Low cardinality is nothing but the column which has a lot of “repeats” in its data range.Cardinality between the tables can be of type one-to-one, many-to-one or many-to-many.Mapping CardinalityIt is expressed as the number of entities to which another entity can be associated via a relationship set.For binary relationship set there are entity set A and B then the mapping cardinality can be one of the ...
Read MoreWhat are constraints on ER model in DBMS?
Constraints are used for modeling limitations on the relations between entities.There are two types of constraints on the Entity Relationship (ER) model −Mapping cardinality or cardinality ratio.Participation constraints.Mapping CardinalityIt is expressed as the number of entities to which another entity can be associated via a relationship set.For the binary relationship set there are entity set A and B then the mapping cardinality can be one of the following −One-to-oneOne-to-manyMany-to-oneMany-to-manyOne-to-one relationshipAn entity set A is associated with at most one entity in B and an entity in B is associated with at most one entity in A.One-to-many relationshipAn entity set A ...
Read MoreDifferentiate between the three models on the basis of features and operations(DBMS)?
A database model is a logical structure of a database, which contains the relationships and constraints that determine about how data is stored and accessed. The individual database models are designed based on the rules and concepts. Most data models can be represented by an accompanying database diagram.Types of database modelsThere are so many database models, but most used database models are −Hierarchical database modelRelational modelNetwork modelObject-oriented database modelThe major differences between the hierarchical, network and the relational models are as follows −Hierarchical ModelNetwork ModelRelational ModelOne to many or one to one relationship.Allowed the network mode to support many to ...
Read More