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.
Consider the following relation instances:
Student_id Name Course_code
10001 Abdullah IT244
10002 Mohammed CS140
10003 Nasser CS141
10004 Khalid IT403
IT244 Introduction to databases
CS140 JAVA I
CS141 JAVA II
CS566 Cyber Security
Write the output of the following relational algebra expression:
a. Student Course
b. Student Course
You 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)