Write Relational Query Expression to do the following:
a. Find all the committee names where instructor Abdullah is a member
b. Find the maximum given salary.
c. Find the total number of instructors for each department.
Question TwoConsider the following relation instances:
Student_id Name Course_code10001 Abdullah IT24410002 Mohammed CS14010003 Nasser CS14110004 Khalid IT403
Course_codeCourse_nameIT244 Introduction to databasesCS140 JAVA ICS141 JAVA IICS566 Cyber Security
Write the output of the following relational algebra expression:
a. Student Course
b. Student Course
Question ThreeYou have been asked to design a database of documents, authors, and readers. described as follows:• Document: has a docID, title• Publisher: each author is the creator of several documents, and each document is published by one or several publishers.• Readers: each reader reads several documents, and each document is read by several readers.Draw an E/R diagram, which includes entity, attributes, and relationships. Remember to indicate the key for each entity, as well as the multiplicity of each relationship using the appropriate notation.(You may presume your own scenario)
A database of documents, authors, and readers.