السلام عليكم ورحمة الله وبركاته
لو سمحتوا اريد مساعدكم في حل هادين السؤالين
left]Actor_---------------------Role
---
-
-
-
Movie
1-“List the title and type of all movies made during the 1970’s that were nominated for an Academy Award. ”
Translate this into relational algebra. Bonus marks for writing the query without using the Boolean operators AND, OR and NOT.[/indent
]
2. W ← σYear_Made < 1979 ∧ Movie_Type = 'Western' (Movie)
GK ← σFirstnames = 'Grace' ∧ Surname = 'Kelly' (Actor)
M ← GK ⋈ Role ⋈ W
πTitle, Academy_Awards (M)
Translate this into English
.