0:02
[Music]
0:12
hello friends welcome back to our
0:13
channel so in today's session we'll
0:15
discuss about one more concept in dbms
0:17
that is attributes and its types
0:25
so first let us see what is an attribute
0:27
so an attribute
0:29
is
0:34
properties
0:38
or characteristics
0:44
that describes an entity
0:53
so this is called an attribute for
0:54
example consider an entity
0:57
consider an entity
1:00
as a student
1:02
student
1:03
now the attributes
1:08
are
1:09
first one
1:11
a roll number which describes the edited
1:13
student
1:15
name
1:20
gender
1:21
etcetera etcetera everything comes under
1:22
the attributes of this particular
1:25
student entity
1:27
right so now you got a clarity about
1:30
what is an attribute so it it give it is
1:32
nothing but a properties or a
1:34
characteristics that describes an
1:37
entity right so usually in our
1:39
relational database management system we
1:41
call these attributes as a columns okay
1:44
because in the rdbms we are representing
1:46
the data in terms of rows and columns so
1:49
the columns we call it as a attributes
1:52
and rows we call it as an entities
1:54
so
1:55
the properties that describes the
1:57
particular entity are called as an
1:59
attribute
2:00
now
2:01
we will see what are the different types
2:02
of attributes
2:04
what are the different types of
2:05
attributes
2:07
so types
2:09
of attributes
2:13
the first one
2:19
composite attribute
2:24
composite attribute
2:26
so what is the composite attribute
2:28
and this attribute
2:40
so an attribute
2:43
which can be
2:46
divided
2:49
further
2:54
to form
2:56
an independent attributes
3:01
independent
3:02
attributes is called composite attribute
3:05
that means if you consider any one
3:07
attribute and if you can divide that
3:10
particular attribute into further parts
3:13
supports which makes each subpart as an
3:16
individual attribute so that we call it
3:18
as a composite attribute okay which can
3:21
be divided into subparts for example
3:27
example for this composite
3:30
if you consider name
3:32
name is an adjective
3:34
name is a attribute right so if you
3:36
consider the entity student so name is
3:39
one attribute of a student right so name
3:42
can be further divided as
3:46
first name
3:53
middle name
3:57
last name
3:59
right and again these are individual
4:01
attributes these are the individual
4:03
attributes so the name can be further
4:06
divided into different
4:08
parts the subparts
4:10
okay so this we can say it has a
4:13
composite attribute so the attribute
4:16
which can be divided further
4:18
okay
4:19
then
4:20
the next one so this is a composite
4:22
attribute the next one is a simple or
4:26
atomic attribute
4:29
simple or atomic attribute
4:35
simple
4:37
or
4:40
atomic
4:43
attribute
4:44
so here
4:45
an attribute
4:50
which cannot be divided further
5:00
which cannot be divided further is known
5:02
as a simple or atomic attribute so which
5:05
cannot be divided right so
5:08
for this example was
5:11
if you consider the student entity so
5:14
roll number we can't divide this role
5:16
number
5:17
okay and
5:19
mobile number mobile number can't be
5:22
divided okay email we can't divide this
5:25
email
5:27
okay so this can be called as a
5:30
simple or atomic attribute so these
5:33
can't be divided further into sub parts
5:35
okay so that's why these attributes we
5:38
call it as a simple or atomic attribute
5:41
right the next one
5:44
the next one
5:49
key attribute
5:56
key attribute
5:58
so this key address
6:01
is an attribute
6:05
which can be used to
6:12
identify
6:16
an entity
6:20
unity
6:24
so the attribute which can identify the
6:26
entity uniquely we call it as a key
6:29
attribute so usually we call this as a
6:31
primary key so the attribute which is
6:32
having the primary key property is comes
6:35
under this
6:36
key attribute right so for example
6:38
coming to the student
6:40
table or a student entity so
6:44
the example for the key attribute for
6:46
the student is a registered number or
6:49
the role number so the role number will
6:51
be the unique right so we can
6:55
identify the entity
6:56
with the help of this role number so
6:58
roll number will be the unique
7:00
identifier to
7:02
find the entity okay to identify the
7:05
entity
7:06
so example is role number of a student
7:09
role number of a student
7:11
so this is a key attribute
7:13
in the next one
7:17
next one
7:23
single valued
7:28
attribute single valued attribute
7:34
so this is an attribute
7:37
an attribute
7:41
which can hold
7:45
only single value
7:49
only single value
7:52
okay so
7:53
example
7:58
example
8:00
age
8:01
the age of a student will be only one
8:04
okay
8:05
and similarly
8:08
age
8:11
gender gender is also an attribute which
8:13
comes under the single valued attribute
8:15
so gender will also be having only one
8:17
value
8:19
okay and obviously the role number will
8:21
also comes under this uh
8:23
single valued attribute because roll
8:25
number will also be only one value so
8:28
any ad an attribute can satisfy a
8:30
multiple properties that means one
8:32
attribute can be a key attribute
8:35
and a single valued attribute or any
8:37
other
8:38
attributes property right so one
8:40
attribute can satisfy multiple
8:41
properties so like this roll number will
8:44
also comes under the single value dot
8:45
attribute apart from the key attribute
8:48
right so an attribute which can hold
8:50
only a single value which can hold only
8:53
a single value
8:55
and the next one
8:58
multi-value
9:04
multi-valued attribute multivalued or
9:07
multiple valued attributes so this is an
9:10
attribute
9:15
which can hold
9:21
multiple values
9:23
multiple
9:25
values or a set of values or a set of
9:28
values right so coming to the example
9:30
for this multivalued attribute
9:33
see
9:34
so one is a
9:37
contact
9:38
contact number of a student because
9:40
so one person can have a multiple
9:42
contacts one mobile number one landline
9:44
number
9:45
right so multiple contacts so this
9:47
particular attribute can have a multiple
9:50
values similarly email
9:54
email
9:55
so one person can have a multiple email
9:57
ids okay multiple email id so every
10:00
email it is a unique one but one person
10:02
or one student can have a multiple
10:05
emails so that means multiple values can
10:09
have for this particular attributes now
10:11
one more
10:12
skill set of a student
10:14
skill set of a student so one student
10:18
can be
10:19
good at c programming in a python one
10:22
one student can have a more technical
10:24
knowledge on different technologies so
10:26
that means the skillset we also comes
10:28
under this multi-valued attribute okay
10:30
one
10:31
the attribute which can hold multiple
10:34
values
10:35
right so this we call it as a
10:37
multi-valued attribute
10:40
the next one
10:42
the next one
10:47
derived attribute
10:51
derived attribute
10:55
so this is an attribute
11:00
which can be derived from
11:06
which can be derived from
11:11
another attribute
11:13
another
11:14
attribute
11:17
right so
11:21
the value the value for this particular
11:23
derived attribute will be calculated
11:25
from another attributes so such
11:27
attribute we call it as a
11:29
derived attribute derived
11:32
so example
11:33
so h
11:34
can be calculated from
11:36
date of birth
11:38
date of birth so this edge will be
11:41
considered as
11:42
derived attribute
11:45
and this date of birth will be
11:47
considered as
11:48
stored attribute
11:50
stored at impact similarly
11:52
percentage will be
11:55
getting from the
11:56
marks so without the marks we can't
11:58
calculate the percentage right so
12:00
percentage can be derived from the marks
12:03
so this will be the
12:05
derived attribute and this will be the
12:08
stored attribute so the attribute which
12:11
is derived the value of that particular
12:13
attribute which is derived from another
12:15
attribute is called
12:17
derived attribute
12:19
okay so
12:21
these are the different types of
12:22
attributes now i will
12:25
show you the
12:27
i mean i will demonstrate all these
12:28
attributes with a small example let us
12:30
take one student table and we will see
12:32
what are the attributes and what type of
12:34
attributes in that particular table is
12:36
having
12:37
now
12:42
let us take the student table
12:48
so this is a student that means an
12:50
entity type okay entity type now i am
12:54
taking the
12:56
roll number
13:00
name
13:05
age
13:08
date of birth
13:12
gender
13:18
contact email
13:22
and
13:23
percentage
13:24
percentage so
13:26
this is a table
13:29
okay this is the
13:30
student table we are having the student
13:33
table
13:36
so in this table we are calling all
13:38
these columns as an
13:41
attributes
13:42
all these columns as an
13:44
attributes right
13:45
now we will consider
13:48
okay these are different rows
13:50
right now this roll number comes under
13:54
key attribute
14:00
single value
14:05
simple
14:07
and it cannot be multi-valued okay it
14:09
cannot be multi-valued
14:14
right it cannot be multi-valued
14:15
attribute because it stores only a
14:17
single value it cannot be a derived
14:19
attribute because this is not derived
14:20
from any other attribute okay so
14:24
key
14:24
single and
14:26
simple
14:28
and coming to the name name is a
14:32
composite attribute which can be further
14:34
divided right because
14:36
name can be divided as
14:40
so this is a composite attribute and age
14:44
age will be
14:47
simple
14:49
single value
14:54
and also derive
14:56
it's not a multi-value because it
14:58
doesn't take multi-values right so date
15:00
of birth
15:01
it will be
15:03
stored
15:04
stored attribute
15:06
and also it will be the single value
15:09
because the date of birth will also be a
15:11
single value right
15:14
gender
15:16
so gender will be
15:18
single value
15:23
single value
15:24
and if it is is it a key attribute no
15:27
no so key attribute means unique
15:29
identifier and single valued okay it's a
15:32
simple attribute it's also a simple
15:34
attribute
15:35
it can't be derived further right h can
15:38
be derived further by
15:40
by taking a month year and
15:42
day
15:43
right
15:45
next contact contact will be
15:48
it can't be the key attribute because
15:50
so
15:51
a student can have a contact number or
15:53
may not have a contact number so here
15:55
the key attribute should be unique and
15:57
it should not be a null
15:59
no this is not a key attribute it's a
16:03
single
16:04
it can't be
16:06
divided further so it comes under the
16:09
simple attribute
16:10
and
16:13
see it's a single value
16:15
sorry it's a multi-value not a single
16:17
value it's a multi-value because one
16:20
student can have a multiple
16:22
values right multi-value multi-value
16:25
attribute okay and also simple attribute
16:27
and also simple attribute and this is
16:29
also similar it is a multi-value
16:34
and also simple you can't be divided
16:37
further and percentage is a derivative
16:41
percentage is derived similar to our age
16:44
okay it also
16:46
single value
16:47
and also
16:49
simple
16:50
similarity
16:52
right so like this one attribute can
16:54
have a multiple properties one attribute
16:56
can have a multiple properties so these
16:58
are all the different categories of
17:00
attributes so
17:02
the first one
17:05
composite
17:09
simple
17:12
or atomic
17:16
single value
17:22
multiple valued or multi-valued
17:30
key attribute
17:35
derived attribute so these are the
17:37
different types of attributes
17:40
in dbms so an
17:43
attribute
17:44
is the properties of a characteristic
17:47
which describes the entity is called as
17:50
an attribute
17:51
right so hope you understood this
17:54
attributes concept and if you are having
17:55
any doubts regarding these attributes
17:57
feel free to post your doubts in the
17:58
comment section definitely i'll try to
18:00
clarify all your doubts if you really
18:02
enjoyed my session like my session share
18:04
my session with your friends and don't
18:06
forget to subscribe to our channel
18:08
thanks for watching thank you very much