databases

Suppose tha we have the following relational database schema named the seventh art. The bold underlined attributes are the keys. The arrows show the foreign keys. * Artist( Artistid, name, BDate, Nationality, Gender) Contact(Artistid Phone Number) Movie(Movield Directorld, Title, Year) MovieRoles(Movield, Actorld RoleName, Description) , FK Festival (Festivalid, FName, City, Country) FK- Nominees(Festivalid, Movield, Year Awards) Award Winner(Artistld, Festivalld, Year AwardName) 1- Write in SQL the following queries (4 marks): a. Retrieve the phone number of the artist "Ali. b. Retrieve the actors of the movie titled "the longest day". c. Retrieve the number of awards won per actor's name. lutahore (h marks)