constraints in dbms | key, domain & referential integrity | | DBMS | Lec-16 | Bhanu Priya

[@youtubevideostorage3381]

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.

[@amanprajapati3417]

Helpful

[@movieshub4775]

Thanks

[@020hamza2]

you are great teacher because you are telling detail of each important terms so we can understand sentence easily

[@omardavila2010]

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!

[@shubhammishra2336]

The way u r teaching is superbb very easy to understand....

[@agcodes]

In RDBMS, Table = relation Coloumns =Attributes Turples = Rows Data Types = Domains, Degree = No. of Attributes, Cardiality = No. of Rows (Turples) 🧁

[@ameyphatak8562]

Awesome explanation. Thank you so much.

[@sratnamanjari244]

Thank You So Much MAM........lots of Love and Respect to you

[@stressbuster9313]

Thank you so much mam, you were expressing very well 😊

[@billu6923]

You mean explaining?

[@kartikangadi394]

@@billu6923 no he meant shitting in your ears

[@jagadishpattar1210]

@@kartikangadi394 😂😂😂

[@laxmikumarisahu1311]

Clearly explained.... Thank you so much for this... I have cleared all my doubts... Once again thank you.. 😊☺

[@amanprajapati3417]

+1

[@intrepid18]

Ma'am you are a boon to us 🛐💟

[@sanianausheen8208]

Thank you very much mam...nice explanation 👍

[@amadujalloh4700]

Thanks so much sis; geez I am glad I came across this channel!

[@ACTIVE_TOYS]

Your explanation is too good

[@alkakumari8900]

Thank you so much ma'am it is very clear now

[@rahulvarma7257]

You’re explanation is really awesome. keep it up 👏👏👏

[@bochkarsanjay3821]

superbbbb video full useful.....

[@kampeswamy2888]

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

[@AnkiitOp]

Jodd 🔥💯

[@vaibhavnirbadh3280]

You explained really well ma'am... :)...althoughyour accent was a bit funny :D

[@kartikangadi394]

You know what's funnier? Your parents not using protection that night😩

[@amanprajapati3417]

@@kartikangadi394 🤣🤣🤩savage

[@nerdy.guy_yt]

Are, she is south Indian, she can't help it,

[@lionking738]

nice explanation sistaah😍😍

[@raihankhan4374]

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?

[@siddheshgawade1017]

ya primary keys cant be same in a table

[@maxinteltech3321]

Clear explanation.Thanks

[@_SurajYadav-lr9fl]

thank you ma'am for making such video

[@kobiyt6760]

it's more helpful for my exam

[@Zakirhossain-sk3nz]

Awesome lecture ,Mam

[@josephumba1881]

But what about the last Constraint? you didn't explain how to find it on the table? :(

[@aashutoshchhedavi]

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

[@cse010shoaibshafi]

H is candidate key , if I m not wrong

[@nandanaponni2548]

3NF

[@MrTechnomantra]

Thanks, very nice video.

[@education4uofficial]

thank u

[@BilalKhan-ln8tn]

Thanks mam, nice way of teaching

[@saiprakash6780]

Tq..... 😊 It's a good one....

[@gunareddyysrcp]

Mee gold ring bagundhi mam

[@rsarunkumar4701]

your videos are excelent maam but it would be better if u placed the in order

[@ikesundayasmith2861]

Good work,well explained

[@lakhansajnani7981]

Very nice explained....

[@psychedvibie4411]

Helpfull❤😍

[@rayudumahesh3530]

Super mam👍🙏

[@ShraddhanjaliGupta]

You are fabulous mam ❤️

[@harshit.jindal]

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.

[@Farahat1234]

How?

[@SQLwithManoj]

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.

[@kartikangadi394]

Muklya

[@ashishbhatt2988]

Thank you very nice video

[@hoorkhan3596]

Awsome 👌👌👌

[@majidsaif4136]

beautifull name

[@education4uofficial]

thank u very much

[@shantanurauthan9318]

You didn't explained referential integrity well

[@adnanahmadsiddiqui4395]

well?? She didn't explain anything at all.

[@_iamankitt_]

Did she explained anything??

[@manilavaswani154]

She didn't expalin anything..

[@Ankitsharma-cx8gw]

@@manilavaswani154 go to hell fuckin bitch.

[@imtiyazdar2664]

thnks a lot mam..u r super

[@tsubaharan]

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 .

[@kartikangadi394]

Simp Uncle

[@preethamm.n1161]

💞💞Awesome 🌹🇮🇳🇮🇳🇮🇳💞💞

[@kartikangadi394]

Chapri

[@rodrickngonyoku5042]

This woman is Amaizing

[@kartikangadi394]

🙏

[@allenmujati5290]

well explained. Thank you

