EER to Relational Translation Techniques

Overview of 3 techniques for mapping an extended entity relationship (EER) model to a set of relational schema, the circumstances under which each technique applied, and the tradeoffs among the 3

[@iphoneusdsd]

thank you brian! saved my assignment on eer and the relation model,

[@codydavis2871]

Literally about to say the same thing. Just helped me finish my paper

[@ashleylove6840]

Thank you so much!! I can only understand theis topics with you, my professor is really bad at explaining things. This will definitely help me throughout the semester.

[@flipsmash]

Happy to help!

[@UNKNOWN-ms7gz]

same as u

[@SSmitar]

Thanks. That was quite helpful

[@divyanshusaluja]

Excellent Video. You just simplified some terribly written books. Thanx a lot !!!

[@more-uv4nl]

you made me pass my exam

[@jaderabbit1267]

Thank you for the video. It was very helpful

[@arts.maimounah]

Thank you so much Sir⭐⭐ amazing lesson , great representaion 👍

[@liesbethjongkind]

very, very clear!

[@TheEechee]

well explained ^^ thank u man

[@mertturker101]

Thank you so much for the video but I have a question. At the end of the video you were explaining overlap but there was no mapping in overlap.

[@KistlakRajapakshaSevenNet]

Thank U Very Much Bro !! :D

[@mortal787]

This help me so muchh , thx bro

[@xyanrock7648]

for the overlapping cases when for example
1) when an employee is admin , programmer and engineer
2) when an employee is programmer and engineer or any two among the three sub classes is there is any standard technique to represent the constraint in diagram.
thankx.

[@seyyedrizmy4732]

Hi in the video about the subclasses, wont they be applicable when there is covering constraint and not the disjoint??

[@udanasrimal]

Thank you sir❤

[@flipsmash]

Most welcome

[@Escko]

Great...ty!!!

[@marichujoy]

What do the "U's" that you drew in represent?

[@flipsmash]

The U indicates the direction of the specialization. The U is open towards the generalized entity. Given the possibility of multiple inheritance, it's possible otherwise to be confused about which entities are the generalized ones.

[@haithuysherman814]

Can you please make a video on Union please?

[@shayanjavadi]

programmers are engineers too ;)

[@alextilson9741]

With all in one, instead of binary classes, cant you represent it with a binary(max)? i.e:
0 -> {}
1 -> {Programmer}
01 -> {Engineer}
11 -> {Admin}
100 -> {Programmer, Engineer}
101 -> {Engineer, Admin}
110 -> {Admin, Programmer}
111 -> {Programmer, Engineer, Admin}

[@alextilson9741]

This would also make it easier to constrain again certain ones, i.e.
exclude: {0, 101, 111} etc.

[@lorenzorichards7093]

Design the database for a programming support environment. In this environment programmers produce programs, which are written in given programming languages.
Each program is written by a given programmer, can call other programs, and can be used by given users. Users are recognized by their log-in names. Programmers are recognized by their log-in name and by their code. Programs have compound names that include the program's name, the extension and the programmer's code. Programs have a version number, a date and a short description; some programs interact with DBMSs. Each DBMS maintains stored data in the form of relations, with several attributes and one primary key. Each database is defined by a database administrator, who is a programmer specialized in data management. State clearly any assumptions you make.
Good morning, I seem to having issues creating the ERD with ISA
what did I do wrong?

[@flipsmash]

Sorry, this looks to be homework. You should seek help via your instructor/institution

[@prashreetiwasti7264]

:(

[@abdulrehmanmian1476]

your goatee is out of allignment and its bugging the hell outta me

[@asyrafsufi4108]

HAHAH sial cali