EER to Relational Translation Techniques

[@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

[@more-uv4nl]

you made me pass my exam

[@divyanshusaluja]

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

[@jaderabbit1267]

Thank you for the video. It was very helpful

[@SSmitar]

Thanks. That was quite helpful

[@arts.maimounah]

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

[@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.

[@mortal787]

This help me so muchh , thx bro

[@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

[@haithuysherman814]

Can you please make a video on Union please?

[@TheEechee]

well explained ^^ thank u man

[@KistlakRajapakshaSevenNet]

Thank U Very Much Bro !! :D

[@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.

[@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.

[@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.

[@shayanjavadi]

programmers are engineers too ;)

[@liesbethjongkind]

very, very clear!

[@Escko]

Great...ty!!!

[@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

[@abdulrehmanmian1476]

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

[@asyrafsufi4108]

HAHAH sial cali

[@prashreetiwasti7264]

:(