DBMS Lec 8 : ER Diagram practice questions with solutions | Er diagram for car insurance company

Edrawmax help you create ER diagram easily: bit.ly/46Q4TTn
#korth #dbms #dbmstutorials #dbmslectures #db #erd #erdiagram #cardinality #pyqspractice #pyqseries #navathe
ER Diagram practice questions with solutions
0:03 Question 2
1.
Construct an E-R diagram for a car-insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents.
11:16 Question 3
2.
Design an E-R diagram for keeping track of the exploits of your favorite sports team. You should store the matches played, the scores in each match, the players in each match and individual player statistics for each match. Summary statistics should be modeled as derived attributes.
18:34 Question 4
3.
Design an E-R diagram for keeping track of the exploits of your favorite sports team. You should store the matches played, the scores in each match, the players in each match and individual player statistics for each match. Summary statistics should be modeled as derived attributes.
Extend the E-R diagram of the previous question to track the same information for all teams in a league.
22:50 Question 5
4.
A university registrar’s office maintains data about the following entities: (a) courses, including number, title, credits, syllabus, and prerequisites; (b) course offerings, including course number, year, semester, section number, instructor(s), timings, and classroom; (c) students, including student-id, name, and program; and (d) instructors, including identification number, name, department, and title. Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modeled.
Construct an E-R diagram for the registrar’s office. Document all assumptions that you make about the mapping constraints.
er diagram questions
er diagram
er diagram in dbms
er model in dbms
er diagram example
how to draw er diagram in dbms
er model
er diagram question
er diagram in relational schema
how to make er diagram
how to draw er diagram
dbms
dbms er diagram
entity relationship diagram
erd diagram
entity relationship model in dbms
er model questions
draw er diagram
e r diagram
er diagrams
er model to relational model
er model question
er to relational mapping
er diagram examples
erd
eer diagram
how to create er diagram
er diagram of hospital
er diagram tutorial
dbms questions
entity relationship model
er diagram practice
er modeling
e r model
e-r diagram
er model dbms
how to draw an er diagram
what is er diagram
er diagram korth
korth er diagram solution
exercises based on er model concept
er diagram practice problems with solutions
er diagram questions
er diagram
er diagram in dbms
er model in dbms
er model
er diagram example
how to draw an er diagram in dbms
how to make er diagram
er diagram question
how to dram er diagram
er diagram to relational schema
erd diagram
dbms er diagram
er diagram dbms
er model questions
learn dbms for gate exams
tutorial on dbms for gate exams
ER diagram tutorial
ER diagram questions
Entity relationship diagram explained
ER diagram Q&A
ER diagram interview questions
ERD practice problems
ER diagram examples with solutions
Database design questions
ERD questions and answers
Entity relationship model questions
ER diagram basics
ER diagram for beginners
ER diagram problem solving
ER diagram exercises
ER diagram MCQs
Car insurance ER diagram
ER diagram for insurance company
Entity relationship diagram car insurance
ERD for customers and cars
ER diagram tutorial car insurance example
ER diagram with multiple relationships
Car accidents ER diagram example
ERD for cars and accidents
Entity relationship diagram for car insurance company
ER diagram for insurance management system
ER diagram multiple cars and accidents
Database design for car insurance company
ERD for vehicle ownership and accidents
ER diagram for vehicle management system
Car insurance ER diagram with accidents
Sports team ER diagram
ER diagram for sports statistics
ERD for sports matches and scores
Entity relationship diagram for sports team
ER diagram for player statistics
ER diagram for tracking team performance
Sports league ER diagram
ERD for matches and player stats
ER diagram for sports team management
Database design for sports team
ER diagram for league matches and statistics
ER diagram with derived attributes
ERD for multi-team sports league
Sports match tracking ER diagram
Entity relationship diagram for sports league management

[@vidhibhatt1632]

best explanation across entire internet, found this video a day before my exams and i am just so happy that i came across it. thank you sir!

[@dinudineshdbms]

