Converting ER Diagrams to Tables | Examples | DBMS | Lecture 17 | Shanu Kuttan

Converting ER Diagrams to Tables | Examples | DBMS | Lecture 17 | Shanu Kuttan | in Hindi

Рет қаралды 189,499

3 жыл бұрын

#ConvertingERDiagramsToTables #ConvertingERModeltoRelationalModel #DBMS #GATECS
This video is about Converting ER Diagrams to Tables, Converting ER Model to Relational Model, different rules for Converting ER Diagrams into Tables with composite attributes, multivalued attributes, Cardinality ratios, participation constraints and weak entity
This video contain: Converting ER Diagrams to Tables, Converting ER Model to Relational Model, Converting ER Diagrams to Relational Tables, Converting ER Diagrams to Relational Schema, ER Diagram to Table conversion, ER Diagrams to Tables, ER Diagrams to Relational Schema, ER Diagrams to Relational Schema examples, ER Diagrams to Relational Model, ER Diagrams examples and solution, ER Diagrams in DBMS
This is a lecture 17 for Database Management System (DBMS) unit 1 according to CSVTU bhilai.
For more videos on DBMS follow the given link :
DBMS Playlist: • DBMS Playlist
ER Model Playlist: • ER Model in hindi
Relational Model Playlist: • Relational Model & Rel...
SQL Playlist: • SQL
Lecture 1: Database Management System (DBMS) Introduction • Database Management Sy...
Lecture 2: View of Data in DBMS | Three Levels of Abstraction | Schema & Instance | Data Independence • View of Data in DBMS |...
Lecture 3: Data Models | Relational Model | ER Model |Object Based Model | Semi-Structured Model • Data Models | Relation...
Lecture 4: Database Languages | DDL, DML, DCL, TCL • Database Languages | D...
Lecture 5: Database Access from Application Programs | SQL | APIs - ODBC & JDBC | Embedded SQL • Database Access from A...
Lecture 6: Database Users and Administrators • Database Users and Adm...
Lecture 7: Transaction Management & Storage Management • Transaction Management...
Lecture 8: Database System Structure, Query Processor, Storage Manager • Database System Struct...
Lecture 9: DBMS Architecture: 1-tier 2-tier 3-tier Architecture • DBMS Architecture | 1-...
Lecture 10: History of Database Systems • History of Database Sy...
Lecture 11: Introduction to ER Model, Entity-Attributes-Relationships • Introduction to ER Mod...
Lecture 12: Types of Attributes in ER Model • Types of Attributes in...
Lecture 13: Mapping Cardinalities & Participation Constraints • Mapping Cardinalities ...
Lecture 14: Keys in DBMS - Super Key, Candidate Key, Primary Key, Foreign Key, Alternate Key, Composite Key • Keys in DBMS | Super K...
Lecture 15: Strong Entity & Weak Entity in DBMS • Strong Entity & Weak E...
Lecture 16: Extended ER Features: Generalization, Specialization, Aggregation in DBMS • Strong Entity & Weak E...
Lecture 17: Converting ER Diagrams to Tables with Examples | Rules • Converting ER Diagrams...
Lecture 18: Questions on Conversion of ER Diagrams to Tables | Part 1 - • Questions on Conversio...
Lecture 19: Questions on Conversion of ER Diagrams to Tables | Part 2 - • Questions on Conversio...
Lecture 20: How to draw ER diagram| ER Diagram for Banking System | ER Notations • How to draw ER Diagram...
Lecture 21: Relational Model in DBMS | RDBMS • Relational Model in DB...
Lecture 22: Relational Model Mathematical Structure in DBMS • Relational Model Mathe...
Lecture 23: Integrity Constraints • Integrity Constraints ...
Welcome to this youtube channel "Shanu Kuttan CSE Classes " by Shanu Kuttan. This is a technical educational channel for subjects of computer science and engineering subjects (CSE) as per university syllabus and also cover GATE topics. It provides Computer Science and engineering classes in Hindi. This channel’s video helps Computer Science and Engineering students to understand different subjects like Computer System Architecture (CSA) i.e. Computer Organization and Architecture (COA) or simply Computer Architecture, Database Management System (DBMS), Advance Computer Architecture (ACA), Parallel Processing and Computing (PPC) unit wise as per the CSVTU syllabus i.e. Chhattisgarh Swami Vivekanand Technical University, Bhilai
Contact Link in Facebook :
/ shanukuttan.cseclasses

