Exercises on university database: Submit SQl queries for following statements.

instructor

department

5. You need to create a movie database. For that, create three tables, one for actors(AID name), one for movies(MID, title) and one for actor role(MID, AID, rolename). Use appropriate data types for each of the attributes and add appropriate primary/foreign key 6. 7. constraints. Insert at least two records in instructor table from History department. Update budget of Music department by 10%