Thanks for watching... all the best for exam...

[@mdobyead7212]

came across this video with my final being in 2 days, thanks a lot sir

[@dinudineshdbms]

All the very best for exam..

[@sabbirrayhan4161]

Many Manry Thanks Sir. may Allah Bless You

[@dinudineshdbms]

Thanks and welcome...

[@_pranjal_nale]

Thank you for clearing all the doubt💯😀

[@dinudineshdbms]

Welcome...👍

[@diwassati6534]

wonderful. ....you cleared all my doubts....thankyou very much

[@dinudineshdbms]

Thanks for watching...

[@ZohaibRajpootFromSheikhupura]

3 months of course cover in 30 minutes 😂 Love from Pakistan 🇵🇰

[@dinudineshdbms]

Congrats..and all the best for exams if you have any..

[@akshatanagpure11]

Nice explanation sir..!🙏🏻 All doubts clear ho gaye

[@dinudineshdbms]

Thanks for reviewing...

[@nituM-o1j]

Thank you so much Sir for such a wonderful explanation

[@dinudineshdbms]

Thanks for reviewing...

[@fahadakeel4158]

Well Explained....watching from Pakistan

[@dinudineshdbms]

Thanks for reviewing...

[@chiragsingh8323]

Bohot mst sikhaya sir aapne❤️❤️

[@dinudineshdbms]

Thanks for liking it..

[@diyhacksgaming3228]

Its 4 am tmrw 10 am exam and im watching this❤😂

[@dinudineshdbms]

All the very best....

[@sonukumarnirala6896]

Nice explanation

[@dinudineshdbms]

Thanks for liking

[@techic8944]

Thank you! Sir

[@dinudineshdbms]

Welcome...

[@monadash20]

Excellent explanation sir

[@dinudineshdbms]

Thanks...

[@avinashgupta5632]

Thankyou for explaining it in such an easy wat sir.. I'm from Shankaracharya College Durg😄

[@dinudineshdbms]

Thanks for reviewing...

[@medhavipajgade9685]

Best!

[@bishalsarkar2795]

good explained🤩

[@dinudineshdbms]

Thanks for watching...

[@brocodekartik]

Can you please make a video in which you code a whole project and explain it step by step, yk just practicle skills, our college is lacking those.!

[@dinudineshdbms]

It will require time because for that i need to create whole project along with erd, dfd and other uml diagrams.

[@Sakshi_6888]

Watching before 38 minutes from exam

[@dinudineshdbms]

All the very best...

[@simranqureshi2901]

Legend

[@hussainbarry8898]

Hahaha same here

[@RajuYt07w]

Tmkc

[@taimoorahmedtaimoorahmed3722]

Confident dheet

[@mohitkaushik21]

My god sir heads off to you🖖

[@dinudineshdbms]

Thanks for watching...

[@mohitkaushik21]

Sir normal forms aur transaction concurrency ke uper bhi question layiye plz 22 dec ko exam ha DBMS ka plz sir... 😊

[@yourgurl1282]

Very nice video

[@dinudineshdbms]

Thanks

[@ravikeshpatelgk8336]

welll explained

[@dinudineshdbms]

Thanks for watching

[@rajesht9702]

Thank You Sir

[@dinudineshdbms]

Thanks for reviewing..

[@maxlucifer8986]

thank you so much for the video !

[@dinudineshdbms]

Thanks for liking...

[@frazliaqat]

Sir, are descriptive attributes compulsory? and also love your teaching method from Pakistan💌

[@dinudineshdbms]

Yes sometimes it is neccessary because we cannot add it into some entities and we have to represent in relationship only.

[@ALIHASSAN-em5bj]

Thank you so much sir ❤

[@dinudineshdbms]

Welcome..

[@shaikhuzma786]

Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): the NHL has many teams, each team has a name, a city, a coach, a captain, and a set of players, each player belongs to only one team, each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records, a team captain is also a player, a game is played between two teams (referred to as host team and guest team) and has a date (such as May 11th, 1999) and a score (such as 4 to 2). Construct a clean and concise ER diagram for the NHL database send me answer sir pls u explaining so awesome 😊😊

