Please make sure your solution is neat and correct if you need a thumbs-up. DO NOT GIVE INCOMPLETE ANSWER.

QUESTION:

a) Based on the given brief scenario below, draw an ER diagram:

Your Library database consists of Student information and Book Information. A Student has a unique student id, name, phone number, and date of birth. All students will have first, middle, and last names, and may have one or two phone numbers. Students borrow books. A book will have a unique id, name, price, and multiple authors info. The author info is composed of the author's name, the authors last degree, authors last institution. (Note: You should also remember the relationship constraints)

b) Suppose you also want to see an age attribute for the students in your database which can be found by calculating it from the date of birth and the current date. Show the age attribute in your above ER diagram. And name what type of attribute it is. [