[@ayushchauhan4055]

yes mam in my village one old man names 71 singh in hindi eekhattar singh (int). 😅

[@toronisinha840]

very nice...........

[@itzme8861]

Nice ring

[@mdimransheikh8017]

Awesome thanks

[@jileshrollno.2487]

ur voice is similer to deepeka padukon in cheenai express

[@rukkukhan8514]

Nice explanation mam

[@fitnessgroupofindia4423]

Nice mam.. you have a good skill of teaching.. I just know the where come a Default constraint in these three types.

[@parthbuha9221]

Awesome, thank you

[@monikaraizada9527]

Vry nice

[@education4uofficial]

thank u

[@laxmihn6751]

Excellent mam

[@hafiztouseef6184]

Good job

[@Bornkill-zi2zj]

Love from kerala

[@ashikrabbi4300]

not bad...but expecting more in future

[@riteshpatel2079]

Well explained

[@soumyaranjanbehera]

Thanks mam thnku vry much

[@Acornnnn632]

Lmfao maav belagavi 😂

[@saiiprakash6724]

nice video

[@TACO_cheera]

Thank You ma'am.

[@dhanush_shetty12]

Maav fam attendence plz🤡.. #maavbelagavi

[@kartikangadi394]

This a movement now😭❤️

[@dhanush_shetty12]

@@kartikangadi394 bro❤️

[@rohit6238]

🙋‍♂️

[@tahaayaz6357]

Nice lecture although you didn't explain about integrity constraint bu showed on what it works on... :(

[@bharatbist8770]

Chennai express ke depeeka padukon ki yaad aagai yr.

[@BanarasiChannel]

Ma'am DBMS ka pura lecture ka link bhejiye plz

[@education4uofficial]

see the playlist in channel

[@BanarasiChannel]

Thanks

[@kartikangadi394]

Kudd sulemagna

[@Acornnnn632]

@@kartikangadi394 😂😂😂😂😂

[@sayedabdulrahiman5655]

Supper explanation but in this not clear about referential integrity

[@bhanuteja_04]

My name is bhanu mam😁

[@subhadipdey7052]

Plz mam sow up private video which are not seen ... thanks

[@amardeeptripathi6337]

What I got to know till now a foreign key is a non-key attribute

[@pstcollinsihuoma4078]

I didn't understand your last explanation about the referential integrity constraints

[@education4uofficial]

Website:education4u.in

[@osikhan334]

any video of relationships types in relation model like ternary andquaternany reltionship ? can i get a quick reply ?

[@kartikangadi394]

Quick reply? What are you? Chief Minister?

[@Acornnnn632]

@@kartikangadi394 maav belagavi 😂 ssup 😂

[@keerthivardhanreddyailuri1205]

R19 unique and legend batch

[@bejugamruchitha8362]

What about further topics mam?

[@bhanutyagi8636]

My name is also bhanu🤣🤣🤣

[@kishanverma1252]

I want all notes of Dbms,DA,computergrapics, conputer networks II

[@rejabulislam8683]

Bro my wtsapp 6000794119 note send me pls

[@yonaswubet4601]

You are my choice !!

[@maheshwarivachan287]

what is the difference between key attribute and primary key?

[@vumpmusic]

They are the same

[@vigneshmahesh3796]

👏👏

[@AdeshPaul]

Thanks dear.

[@kartikangadi394]

Dear? Nimmaun Madam adaar avr, respect kod😤

[@bilalmohammad4242]

awsome :*

[@kumaridodda9832]

Can we have notes like pdf of ur explained mam

[@sourabhvishwakarma1]

what about name of Mr. Elon Musk's son in name in domain constrains.

[@glitter_reins]

Mam you should increase the content for explanation...it is very less...

[@Anveshana837]

Not one attribute, a set of attributes

[@ajmeershah2346]

thank you mam

[@frolajackobo3464]

🙏🙏🙏🙏

[@praveenchandran3622]

why we are saying a table as relation ?

[@divyachilakala6619]

Why u skip assertions topic mam. I need assertions topic mam!...

[@gandichiranjeevi9999]

💯💖💖💖💖💖💖💖

[@sandysandysandy4824]

Key attribute ko primary key bolna che apko shyad

[@kranthim9783]

thanx

[@divyakavya3309]

Mam views concepts

[@vishallearningpoint7895]

Mam you can show private viedeo because it is cheating

[@education4uofficial]

minor corrections required in those private videos....share again with corrections.....thank you

[@rakeshprajapati9587]

TUTORIALS POINT

[@learnerg2662]

💖💖💖💖💖💖💖💖💖

[@putrinadhirafauziah7866]

thank you^^!!!

[@osmtech6305]

thanks

[@bikrambhai---yt.9016]

2024 me