[@dinudineshdbms]

Ok i am trying..

[@shaikhuzma786]

@@dinudineshdbms ok Sir tqq🤗🤩

[@shaikhuzma786]

Hloo sir

[@dinudineshdbms]

kzbin.info/www/bejne/pXu2Z3-siNZriK8

[@dinudineshdbms]

drive.google.com/file/d/1gS4bDOoaA5W8cFHSSyQulOBkmgD1mS5u/view?usp=drive_link

[@swarangikharwade5395]

Thank you so much sir 🙏

[@dinudineshdbms]

Welcome.. and thanks for reviewing..

[@mitul22br]

In 3rd qn, shouldn't team_played be a unary relationship? Because a team plays only with another team, right? If done so, we could remove Opponent attribute from MATCH entity and add Opponent_score as another attribute in team_played relationship.

[@dinudineshdbms]

Look for this solution in 4th question. In 3rd question er diagram is made for your favorite sports team only so oppenent score and own score should be maintained.

[@adibahbab6859]

watching from Bangladesh before three hours of exam 🥲

[@dinudineshdbms]

All the very best

[@poise8702]

before 2:15 hrs,not even 3

[@mightygerman]

Thnx a lot sir..

[@dinudineshdbms]

Thanks for watching...please reply from which place you are watching...

[@triptitiwari7533]

Thank you so much🤩

[@dinudineshdbms]

Welcome

[@Yzshsjdje24]

thank you sir,it was really helpfull

[@dinudineshdbms]

Thanks for watching..

[@vajahat4912]

can we have an policy table with policy id ,premium in 1st question.? car has policy?

[@dinudineshdbms]

Definitely one can have a policy then only he/she can claim the insurance amount but that table is beyond the scope of this er diagram. It should be stored in insurance company database.

[@sushantarora5566]

very nicely explained sir

[@dinudineshdbms]

Thanks for watching...

[@joydutta4928]

Sir do you have a complete playlist for dbms? We are taught only to pass the exam. I still can NOT design the db

[@dinudineshdbms]

I have playlist for complete syllabus you can go to playlist section.. For designing the db you need to understand the whole project that requires software engineering SDLC concept..

[@kanishkaaswani6891]

hello sir, last question mai student enrolls course offering mai apne course offering mai double rectangle kyu banaya hai? agar aapne course offering ko weak entity liya hai toh enrolls bhi double diamond mai hona chahiye ,

[@dinudineshdbms]

Every weak entity set is always associated to one identifying entity set through a identifying relationship so that relationship is represented through double diamond box not every relationship is identifying relationship so thats why i have not drawn it with double diamond box

[@kanishkaaswani6891]

@@dinudineshdbms oh okay sir thankyou so much !

[@Bull_of_markets]

1 din pehle dekh rahe heyy

[@dinudineshdbms]

All the very best. BTW which university have exams now.

[@atharvaghorpade15804]

@@dinudineshdbms PUNE UNIVERSITY

[@halumgrr]

What will be the cardinality for the entities shown in the ternary relationship in question 2?

[@dinudineshdbms]

Mapping cardinalities are shown in only binary relationships and not in ternary relationships. Because for mapping binary relationships into relational tables have 3 rules but mapping ternary relationship into relational table only have 1 rule.

[@PookieNarc119]

Life saver. 5am

[@mahamfatima6117]

question no 2 mein jo turnary relationship bana hai us mein cardinality and modality kiya hogi

[@dinudineshdbms]

We will not represent cardinality on ternery relationships or in others words in every er diagram ternery relationship always represent many to many relationships and participation is always partial.

[@mahamfatima6117]

@@dinudineshdbms thank you

[@YourShanOnly]

Sir take some more complex problem of conversation ER to Relational model

[@dinudineshdbms]

