Perform Operations on Table | Unit - 3 Database Management System | Class 10 Information Technology

Perform Operations on Table,
Unit - 3 Database Management System,
Class 10 Information Technology
In this video, you will understand the following topics:
Inserting data in the table.
Editing records in the table.
Deleting records from the table.
Sorting data in the table.
Referential integrity.
Creating and editing Relationships -
One to One,
One to Many,
Many to Many.
Field properties.
Join this channel to get access to perks:
/ @swatichawlaofficial
Click on this link to visit the online store to buy the customised products.
/ @swatichawlaofficial
To download the study material issued by CBSE, click on the following link:
Employability Skills
cbseacademic.ni...
Subject Specific Skills
cbseacademic.ni...
Part - A ( Employability Skills)
Unit - 1 Communication Skills - II )
Introduction, Communication Cycle, Types of Communication
• Unit - 1 Communication...
Feedback in Communication and 7 C's of Communication • Feedback in Communicat...
Communication Barrier and its types, Overcoming Communication Barrier
• Communication Barrier ...  
Part - B (Subject Specific Skills)
Install OpenOffice
• How to Download and In...
Unit - 1 (Digital Documentation - Advanced)
Create and Apply Styles in the Document
• Create and Apply Style...
Insert and use images in document
• Insert and use images ...
Create and use Template
• Create and use templat...
Create and Customize Table OfContents
• Create and Customize T...
Implement MailMerge
• Mail Merge in OpenOffi...
Unit - 2 (Electronic Spreadsheet - Advanced)
Consolidating Data and Calculating Subtotal in OpenOffice Calc
• Consolidating Data in ...
What - if Analysis Tools (Scenarios, Goal Seek and Solver)
• What If Analysis Tools...
Linking Data and Spreadsheet
• Linking Data and Sprea...
Share and Review a Spreadsheet
• Share and Review a Spr...
Create and Use Macros in Spreadsheet
• Create and Use Macros ...

[@Miss_intelligent_1]

Mam you are made for i.t. And i.t. is made for you Mean you are the best teacher forever for i.t. Keep your teaching up🙏 I have much to say you but no words to explain

[@SwatiChawlaofficial]

Thanku so much... 🙂🙏🏻 Really means a lot

[@ishitasharma7654]

you made every step practically clear and i prepare for my practical exam tomorrow smoothly...thankyou mam

[@SwatiChawlaofficial]

Thanks and Welcome

[@krishbisht6071]

You teach very well

[@SwatiChawlaofficial]

Thanks a lot

[@gagan_ramgarhia4767]

mam is it important to learn steps of creating a table ......

[@yashrajsingh250]

nope nhi puch the hai..

[@deaddoy3132]

Mam aap girls ka hi name kyu late ho boys ne kya kiya h

[@NEETASPIRANT12652]

Mam You are best teacher in whole You tube ❣️❣️

[@SwatiChawlaofficial]

Thanks a lot 😊

[@Ayush_Yt.]

Really appreciable Because you made this easy I understand all the concepts Thanku so much, mam ❤

[@SwatiChawlaofficial]

My pleasure 😊

[@NEETASPIRANT12652]

Mam kya hum Smart phone mein download karke bhi practical kar sakte hai . Please tell me mam i don't have computer .🙏🙏

[@SwatiChawlaofficial]

play.google.com/store/apps/details?id=com.andropenoffice

[@nanditamallik7143]

you teach very well mam ❤

[@SwatiChawlaofficial]

Thanks

[@Aryanchanana17]

The best IT teacher on KZbin who teaches IT well 😊🤌

[@SwatiChawlaofficial]

Thanku so much 🙏🏻🙂

[@avantikaghoshal7610]

mam day after tomorrow is my exam. Thank you very much will score best because of you

[@SwatiChawlaofficial]

All the best

[@reshamkaur7768]

Mam ap videos pr likh do ki eskai badd konsa topic aata esa smj nhi a rha

[@huh5933]

Playlist dekh

[@suyashverma8205]

Haan Bhai palylist dekho 🤞

[@SwatiChawlaofficial]

Class 10 Information Technology Term 2: kzbin.info/aero/PL5Raijva2y4QrB2TnpTNnvxvUel3SBKE6

[@Anita-lo9mv]

You are the best IT teacher and offcourse the only one on the whole KZbin who teaches IT that well.

[@anchaltiwari3037]

@@suyashverma8205haeaou

[@prithika3416]

Thank you ma'am,your videos are very useful specially when it comes to exams,and things cant be understood easily,u make them easy for us!

[@SwatiChawlaofficial]

Thanks.. Keep Watching

[@jayashreesenapati982]

Ma'am you are playing a vital role in shaping INDIA'S FUTURE !!! Your video explanation is helpful so much to me.

