Relational Schema Apply the rules learned in Chapter 9 to map the components of your Lab1 EER diagram to a Relational schema. The critical components of a Relational schema are: Relations, Primary Keys (PK) and Foreign Keys (FK). You can choose either the diagram-like format used in the book (refer to Figure 9.2) with arrows linking FK to PK, or a text-based format, as in the following example: RELATION_NAME (PK_attribute, Attribute2, Attribute3, ... , FK_attribute) Underline the primary key attribute(s). Use the relation name that the foreign key (FK) refers to in the foreign key name and write FK inside parenthesis following the attribute's name. For example: EMPLOYEE (Ssn, Fname, Minit, Lname, Bdate, Address, Sex, Dept_no(FK)) Turn in a pdf file with your corrected EER diagram and the Relational schema.

E-R Diagram has 5 entities. Books- has one primary key attribute ISBN, author,_name, edition and genre Borrow- has attributes of books_name, date, and no_of_books. Library- 1 primary primary key attribute (Identification_no), title , edition and genre. User - 1 primary key attribute (user_no), composite attribute (user_name), address, email_address. There is also a multivalues attribute (tel_number) Authors has attributes of author_name, book and title.