kzbin.info/www/bejne/r4mldXl_f5KFrZY

[@dinudineshdbms]

kzbin.info/www/bejne/g3-UgZiGr52MrKM

[@samarthhemrajani2025]

Q1 sir driver less cars exist !!

[@dinudineshdbms]

Yes today driverless cars exist but we do not consider it for making the er diagram.

[@samarthhemrajani2025]

@@dinudineshdbms Alright and in last Q i think you missed a double diamond between strong and weak entity like between course offering and instructor

[@mcasolver9430]

Accident total participation mai nhi hoga kya?

[@dinudineshdbms]

Accident ka total participation rakh bhi sakate hai but usase koi fark nahi padeha kyunki jab er diagram to relational model me convert karenge to participated relationship ki table banegi hi kyunki wo ternary relationship hai. Total participation and cardinality ratio hamesha binary relationship ka hi dekha jata hai kyunki usme convert karne ke alag alag steps hai kabhi relation merge karna hota hai kabhi relayionship ki alag table banani hoti hai but for ternary relationship hamesha alag hi table banati hai so cardinality ratio and total participation ka koi importance nahi hai usme. For more doubt you can watch er diagram to relational mapping video.

[@pomdev]

sir koi khadi gaadi ko bhi to thok sakta hai , in this case there is no person inside the car, suppose he parked his car for 2 minutes for toilet and other car hit the car then this also a case

[@dinudineshdbms]

Ho sakata hai but database me esse koi fark nahi padega accident hoga to claim to person lega hi na agar insurance karaya hai toh..

[@eshaesha9100]

respected sir, at time stamp 29:54 how is course and course offering 1 to Many. Out of all courses many courses can be offered.

[@dinudineshdbms]

It is a rule of identifying relationship that identifying relationship is always one to many from identifying entity set to weak entity set. Course offering are many but one course offering belong to only 1 course that is why it is 1 to many from course to course offerings.

[@eshaesha9100]

respected sir please make a video on transforming ERD into relations/table😌

[@ShivamSingh-gk3qu]

Will That Be wrong if we make score as a weak entity in Question 3

[@dinudineshdbms]

Then how you relate which player scored how much from which match

[@34_adnanvaid90]

Sir kl pls pass kardena paper me

[@21_dhairyayadav]

mujhe bhi sir ✋

[@dinudineshdbms]

All the very best..

[@madhusridharmaraj]

Sir plz add English subtitles

[@letsstart1547]

Watching 21 before exam

[@dinudineshdbms]

All the best...

[@aishwaryashinde5988]

Sir I can't find the lecture 1st of E R diagram

[@dinudineshdbms]

kzbin.info/www/bejne/nnWWn4Wcfqumd5I

[@Siberedits]

Just 1hour before exam

[@dinudineshdbms]

All the very best..

[@ankitabhattit3241]

11:14

[@punkazkarki4908]

I guess student should enroll in course not in course offering

[@dinudineshdbms]

No according to er diagram question students should enroll to course offerings which is offered within courses. So ultimately students enrolled to courses though course offerings.

[@Islamsgd]

No need y b chaval hi h 😂

[@samstudies6936]

please note in the title that the video is not in English to avoid wasting people's time!

[@dinudineshdbms]

Thanks for suggestion..

[@libnene]

@@dinudineshdbms Thank you for the prompt reply and action, you are a respectable person 🙏🏻

[@kelvinbyabato]

use english pls

[@dinudineshdbms]

It is dependent on the region, here in india people learn with local language but for communicating with outside world it is required to speak english thats why study in english... So for teaching the concepts here we used mixed language i.e. hindi + english..

[@divyaanshuagrawal3383]

Thank you sir!

[@dinudineshdbms]

Welcome...

[@zaheerbagwan1542]

Watching before 50 minutes to exam

[@dinudineshdbms]

All the very best..

[@tranquillity5437]

Hahaha same😂

[@bhavyachanana3095]

Us bhai us