[@SwatiChawlaofficial]

Thanku so much 🙂🙏🏻

[@nishthasharma7153]

Loved the session Ma'am helped in revision

[@SwatiChawlaofficial]

Thanku

[@vardhmaanjain3388]

Thanku mam l am ready for paper now thanku

[@SwatiChawlaofficial]

Most welcome 😊

[@Shreyash.Mishra]

Thanks mam. I have a doubt, we have ms access as our dbms, so i am not able to understand Validation rule and Validation text field property.

[@kratisaxena1196]

Best chennal for it subject

[@SwatiChawlaofficial]

Thanku...

[@DCSIMRANKHAN-ft7kh]

Mam I have no computer , I have a phone ,would you please tell me which app I download in phone ,where I can do practice

[@vassart6963]

Mam your practical is awesome 🙂

[@SwatiChawlaofficial]

Thanku..

[@khushikarwal5925]

Thankyou so much for your marvellous explanation 🙂

[@SwatiChawlaofficial]

Most Welcome

[@J9A5G5E5E9T]

Ma'am having one confusion.. Plz make it clear that in stu table u have added the value 104 in place of 103 then it accepted but want to ask how it would be becoz table connected through 103 column of teacher table

[@asher6379]

104 is there in Teacher ID so it accepts ,when we enter a number which is not in teachers ID it doesn't accept...that's why it didn't accept 109 which is not there in Teacher's ID

[@shakshisingh6869]

Thank you ☺️ mam ❤️

[@SwatiChawlaofficial]

Most welcome 😊

[@NEETASPIRANT12652]

Thank you very much mam 💝❤️

[@SwatiChawlaofficial]

Most welcome 😊

[@yogeshdaga7575]

Thankyou mam Very Helpful!!

[@SwatiChawlaofficial]

Most welcome 😊

[@Shreeya717]

Thankyou so much

[@SwatiChawlaofficial]

Most welcome

[@shisuiuchiha1629]

Ma'am please tell me will the step based questions come in exam ? And the question based on the information like where is the edit button located ??? Please answer!

[@chhandasaha2484]

Ha bhai aaega

[@mohitk8068]

Mam , my mam referred ms access what will I do?

[@kinjalkumar6646]

You are amazing ma'am. Your teaching method is absolutely wonderful!!!!! Thank you sooo much ma'am!!!! Love you loads ma'am 🖤💜❤🖤💜💫💫💫

[@SwatiChawlaofficial]

Thanks and Welcome

[@luvpaliwal8347]

ma'am format example samajh nhi aaya

[@rakshitsingh-j6b]

GOOD EVENING MAM, i want to ask you that mam are each and every practical important for boards? mam IT syllabus of book code 402 is very large & to recall every practical is not easy.....o mam its my humble request please guide how to prepare for boards🙏🙏🏼

[@kusumsood7342]

Mam what r the steps to sort the table in descending order of primary key

[@Legendary_anime_world]

Mam isme deleting a field aapne kis time par padhaya hai please please batado

[@2a27ayushibharati8]

Thank you very very very much mam 😊

[@SwatiChawlaofficial]

Welcome

[@sathwik6413]

Mam can you make a video on how to prepare for this year's board i meant 2021-2022 for term 1 and term2 two different test's and can you even tell which book to refer and all which area's important for MCQ's like that please please, please mam

[@sathwik6413]

Mam this is for class 12

[@SwatiChawlaofficial]

No..this video is not for class 12...it's for class 10.. for now just start clearing your concepts of the chapters and execute it practically.. If ur concepts are clear...u will definitely be able to solve MCQs also..

[@JK_78j]

Thnkeww so much mam 💫💜

[@SwatiChawlaofficial]

Welcome

[@ranjeetrai9451]

Didi aap bahut acha padhati ho

[@SwatiChawlaofficial]

Thanku

[@SatishKumar-wp9pe]

Thank you Ma'am Also tell us the imp questions which are repeating in Board exams

[@SwatiChawlaofficial]

drive.google.com/file/d/1eserIh-rIX1fQgJ2NLQUwhePYB3Ek535/view?usp=drivesdk

[@vipulagrawal7329]

Amazing🥰

[@SwatiChawlaofficial]

Thanks

[@Yash-vh7jm]

Fabulous explanation mam..thank you for an amazing explanation.

[@SwatiChawlaofficial]

Thanks and welcome

[@archanapathak5739]

mam pls give a more clear and crystal concept

[@lalarathi271]

Ram ram madam

[@jashanaggarwal6686]

Mam i have a doubt if we firstly delete the relation and add a new student record in student record table with a teacher id which is not added in the teacher record and then I try to make relation. Kya vo hoga ithink nhi hoga error aaega. Am I right mam?

