Specify the following queries based on the database schema using operations of relational algebra
00:00 Example 1
01:43 Example 2
02:37 Example 3
04:27 Example 4
ERRORS:
-2: In part 2, missing initial projection for “DEPENDENT” table for “ESSN” and “DEPENDENT_NAME”.
-2: In part 2, there is an incomplete join. Must include “SSN=ESSN”.
-2: In part 2, there is an incomplete join. Must include “FNAME=DEPENDENT_NAME”.
-2: In part 4, must rename the attribute of the immediate result for “Social_anna”.
-7: In part 4, missing join operation and join conditions.
Total Points Lost: 15.0
2. D ← πDEPENDENT_NAME, ESSN DEPENDENT
RESULT← EMPLOYEE ⋈SSN = ESSN AND FNAME=DEPENDENT_NAME D
4. anna ← σFNAME = “Anna” and LNAME = “Hunter(EMPLOYEE)
Social_anna(assn) ← πSSN(anna)
Supervised ← Social_anna ⋈assn = SUPERSSN EMPLOYEE
Result ← πLNAME, FNAME(Supervised)
More Database Management System videos:
• Database Management Systems in mySQL
Notes:
https://docs.google.com/document/d/1T...
En esta página del sitio puede ver el video en línea Specify the following queries based on the database schema using operations of relational algebra de Duración hora minuto segunda en buena calidad , que subió el usuario Computer Engineering life 23 junio 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 789 veces y le gustó 10 a los espectadores. Disfruta viendo!