Пікірлер: 163

@saurabhmeghwal277 2 жыл бұрын

maam apne hamara bhut time bachaya .h .. itna aasani se samjhte ho thanku maanm

@piyushgupta9072 Жыл бұрын

Damn best video just point to point thank you so much mam just completed a complex topic in just 25 minutes

@abeehazainab193 Жыл бұрын

you made this easy to understand. your passion and dedication is commendable Thanks!

@gauravdavda7442 3 жыл бұрын

I really appreciate that the way you explain the concept is very helpful for us. It would be great if you provide us PPT of this concept.

@abidhussain4250 4 ай бұрын

AMAZING ! Well explained and fully prepared. Appreciate it.

@learntube1048 2 жыл бұрын

Best videos of this topic on youtube... 🙏❤️

@webdevop6972 Жыл бұрын

Can't thank you enough. Seriously. Loved this video

@waseemfarooq3470 2 жыл бұрын

Kaash hamare professors aise padate Thanks 🌹🌹🌹🌹ma'am Respect ❤❤❤

@shashank9042 Жыл бұрын

thank you mam , the way you have explained this topic is amazing !!!!

@priyansusahoo Жыл бұрын

Simple and Easy to Understand...very nice explanation :)

@sarthakverma.. Жыл бұрын

Thank you so much ma’am. You made this so easy to understand 😊

@AftabUA Жыл бұрын

Such a great explanation. You deserve million of subscribers.

@sakshisonwane1947 Жыл бұрын

mam i am fully satisfied with your video😄😄 best explanation ever👌👌

@prototype18 Жыл бұрын

Really helpful and great content !! BTW watching this the night before my exam :,)

@KhushiJain-xx2yk 2 жыл бұрын

Amazing lectures ma'am..you teach so well✨🤗

@jyotiswami2379 2 жыл бұрын

Superb lecture please upload more videos of more subjects and topics thanxx mam...... Concept is very clear

@adityakori70 Жыл бұрын

You are nice teacher I clearly understand this topic 🙏🏻🙏🏻❤️ thank you so much mam

@nisargpatel-yc5eo 3 ай бұрын

the clearest explanation of ER diagram thanks ma'am

@prashreetiwasti7264 3 жыл бұрын

Thank you so much ma’am. You made this so easy to understand

@ramcharanpal5735 Жыл бұрын

Thankyou so much mam my confusion clear karne ke liye 🙏🙏

@aryamanrai1972 Жыл бұрын

Thank you for this beautiful video.

@Spider-Man_67 Жыл бұрын

Jhakaas Video, thank you mam!!!

@blalitaanushka1961 3 жыл бұрын

Thank you so much for the video mam..... 😊😊😊

@alphaghost8960 3 ай бұрын

Kis kis ka Kal Database ka paper he aur aaj idher aaya hoa?😁

@mdmuquimakhter5145 3 жыл бұрын

Iss topic ko aap se behtar koi nhi padha skta ... 🔥🔥🔥

@muhammadnadeemabbas6347 Жыл бұрын

It was really helpful, thank you.

@kulyashdahiya2529 3 жыл бұрын

Thanks for making such videos. This is a great help for students preparing for semester exams. We really support you. Even though we are students we would like to make contribution to support you.

@ShanuKuttanCSEClasses 3 жыл бұрын

Thanks for supporting, your concern really means a lot.....very soon we are enabling JOIN button for membership.....best wishes

@shalinikaiwart5522 3 жыл бұрын

Thank you for the video ma'am...

@sandeepup7258 3 ай бұрын

Very Well Explained. Thankyou very much.

@pZohaibKhan 2 жыл бұрын

wow excellent explanation

@sharmishthajames3509 3 жыл бұрын

thank you for the video mam..

