Ricky Barnes has Published 127 Articles

DDBMS Components

Ricky Barnes

Ricky Barnes

Updated on 20-Jun-2020 08:48:53

3K+ Views

The contents of a distributed database are spread across multiple locations. That means the contents may be stored in different systems that are located in the same place or geographically far away. However, the database still appears uniform to the users i.e the fact that the database is stored at ... Read More

Converting E-R model into relational model

Ricky Barnes

Ricky Barnes

Updated on 19-Jun-2020 08:03:35

4K+ Views

A given ER model can be converted into Relational model. A Relational model includes Relations, Tuples, Attributes, Keys, and Foreign keys.Relation is a table made from tuples.A Tuple is a row of data.An Attribute is a characteristic of the relation.There is a direct mapping between ER model and Relational model.Consider ... Read More

Generalization, Specialization and Aggregation in ER Model

Ricky Barnes

Ricky Barnes

Updated on 19-Jun-2020 08:02:26

11K+ Views

GeneralizationGeneralization is a process of generalizing an entity which contains generalized attributes or properties of generalized entities. The entity that is created will contain the common features. Generalization is a Bottom up process.We can have three sub entities as Car, Truck, Motorcycle and these three  entities can be generalized into ... Read More

Database Management System (DBMS)

Ricky Barnes

Ricky Barnes

Updated on 19-Jun-2020 08:01:50

5K+ Views

A Database Management System is defined as the software system that allows users to define, create, maintain and control access to the database.A DBMS makes it possible for end users to create, read, update and delete data in database. It is a layer between programs and data.Applications and Users access ... Read More

CODD’s Twelve Rules of Relational Database

Ricky Barnes

Ricky Barnes

Updated on 19-Jun-2020 07:53:32

3K+ Views

Edgar F Codd was a Computer Scientist who invented the Relational model for Database management. He is also credited with creating the foundation for relational databases as well as relational database management systems.Codd’s twelve rules define the characteristics required by a database management system to be considered relational i.e  a ... Read More

Data Definition Commands in DBMS

Ricky Barnes

Ricky Barnes

Updated on 19-Jun-2020 07:50:15

4K+ Views

Data definition commands are used to create, modify and remove database objects such as schemas, tables, views, indexes etc.Common Data Definition commands −CreateThe main use of create command is to create a new table in database. It has a predefined syntax in which we specify the columns and their respective ... Read More

Bootstrap 4 .flex-*-column class

Ricky Barnes

Ricky Barnes

Updated on 18-Jun-2020 14:02:51

319 Views

Use the .flex-*- column class in Bootstrap to show flex items vertically on different screen sizes:Set it vertically on small, medium, large, etc screen size. Let us see it on small and medium screen size:Small Screen SizeFlex on different screen size (Small)   One   Two   Three Medium ... Read More

border-top-0 class in Bootstrap 4

Ricky Barnes

Ricky Barnes

Updated on 18-Jun-2020 14:00:57

217 Views

Use the border-top-0 class in Bootstrap 4 to remove the top border.Set the border-top-0 class −   Rectangle is missing the TOP border. Let us see an example to implement the border-top-0 class −ExampleLive Demo       Bootstrap Example             ... Read More

Set orange border on an element in Bootstrap to indicate danger

Ricky Barnes

Ricky Barnes

Updated on 18-Jun-2020 13:57:46

134 Views

To set orange border to an element, use the border-warning class −   Danger (Orange border) Set the style for the element − .mystyle {   width: 200px;   height: 100px;   margin: 10px; } Let us see an example to implement the border-warning class in Bootstrap −ExampleLive Demo ... Read More

Set a white border to an element in Bootstrap

Ricky Barnes

Ricky Barnes

Updated on 18-Jun-2020 13:56:01

80 Views

Use the border-white class in Bootstrap 4 to set white border to an element.   This has white border The test class above styles the element as shown below − .test {   width: 120px;   height: 100px;   margin: 10px;   background: blue; } Let us see an example ... Read More

Advertisements