Constraints are conditions. Every relation has some condition that must hold for it to be a valid relation, called Relational Integrity Constraints. 3 Types 1. Key constraints / Entity constraint 2. Domain constraint 3. Referential Integrity constraint 1. Key Constraints = A key is just an attribute. In a relation with a key attribute, no two tuples can have identical values in the key attribute. = key attribute can not have null values = if more than one such minimal subsets, these are called candidate keys. 2. Domain Constraints = Every attribute is bound to have a specific range of values. datatypes and range must be followed. For. example: age attribute can not be negative or can not be an alphabet. 3. Referential integrity constraints = works on the concept of foreign key = A foreign key is a key attribute of a relation, that can be referred to in another relation.
Thank you! Although it was a little difficult to understand if I just stop and listen closely it all makes sense. Thank you for taking the time to make this video!
So does this mean entity constraint means that no two rows can have the same values, reason for this is that it would be impossible to tell the difference between them, thus a primary key is used to satisfy the entity constraint? This also implies means no two primary keys can be the same. is that correct? The primary key satisfies the entity (key) constraint?
Great work. How to add new column with constraint? for example I want to add a new column 'Age' it will alow the values greater than 10. Please explain it .
1.Integrity constraint ✅The row should have unique value.. ☑️ No null values... 2.Domain constraint ✅Every row should have same data type values ☑️ Different data types can't be accepted by single row.. 3.referentional constraint ✅ Foreign key depends on another relation.. ☑️There is 2 relations
Your understanding of domains is incorrect. It's not the individual value of an attribute, but rather the entire set of permissible values for that particular column/attribute.
She is correct but missed talking about the main constraints like CHECK, DEFAULT & NOT NULL constraints. At 9:40 she started talking about range but just ended up telling about permissible values by DATATYPE declaration at column/attribute/field level. The AGE example given falls under CHECK constraint.
a) Given a relation R(ABCDEFGH) with the following functional dependency A->B, F->G, CD->E B->A, A->FGCD H->A Find the candidate key, minimal cover for the relation R. State the Normal form of the relation. Normalize it in 3NF and BCNF
Constraints are conditions.
Every relation has some condition that must hold for it to be a valid relation, called Relational Integrity Constraints.
3 Types
1. Key constraints / Entity constraint
2. Domain constraint
3. Referential Integrity constraint
1. Key Constraints
= A key is just an attribute. In a relation with a key attribute, no two tuples can have identical values in the key attribute.
= key attribute can not have null values
= if more than one such minimal subsets, these are called candidate keys.
2. Domain Constraints
= Every attribute is bound to have a specific range of values. datatypes and range must be followed.
For. example: age attribute can not be negative or can not be an alphabet.
3. Referential integrity constraints
= works on the concept of foreign key
= A foreign key is a key attribute of a relation, that can be referred to in another relation.
Helpful
Thanks
Thank you! Although it was a little difficult to understand if I just stop and listen closely it all makes sense. Thank you for taking the time to make this video!
you are great teacher because you are telling detail of each important terms so we can understand sentence easily
Awesome explanation. Thank you so much.
In RDBMS,
Table = relation
Coloumns =Attributes
Turples = Rows
Data Types = Domains,
Degree = No. of Attributes,
Cardiality = No. of Rows (Turples) 🧁
The way u r teaching is superbb very easy to understand....
Thanks so much sis; geez I am glad I came across this channel!
Clearly explained.... Thank you so much for this... I have cleared all my doubts...
Once again thank you.. 😊☺
+1
Thank You So Much MAM........lots of Love and Respect to you
Thank you very much mam...nice explanation 👍
Thank you so much mam, you were expressing very well 😊
You mean explaining?
@@billu6923 no he meant shitting in your ears
@@kartikangadi394 😂😂😂
Thank you so much ma'am it is very clear now
But what about the last Constraint? you didn't explain how to find it on the table? :(
Tq..... 😊
It's a good one....
Awesome lecture ,Mam
Very nice explained....
Good work,well explained
Clear explanation.Thanks
You’re explanation is really awesome. keep it up 👏👏👏
superbbbb video full useful.....
thnks a lot mam..u r super
Your explanation is too good
Awesome, thank you
Ma'am you are a boon to us 🛐💟
thank you ma'am for making such video
You are fabulous mam ❤️
Thanks, very nice video.
thank u
So does this mean entity constraint means that no two rows can have the same values, reason for this is that it would be impossible to tell the difference between them, thus a primary key is used to satisfy the entity constraint? This also implies means no two primary keys can be the same. is that correct? The primary key satisfies the entity (key) constraint?
ya primary keys cant be same in a table
Thank you
very nice video
nice explanation sistaah😍😍
Nice explanation mam
Thank You ma'am.
Mee gold ring bagundhi mam
Nice mam.. you have a good skill of teaching.. I just know the where come a Default constraint in these three types.
You explained really well ma'am... :)...althoughyour accent was a bit funny :D
You know what's funnier? Your parents not using protection that night😩
@@kartikangadi394 🤣🤣🤩savage
Are, she is south Indian, she can't help it,
Love from kerala
well explained. Thank you
Well explained
Excellent mam
good work
awsome :*
Thanks mam thnku vry much
thank you^^!!!
not bad...but expecting more in future
Awesome thanks
your videos are excelent maam but it would be better if u placed the in order
Super mam👍🙏
very nice...........
What I got to know till now a foreign key is a non-key attribute
ur voice is similer to deepeka padukon in cheenai express
Thanks mam, nice way of teaching
Helpfull❤😍
This woman is Amaizing
🙏
yes mam in my village one old man names 71 singh in hindi eekhattar singh (int). 😅
Good job
Great work. How to add new column with constraint? for example I want to add a new column 'Age' it will alow the values greater than 10. Please explain it .
Simp Uncle
nice video
Thank you mam
Awsome 👌👌👌
beautifull name
thank u very much
Nice ring
it's more helpful for my exam
Vry nice
thank u
You are my choice !!
Nice lecture although you didn't explain about integrity constraint bu showed on what it works on... :(
Thanks dear.
Dear? Nimmaun Madam adaar avr, respect kod😤
1.Integrity constraint
✅The row should have unique value..
☑️ No null values...
2.Domain constraint
✅Every row should have same data type values
☑️ Different data types can't be accepted by single row..
3.referentional constraint
✅ Foreign key depends on another relation..
☑️There is 2 relations
Jodd 🔥💯
Plz mam sow up private video which are not seen ... thanks
👏👏
Chennai express ke depeeka padukon ki yaad aagai yr.
Thanks
R19 unique and legend batch
any video of relationships types in relation model like ternary andquaternany reltionship ? can i get a quick reply ?
Quick reply? What are you? Chief Minister?
@@kartikangadi394 maav belagavi 😂 ssup 😂
thanks
Your understanding of domains is incorrect. It's not the individual value of an attribute, but rather the entire set of permissible values for that particular column/attribute.
How?
She is correct but missed talking about the main constraints like CHECK, DEFAULT & NOT NULL constraints. At 9:40 she started talking about range but just ended up telling about permissible values by DATATYPE declaration at column/attribute/field level. The AGE example given falls under CHECK constraint.
Muklya
Supper explanation but in this not clear about referential integrity
💞💞Awesome 🌹🇮🇳🇮🇳🇮🇳💞💞
Chapri
Lmfao maav belagavi 😂
What about further topics mam?
thanx
My name is bhanu mam😁
a) Given a relation R(ABCDEFGH) with the following functional dependency
A->B,
F->G,
CD->E
B->A,
A->FGCD
H->A
Find the candidate key, minimal cover for the relation R. State the Normal form of the
relation. Normalize it in 3NF and BCNF
H is candidate key , if I m not wrong
3NF
what is the difference between key attribute and primary key?
They are the same
🙏🙏🙏🙏
💖💖💖💖💖💖💖💖💖
💯💖💖💖💖💖💖💖
I want all notes of Dbms,DA,computergrapics, conputer networks II
Bro my wtsapp 6000794119 note send me pls
why we are saying a table as relation ?
You didn't explained referential integrity well
well?? She didn't explain anything at all.
Did she explained anything??
She didn't expalin anything..
@@manilavaswani154 go to hell fuckin bitch.
TUTORIALS POINT
Not one attribute, a set of attributes
Can we have notes like pdf of ur explained mam
what about name of Mr. Elon Musk's son in name in domain constrains.
My name is also bhanu🤣🤣🤣
Mam views concepts
thank maam
Why u skip assertions topic mam. I need assertions topic mam!...
2024 me
🧁
Ma'am DBMS ka pura lecture ka link bhejiye plz
see the playlist in channel
Thanks
Kudd sulemagna
@@kartikangadi394 😂😂😂😂😂
But 0 is not null