Simple and Composite Attributes || Lesson 7 || DBMS || Learning Monkey ||

Описание: Simple and Composite Attributes

In this class, we will understand Simple and Composite Attributes.

We have already discussed the definition of attributes.

Simple and Composite Attributes

An attribute is a property that describes an entity.

There are different types of attributes in this class; we discuss Simple and Composite Attributes.
Simple Attributes

If we cannot divide an attribute further is called a simple attribute.

if we consider the sex attribute, this cannot be further divided.

Similarly, we cannot divide the DoB attribute.
Composite attributes

The composite attributes are just opposite to the definition of simple attributes.

If we can divide an attribute into smaller subparts, they are called composite attributes.

If we consider the name and address attributes, we can divide them into subparts.

We can divide the name attribute into First Name, Middle Initial, and Last Name.

Similarly, we can divide the address attribute into Street name, Area name, District, City, State, and Country.

We can further divide the street name into door number and street name.
ER-Diagram Representation

How can we represent the simple and composite attributes in the ER-Diagram?

#learningmonkey #dbms #placements #gatecse #gatedbms #campusplacements


Link for playlists:
   / @wisdomerscse  


Link for our website: https://learningmonkey.in

Follow us on Facebook @   / learningmonkey  

Follow us on Instagram @   / learningmonkey1  

Follow us on Twitter @   / _learningmonkey  

Mail us @ [email protected]