Problem 8 - Databases

Suppose that we design a database of book lending for the students and faculties in a university. The attributes of the book lending database are a book title, author, and a name of the person who uses the lending service of the book, and the attributes of the database of the students and faculties are a name, an address, and a telephone number.

1.

Describe a relational schema of this database.

2.

Describe using relational algebra how to search the telephone number of the person who borrows a book titles 'UNIX'.

3.

Can a query for listing all the names of the persons who borrow more than two books be described using relational algebra? Here, suppose that there no books having the same title and no persons having the same name.