[@jashanaggarwal6686]

Mam please reply

[@SwatiChawlaofficial]

Yes .. It will generate error

[@jashanaggarwal6686]

Thnk you sooo. Much mam

[@gaurreeya2008]

Very Well explained ma'am 🫡🫡

[@SwatiChawlaofficial]

Thanks a lot

[@ritushreenandi2676]

Ma'am can you plz help us with cbsc class X practical file..🙏

[@SwatiChawlaofficial]

ok

[@yashnamdeo9520]

Thankyou mam ❤

[@SwatiChawlaofficial]

Welcome

[@Shraddha_089]

29:00 yha pe voh 104 pe bhi toh error show karega na?? Plz somebody tell

[@manaswinikataria381]

nahi uspr error show nhi hoga! kyuki 104 ek teacher id hai

[@MrMOOD-hb2dz]

Man what a explaining

[@voyageofmylyf03]

Ma'am every concept is clear ...u r really amazing Ma'am.🥰🥰.... Can u pls provide this ppt as lecture notes...Ma'am it will be tooo helpful for us....☺️☺️

[@SwatiChawlaofficial]

Sure..You can enjoy special perks by joining the membership. Have a look at this. kzbin.info/door/2vH9rqGh-fJELF8acGfBdwjoin

[@garimavashishtha1062]

Mam relationships are not clear... How connecting two tables would be beneficial?

[@SwatiChawlaofficial]

If the data which we want to receive is in both the tables..

[@varadavaibhavgoswamiclass1667]

Maam what is the description column in the table design box for, please reply as I have my exam tomorrow

[@SwatiChawlaofficial]

Just to add extra details of description about that particular column. It is an optional field.

[@arhamnasim1749]

Mam thanks😭😭😭😭😭

[@SwatiChawlaofficial]

Welcome

[@thekhobas.]

Ma'am apne deleting field and record ki video banai hai kya?

[@mamtagarg8333]

Ma'am after creating relationship I am not able to write anything in a table even I don't able to change 103 to 104

[@selena_marx1412]

😊😊😊

[@anmolallrounder3064]

Amazing Mam

[@SwatiChawlaofficial]

Thanku

[@shining_star9981]

👍

[@rajnibala1664]

Mam please share the ppt so that we can make notes Please mam 🙏🏻🙏🏻

[@SwatiChawlaofficial]

Please check out the description of the video

[@rajnibala1664]

@@SwatiChawlaofficial mam that is not opening

[@SwatiChawlaofficial]

cbseacademic.nic.in/web_material/Curriculum21/publication/secondary/402-IT_ClassX.pdf

[@vivekmanhas7324]

Ma'am Vedio ke upar part likh diya kro thumbnail me☺️

[@SwatiChawlaofficial]

All d videos in the playlists are in sequential order..

[@kiranjaiswal5164]

Ma'am varchar kya hota h

[@SwatiChawlaofficial]

it's a variable length data type used to store alphanumeric characters..

[@deepanshuverma8749]

Didi Ap Web Seecurity O Part A k Chapter kb Pdaoge

[@SwatiChawlaofficial]

will upload soon...

[@vaishaliagicha1741]

what about SQL commands

[@SwatiChawlaofficial]

Database Management System: kzbin.info/aero/PL5Raijva2y4QEsOPmhKXuK1__yKzkuc4e

[@jaiprakashrajFf09]

First 😍 view

[@vardhmaanjain3388]

Mam aap tuition padhataho

[@monika9527]

Many 2 many relationship practically smjha do

[@PIYUSHKUMAR-ez3rv]

DIDI ALT+TAB USE KRNA SIKH GAYI🤣

[@tusharmaharana3373]

Chup!! Tujh se jyada ata hai mam ko

[@PIYUSHKUMAR-ez3rv]

@@tusharmaharana3373 hahahaha!!!!

[@mayankopgamer3712]

Padhna hi hai toh baal khol ke kya dikha rhi h😂

[@Dhruvbhambani]

THANK U DIDI

[@SwatiChawlaofficial]

Welcome

[@goldenfuntime4555]

Mam term 2 jaldi start kijiye

[@SwatiChawlaofficial]

Already started

[@goldenfuntime4555]

@@SwatiChawlaofficial mera matlab khatam kijiye with daily videos

[@huh5933]

Kuch bhi nahi samjha

[@Basavareddy14]

Lol 😆🤣

[@huh5933]

@@Basavareddy14 tuzhe samjha kya

[@manaswinikataria381]

@@huh5933 han meko to smjh aa gya

[@mailmail31]

Which book is good for IT 402 mam please refer

[@SwatiChawlaofficial]

kzbin.info/www/bejne/jmS1on-HiNmsqqs

[@selena_marx1412]

😊😊😊