Converting ER Diagrams to Tables | Examples | DBMS | Lecture 17 | Shanu Kuttan | in Hindi
HTML-код
- Опубликовано: 5 сен 2020
- #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
maam apne hamara bhut time bachaya .h .. itna aasani se samjhte ho thanku maanm
Damn best video just point to point thank you so much mam just completed a complex topic in just 25 minutes
you made this easy to understand. your passion and dedication is commendable Thanks!
Jhakaas Video, thank you mam!!!
Can't thank you enough. Seriously. Loved this video
AMAZING ! Well explained and fully prepared. Appreciate it.
Kaash hamare professors aise padate
Thanks 🌹🌹🌹🌹ma'am
Respect ❤❤❤
Best videos of this topic on youtube... 🙏❤️
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.
Such a great explanation. You deserve million of subscribers.
thank you mam , the way you have explained this topic is amazing !!!!
Really helpful and great content !!
BTW watching this the night before my exam :,)
Simple and Easy to Understand...very nice explanation :)
Thank you so much ma’am. You made this so easy to understand 😊
mam i am fully satisfied with your video😄😄
best explanation ever👌👌
Thank you so much ma’am. You made this so easy to understand
You are nice teacher I clearly understand this topic 🙏🏻🙏🏻❤️ thank you so much mam
Superb lecture please upload more videos of more subjects and topics thanxx mam...... Concept is very clear
Thank you for this beautiful video.
Iss topic ko aap se behtar koi nhi padha skta ...
🔥🔥🔥
Very Well Explained. Thankyou very much.
the clearest explanation of ER diagram thanks ma'am
Thankyou so much mam my
confusion clear karne ke liye 🙏🙏
Thank you so much for the video mam..... 😊😊😊
Amazing lectures ma'am..you teach so well✨🤗
Thank you for the video ma'am...
It was really helpful, thank you.
exam ke do ghante pehle ye module karliyaaa, thank u, even my collage teacher also using this ppt for teaching😂
from where can we get this ppt?
wow excellent explanation
thank you for the video mam..
Kis kis ka Kal Database ka paper he aur aaj idher aaya hoa?😁
your the besttttt.....
Thank you mam for the video😊
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.
Thanks for supporting, your concern really means a lot.....very soon we are enabling JOIN button for membership.....best wishes
mam aapka same content hamari DBMS wali mam ne copy kiya hai ppt mai please unpar case kijiye..........😅😅
Yrr same literally same he topic ha nothing is change 😂😂
thanku maam ❤❤❤❤
Well explained maam,thank you🙏🙏
I really really appreciate ❤
Very well explained ❤
Thank yo so so much mam
excellent way you teach
Very nice explanation .
excellent work
Thanku mam for the video
Awesome👍👏 My respect for you ⬆
nice explanation , thank u ma'm
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
Well explained... Thank you mam
Thank you mam 😊
Thanks mam
Thank you mam..
Aapki wajah se mai fail hone se bach gya thanks ma'am 🥲💀
informative video thankyou maam
Agreed Mr. Sharma🤝
Thankyou so much ma'am
I learned much more from u mam
thank you ma'am 😊😊
Very well explained ma'am 😊
Maam please upload the PPT/Slides what ever you teaches it will be more helpful. Please attach the link of the slides in description
Thankyou mam
ma'am what if in the weak enitity one, there is total participation on left side too, then will we require only one table?
Thanks mam Allah give you long life with so much happiness :)
Thanks a lot ...god bless u too
Nicely explained
informative
good explanation
Excellent
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
nice explanation ma'am
Amazing way !! Best video on this topic on RUclips ,,,Thank you very Much mam,,,,Its Exam time & your video is helping me,,,,Keep it up mam👍🙋
Thanku mam
My pleasure......do subscribe and share to others also so that they can be benefited
@@ShanuKuttanCSEClasses Sure mam
Nicely explained mam thanks for providing this video✨
Thanks....My pleasure......u can share the videos to others also
Underated deserve more views👌👌❤️❤️
Thanks for the support.......started this channel 8 months back, so growing slowly day by day 💗
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?
❤❤❤
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?
No primary key can be one only for a table
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
Thanks.....Plz check my DBMS playlist, already I have uploaded many examples on this topic er diagram conversion
we have to also underline the foreign key in the table?
Thank you mam for the video
Thank you mam for the video
Mam agar pucha conver er and eer model to relational model toh yahi karke aana hai kya?
I'm totally impressed. And surprisingly shocking. Your teaching method is unique.
good luck!i am going to subscribe your chanel.
Wanna Be teacher Like You ♥️🎊
Glad to hear this🙏
@@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 🤗
Ok ji
😂😊@@ShanuKuttanCSEClasses
Mam, for multivalued attributes why can't I create one table and make Roll. No. and Mobile no both the PK?
Hello maam is there ternary and unary relationship with cardinalities ratio??
Mam ,4 th number Mai jo Salary entity hai vo niche ki aor hai ,kya vo sahi hai
Super se bhi uper MAM
Thanks....My pleasure......u can share the videos to others also
thank you mam
My pleasure......for latest videos u can subscribe and share to others also
Hello mam can we get this ppt or pdf which u have used in the video
I love you 💗💗 maam
Give you phone number mam
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.
Please make more videos mam... this is really useful for last min notes 🙏🙏🙏🙏🙏🙏
I am happy that these videos are helpful for u
keep it up your good work mam!
Thanks
Thanks....u can subscribe the channel for latest videos and can share it to support
5:30
In 2nd table, single roll no. can have multiple phone numbers, so how can roll no. become the primary key?
Exactly
nice teaching skill set mam
really appreciated
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.
Er to relational mapping and er to tables .. ye dono ka meaning same hota hai kya?? Pls someone tell
thank you so much for these amazing video....where can I download the PDF file mam!!
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.
Yes .......If there is both side Total Participation, then there will be always 1 table irrespective of cardinality
You can also watch another 2 example videos on this topic......share to others also
@@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 :- ruclips.net/video/G-KfeUijycQ/видео.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" ?
@@ShanuKuttanCSEClasses yup mam, will share with my friends & colleagues,✌🏻✌🏻✌🏻✌🏻✌🏻
Thanks mam..need subtitles mam
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 ?
Hi, for this I suggest to watch the next videos of examples in the playlist
Voice quality matches with Sherya Goshal
🤔
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??
If we are combining two table as single table, it will contain primary key from 2 different tables
@@ShanuKuttanCSEClasses but one table can have only one primary key na?
After combining this is not the case
@@ShanuKuttanCSEClasses ok.. thank you
Mam, at 23:30, how can there be 2 primary keys in a single table?
Combining as single table so it contains primary key from 2 different tables
@@ShanuKuttanCSEClasses
😯 Okk, now I understand. Thanku for replying mam!