@shlokmantri799 9 ай бұрын

mam aapka same content hamari DBMS wali mam ne copy kiya hai ppt mai please unpar case kijiye..........😅😅

@user-tu5hw1mj8t Ай бұрын

Yrr same literally same he topic ha nothing is change 😂😂

@muskankesharwani2658 3 жыл бұрын

Thank you mam for the video😊

@rahulruidas9448 2 жыл бұрын

Well explained maam,thank you🙏🙏

@KunalPatil-il4je 4 ай бұрын

exam ke do ghante pehle ye module karliyaaa, thank u, even my collage teacher also using this ppt for teaching😂

@sakshamarora4306 3 ай бұрын

from where can we get this ppt?

@hafizmuhammadtalha2298 Жыл бұрын

excellent way you teach

@reshsajitalks9843 Жыл бұрын

Very well explained ❤

@simranarora5787 2 жыл бұрын

Very nice explanation .

@StartUnique- Жыл бұрын

I really really appreciate ❤

@nizamfarooqui5950 9 ай бұрын

Awesome👍👏 My respect for you ⬆

@MAXX866 11 ай бұрын

thanku maam ❤❤❤❤

@MaieshaArchi 2 ай бұрын

your the besttttt.....

@educationhub540 2 жыл бұрын

I learned much more from u mam

@vivekjaiswal4391 Жыл бұрын

excellent work

@cs-rohitsahu4943 Жыл бұрын

nice explanation , thank u ma'm

@rohanmale358 Жыл бұрын

Well explained... Thank you mam

@NaveedKhanYousafzai47 3 жыл бұрын

Thanks mam Allah give you long life with so much happiness :)

@ShanuKuttanCSEClasses 3 жыл бұрын

Thanks a lot ...god bless u too

@anjal_sharma 2 жыл бұрын

Very well explained ma'am 😊

@sachinkarun9393 3 жыл бұрын

Thanku mam for the video

@dinkargupta2745 5 ай бұрын

ma'am what if in the weak enitity one, there is total participation on left side too, then will we require only one table?

@susland7332 Жыл бұрын

Aapki wajah se mai fail hone se bach gya thanks ma'am 🥲💀

@tim................ 3 жыл бұрын

Thank you mam 😊

@calmrelaxingmusic6927 3 жыл бұрын

Amazing way !! Best video on this topic on KZfaq ,,,Thank you very Much mam,,,,Its Exam time & your video is helping me,,,,Keep it up mam👍🙋

@calmrelaxingmusic6927 3 жыл бұрын

Thanku mam

@ShanuKuttanCSEClasses 3 жыл бұрын

My pleasure......do subscribe and share to others also so that they can be benefited

@calmrelaxingmusic6927 3 жыл бұрын

@@ShanuKuttanCSEClasses Sure mam

@RajeshKumar-yi2eb 3 жыл бұрын

Thankyou so much ma'am

@jyotitilakraj519 3 жыл бұрын

Thank you mam..

@swasthikbhatt9833 Жыл бұрын

Thank yo so so much mam

@armansikandar3041 2 жыл бұрын

I'm totally impressed. And surprisingly shocking. Your teaching method is unique. good luck!i am going to subscribe your chanel.

@kshitizjaiswal6933 2 жыл бұрын

Nicely explained

@yashpatnaik8582 3 жыл бұрын

thank you ma'am 😊😊

@kunalbabbar7399 3 жыл бұрын

Underated deserve more views👌👌❤️❤️

@ShanuKuttanCSEClasses 3 жыл бұрын

Thanks for the support.......started this channel 8 months back, so growing slowly day by day 💗

@ankitprasad3228 Жыл бұрын

good explanation

@ShivamChoprabcs Жыл бұрын

In Rule-6,Case-2(For Binary Relationship with Cardinality Constraint and Toial Participation Constraint from Both Sides),only one table is required,and primary key is supposed to be 1 for every table..but you underlined two attributes"a1 and b1"...are they both primary keys of newly formed table or it's our own choice to select any one of the primary keys from the two?

@anshika_purwarr Жыл бұрын

No primary key can be one only for a table

