A database of documents, authors, and readers.

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

Student_id Name Course_code10001 Abdullah IT24410002 Mohammed CS14010003 Nasser CS14110004 Khalid IT403

Course

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)

Sample Solution
A database of documents, authors, and readers.

CLICK HERE TO ORDER NOW!!

Leave a Reply

Your email address will not be published. Required fields are marked *