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...
In questa pagina del sito puoi guardare il video online Specify the following queries based on the database schema using operations of relational algebra della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Computer Engineering life 23 giugno 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 789 volte e gli è piaciuto 10 spettatori. Buona visione!
