Amit Diwan has Published 103 Articles

Bootstrap 4 .rounded-circle class

Amit Diwan

Amit Diwan

Updated on 15-Jun-2020 16:37:19

8K+ Views

To create a rounded circle with Bootstrap, use the rounded-circle class.Add the rounded-circle class in the Above, we also have a test class, which is a CSS class to style the circle −.test {   width: 270px;   height: 320px;   background-color: yellow; }You can try to run the ... Read More

Bootstrap 4 .card-text class

Amit Diwan

Amit Diwan

Updated on 15-Jun-2020 16:31:04

265 Views

Use the card-text class in Bootstrap to set text in a card. Add this class in your web page  by including it as any other class in an element, for example, tag in the below given code snippet −   Demo text in a card The text in the ... Read More

RDBMS terminologies

Amit Diwan

Amit Diwan

Updated on 15-Jun-2020 14:23:10

8K+ Views

RDMS Terminologies include Database, Table, Columns, etc. Let us see them one by one −DatabaseDatabase is a collection of tables like , , etc.TableA table is a collection of rows and columns , for example, StudentIdStudentNameStudentRank052Tom1035David2077John3ColumnColumn is in a table −RowRow is also called a tuple in RDBMS. A relation in ... Read More

Alternate Key in RDBMS

Amit Diwan

Amit Diwan

Updated on 15-Jun-2020 14:21:14

4K+ Views

Alternate Key or Secondary Key is the key that has not been selected to be the primary key, but are candidate keys. However, it is considered a candidate key for the primary key.A candidate key not selected as a primary key is called alternate or secondary key. Candidate key is ... Read More

Sixth Normal Form (6NF)

Amit Diwan

Amit Diwan

Updated on 15-Jun-2020 14:18:09

4K+ Views

In 6NF, the relation variable is decomposed into irreducible components. A relation is in 6NF, only if, It is in 5NF, and every join dependency on the relation is trivialLet us see an example −Enrollment_NoNameMarksThe possible join dependencies for the above would be −{Enrollment_No, Marks}{Enrollment_No, Name}In Sixth Normal Form (6NF), ... Read More

Domain-Key Normal Form

Amit Diwan

Amit Diwan

Updated on 15-Jun-2020 13:36:08

5K+ Views

A relation is in DKNF when insertion or delete anomalies are not present in the database. Domain-Key Normal Form is the highest form of Normalization. The reason is that the insertion and updation anomalies are removed. The constraints are verified by the domain and key constraints.A table is in Domain-Key ... Read More

Secondary Key in RDBMS

Amit Diwan

Amit Diwan

Updated on 15-Jun-2020 13:35:00

6K+ Views

What is a Secondary KeySecondary Key is the key that has not been selected to be the primary key. However, it is considered a candidate key for the primary key.Therefore, a candidate key not selected as a primary key is called secondary key. Candidate key is an attribute or set ... Read More

How to identify entity from a given problem

Amit Diwan

Amit Diwan

Updated on 15-Jun-2020 13:15:39

3K+ Views

Entity in DBMS can be a real-world object with an existence. To identify entity from a given problem, follow the below given tips −Under the problem description, try to find the entity.Search for nouns, like Teacher, Doctor, etc.Classify nouns to get a wider picture about the entities.Read the problem description ... Read More

Fifth Normal Form (5NF)

Amit Diwan

Amit Diwan

Updated on 15-Jun-2020 13:06:18

17K+ Views

The 5NF (Fifth Normal Form) is also known as project-join normal form. A relation is in Fifth Normal Form (5NF), if it is in 4NF, and won’t have lossless decomposition into smaller tables.You can also consider that a relation is in 5NF, if the candidate key implies every join dependency ... Read More

Fully-functional dependency in DBMS

Amit Diwan

Amit Diwan

Updated on 15-Jun-2020 12:56:07

13K+ Views

An attribute is fully functional dependent on another attribute, if it is Functionally Dependent on that attribute and not on any of its proper subset.For example, an attribute Q is fully functional dependent on another attribute P, if it is Functionally Dependent on P and not on any of the ... Read More

Advertisements