@Motivation_Exam_Success 3 жыл бұрын

Nicely explained mam thanks for providing this video✨

@ShanuKuttanCSEClasses 3 жыл бұрын

Thanks....My pleasure......u can share the videos to others also

@user-zh7cd3lq9j 5 ай бұрын

Maam please upload the PPT/Slides what ever you teaches it will be more helpful. Please attach the link of the slides in description

@pramodsingh3997 3 жыл бұрын

Thank you mam

@gamesden8021 Жыл бұрын

mis i have a question for you in rule number 3 er diagram contain two multi value attribute for example mobile_no and email_no so how to draw what number of table i draw?

@samarth360 Жыл бұрын

nice explanation ma'am

@AashishKumarShaw 3 жыл бұрын

Rule 1: 0:35 Rule 2: 1:52 Rule 3: 4:06 Rule 4: 5:54 Rule 5 C1: 10:45 Rule 5 C2: 12:28 Rule 5 C3: 15:52 Rule 5 C4: 17:22 Rule 6 C1: 22:00 Rule 6 C2: 23:28 Rule 7: 24:48

@saadislam245 Жыл бұрын

Excellent

@bhavanakashyap5756 3 жыл бұрын

Thankyou mam

@Abdullah_Cheema 3 жыл бұрын

Wanna Be teacher Like You ♥️🎊

@ShanuKuttanCSEClasses 3 жыл бұрын

Glad to hear this🙏

@Abdullah_Cheema 3 жыл бұрын

@@ShanuKuttanCSEClasses Mam associative entity kis taraH bnatay hain.... Aur is say Many to many relationship Ki problem kis tarah solve krtay hain ... Kindly inform kr dain Ya video bna Dain It's Huge request 🤗

@KastijitBabar 10 ай бұрын

Ok ji

@becaboardofeducationcontro9104 6 ай бұрын

😂😊@@ShanuKuttanCSEClasses

@anuragsingh-gj4vn 3 жыл бұрын

thanks for explaining this topic of conversion as well, it would be really very kindful if you make a separate video for some example problems on this conversion :) btw very well explained ma'am thank you, i literally captured screenshots while watching the video so i don't have to make notes for this topic haha, everything was nicely explained in slides thankssss

@ShanuKuttanCSEClasses 3 жыл бұрын

Thanks.....Plz check my DBMS playlist, already I have uploaded many examples on this topic er diagram conversion

@bhavyasharma4544 3 ай бұрын

informative video thankyou maam

@toseok3358 3 ай бұрын

Agreed Mr. Sharma🤝

@PrachiSachdeva30 3 ай бұрын

we have to also underline the foreign key in the table?

@JohnCena-xz6nz Жыл бұрын

Mam agar pucha conver er and eer model to relational model toh yahi karke aana hai kya?

@DeathIsTheEndOfLife 8 ай бұрын

Hello maam is there ternary and unary relationship with cardinalities ratio??

@priyansheechauhan6036 3 жыл бұрын

Thx mam

@jetty4840 Жыл бұрын

Mam, for multivalued attributes why can't I create one table and make Roll. No. and Mobile no both the PK?

@e-universe7956 5 ай бұрын

in rule number three the role number should not be primary key as it will just just be same thing as writing phone number in table one so it should be foreign key as a student of one roll number can have more than one phone numbers

@ritikasharma1275 3 жыл бұрын

Thank you mam for the video

@sidharathsingh9541 3 жыл бұрын

Thank you mam for the video

@FaisalSaleem-uq1kn 8 күн бұрын

informative

@salonichauhan4116 Жыл бұрын

You said that when cardinality is 1:1, we combine entity with relationship and 2 tables are made, and when there is no cardinality then 3 tables are made. But both mean the same thing i.e if the cardinality is not given then it is assumed to be 1: 1.

@easycoding7214 2 жыл бұрын

Mam ,4 th number Mai jo Salary entity hai vo niche ki aor hai ,kya vo sahi hai

@kavithapriyacj4868 3 жыл бұрын

Please make more videos mam... this is really useful for last min notes 🙏🙏🙏🙏🙏🙏

