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) 🧁

[@laxmikumarisahu1311]

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

[@amanprajapati3417]

+1

[@sratnamanjari244]

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

[@intrepid18]

Ma'am you are a boon to us 🛐💟

[@ameyphatak8562]

Awesome explanation. Thank you so much.

[@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 😂😂😂

[@amadujalloh4700]

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

[@ACTIVE_TOYS]

Your explanation is too good

[@rahulvarma7257]

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

[@sanianausheen8208]

Thank you very much mam...nice explanation 👍

[@alkakumari8900]

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

[@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

[@lionking738]

nice explanation sistaah😍😍

[@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,

[@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 🔥💯

[@bochkarsanjay3821]

superbbbb video full useful.....

[@josephumba1881]

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

[@_SurajYadav-lr9fl]

thank you ma'am for making such video

[@rodrickngonyoku5042]

This woman is Amaizing

[@kartikangadi394]

🙏

[@rayudumahesh3530]

Super mam👍🙏

[@kobiyt6760]

it's more helpful for my exam

[@Zakirhossain-sk3nz]

Awesome lecture ,Mam

[@psychedvibie4411]

Helpfull❤😍

[@gunareddyysrcp]

Mee gold ring bagundhi mam

[@saiprakash6780]

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

[@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

[@BilalKhan-ln8tn]

Thanks mam, nice way of teaching

[@preethamm.n1161]

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

[@kartikangadi394]

Chapri

[@ShraddhanjaliGupta]

You are fabulous mam ❤️

[@ayushchauhan4055]

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

[@rsarunkumar4701]

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

[@MrTechnomantra]

Thanks, very nice video.

[@education4uofficial]

thank u

[@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

[@itzme8861]

Nice ring

[@Bornkill-zi2zj]

Love from kerala

[@lakhansajnani7981]

Very nice explained....

[@ikesundayasmith2861]

Good work,well explained

[@imtiyazdar2664]

thnks a lot mam..u r super

[@hoorkhan3596]

Awsome 👌👌👌

[@majidsaif4136]

beautifull name

[@education4uofficial]

thank u very much

[@mdimransheikh8017]

Awesome thanks

[@dhanush_shetty12]

Maav fam attendence plz🤡.. #maavbelagavi

[@kartikangadi394]

This a movement now😭❤️

[@dhanush_shetty12]

@@kartikangadi394 bro❤️

[@rohit6238]

🙋‍♂️

[@toronisinha840]

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

[@laxmihn6751]

Excellent mam

[@ashishbhatt2988]

Thank you very nice video

[@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

[@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.

[@jileshrollno.2487]

ur voice is similer to deepeka padukon in cheenai express

[@subhadipdey7052]

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

[@parthbuha9221]

Awesome, thank you

[@soumyaranjanbehera]

Thanks mam thnku vry much

[@keerthivardhanreddyailuri1205]

R19 unique and legend batch

[@bejugamruchitha8362]

What about further topics mam?

[@rukkukhan8514]

Nice explanation mam

[@monikaraizada9527]

Vry nice

[@education4uofficial]

thank u

[@kishanverma1252]

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

[@rejabulislam8683]

Bro my wtsapp 6000794119 note send me pls

[@allenmujati5290]

well explained. Thank you

[@kumaridodda9832]

Can we have notes like pdf of ur explained mam

[@fitnessgroupofindia4423]

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

[@bharatbist8770]

Chennai express ke depeeka padukon ki yaad aagai yr.

[@TACO_cheera]

Thank You ma'am.

[@yonaswubet4601]

You are my choice !!

[@amardeeptripathi6337]

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

[@BanarasiChannel]

Ma'am DBMS ka pura lecture ka link bhejiye plz

[@education4uofficial]

see the playlist in channel

[@BanarasiChannel]

Thanks

[@kartikangadi394]

Kudd sulemagna

[@Acornnnn632]

@@kartikangadi394 😂😂😂😂😂

[@vigneshmahesh3796]

👏👏

[@hafiztouseef6184]

Good job

[@praveenchandran3622]

why we are saying a table as relation ?

[@tahaayaz6357]

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

[@riteshpatel2079]

Well explained

[@ashikrabbi4300]

not bad...but expecting more in future

[@pstcollinsihuoma4078]

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

[@education4uofficial]

Website:education4u.in

[@maheshwarivachan287]

what is the difference between key attribute and primary key?

[@vumpmusic]

They are the same

[@Anveshana837]

Not one attribute, a set of attributes

[@frolajackobo3464]

🙏🙏🙏🙏

[@bhanutyagi8636]

My name is also bhanu🤣🤣🤣

[@AdeshPaul]

Thanks dear.

[@kartikangadi394]

Dear? Nimmaun Madam adaar avr, respect kod😤

[@sayedabdulrahiman5655]

Supper explanation but in this not clear about referential integrity

[@saiiprakash6724]

nice video

[@bhanuteja_04]

My name is bhanu mam😁

[@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 😂

[@sourabhvishwakarma1]

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

[@Acornnnn632]

Lmfao maav belagavi 😂

[@gandichiranjeevi9999]

💯💖💖💖💖💖💖💖

[@ajmeershah2346]

thank you mam

[@rakeshprajapati9587]

TUTORIALS POINT

[@bilalmohammad4242]

awsome :*

[@divyachilakala6619]

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

[@learnerg2662]

💖💖💖💖💖💖💖💖💖

[@rohitvishal8927]

But 0 is not null

[@kranthim9783]

thanx

[@sandysandysandy4824]

Key attribute ko primary key bolna che apko shyad

[@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

[@bikrambhai---yt.9016]

2024 me

[@divyakavya3309]

Mam views concepts

[@osmtech6305]

thanks

[@rjtyadav029]

wastage of ppr