@ShanuKuttanCSEClasses 3 жыл бұрын

I am happy that these videos are helpful for u

@sagarmotwani5266 3 жыл бұрын

Super se bhi uper MAM

@ShanuKuttanCSEClasses 3 жыл бұрын

Thanks....My pleasure......u can share the videos to others also

@donniebrasco587 3 жыл бұрын

keep it up your good work mam!

@ShanuKuttanCSEClasses 3 жыл бұрын

Thanks

@ShanuKuttanCSEClasses 3 жыл бұрын

Thanks....u can subscribe the channel for latest videos and can share it to support

@xXmayank.kumarXx Жыл бұрын

5:30 In 2nd table, single roll no. can have multiple phone numbers, so how can roll no. become the primary key?

@jetty4840 Жыл бұрын

Exactly

@nizamfarooqui5950 9 ай бұрын

❤❤❤

@DeathIsTheEndOfLife 8 ай бұрын

Hello mam can we get this ppt or pdf which u have used in the video

@aayushkumar5107 3 ай бұрын

Er to relational mapping and er to tables .. ye dono ka meaning same hota hai kya?? Pls someone tell

@harpuneetkalsi5960 2 жыл бұрын

Hi mam , in case of one to one mapping if one side participation is total and on other side participation is partial, then how many tables are needed ?

@ShanuKuttanCSEClasses 2 жыл бұрын

Hi, for this I suggest to watch the next videos of examples in the playlist

@rdf_gujjar 3 жыл бұрын

Mam at 20:56, if in Case B, the Cardinality Constraints are say (1:m or m:1 or m:n) with both side Total Participation, then how to draw Table? Is still only 1 table would be Generate like in case of 1:1 Cardinality with Both side total participation.

@ShanuKuttanCSEClasses 3 жыл бұрын

Yes .......If there is both side Total Participation, then there will be always 1 table irrespective of cardinality

@ShanuKuttanCSEClasses 3 жыл бұрын

You can also watch another 2 example videos on this topic......share to others also

@rdf_gujjar 3 жыл бұрын

@@ShanuKuttanCSEClasses Mam if we always make 1 table irrespective of cardinality when both entities having Total Participation. But mam in your next another video (which is on Questions on Conversion from ER to Table :- kzfaq.info/get/bejne/fZN7mciGztDdk4U.html ) at 6:20 in Question 2, there is a Total Participation b/w "CLASS" & "STU" entity and for that you have followed the procedure of Key Cardinality (m:n) & make two different tables.., So Mam here it should also be a Single Table rather than drawing two separate tables - as there also Total Participation on Both sides of relationship set "TAKE" ?

@rdf_gujjar 3 жыл бұрын

@@ShanuKuttanCSEClasses yup mam, will share with my friends & colleagues,✌🏻✌🏻✌🏻✌🏻✌🏻

@dev9590 2 жыл бұрын

thank you so much for these amazing video....where can I download the PDF file mam!!

@mukeshtiwari8872 Ай бұрын

I love you 💗💗 maam

@mukeshtiwari8872 Ай бұрын

Give you phone number mam

@hafizmuhammadtalha2298 Жыл бұрын

Ap database man level of consideration pe video bana dan, jis man gran, naming, materialization, governance+ security ager bani he to link send kerdan q k youtube pe uski videos nai mil rahin. Please.

@rubanshiraz5562 Жыл бұрын

Thanks mam..need subtitles mam

@madhurakalbhor6352 3 жыл бұрын

In total participation in both side case it is said we will have one table which will include primary key of both table.. but we can have only one primary key in one table.. then how to decide which table primary key to consider??

@ShanuKuttanCSEClasses 3 жыл бұрын

If we are combining two table as single table, it will contain primary key from 2 different tables

@madhurakalbhor6352 3 жыл бұрын

@@ShanuKuttanCSEClasses but one table can have only one primary key na?

@ShanuKuttanCSEClasses 3 жыл бұрын

After combining this is not the case

@madhurakalbhor6352 3 жыл бұрын

@@ShanuKuttanCSEClasses ok.. thank you