it is system analysis and process integration course can you do it with drawing please ?

database schema: Suppose you want to design a database for a simple library system. The library system contains the following entities: 1. Books: books have unique IDs, titles, authors, publishers, and publication dates. 2. Members: members have unique IDs, names, and addresses. 3. Borrowings: borrowings have unique IDs, book IDS, member IDS, and borrowing dates. To design an E-R diagram for this library system, you can follow these steps: 1. Identify the entities: Books, Members, and Borrowings. 2. Identify the relationships: Books can be borrowed by Members, and each Borrowing is associated with a Book and a Member. 3. Draw the E-R diagram using standard symbols: - Books entity: rectangle with "Books" label at the top and attributes (ID, Title, Author, Publisher, Publication Date) listed inside. - Members entity: rectangle with "Members" label at the top and attributes (ID, Name, Address) listed inside. - Borrowings entity: rectangle with "Borrowings" label at the top and attributes (ID, Book ID, Member ID, Borrowing Date) listed inside. - Relationships: draw a line with "borrowed by" label connecting the Books and Members entities, and another line with "associated with" label connecting the Borrowings entity to both Books and Members entities. 4. Convert the E-R diagram into a database schema: - Books table: columns (ID, Title, Author, Publisher, Publication Date) with ID as primary key. - Members table: columns (ID, Name, Address) with ID as primary key. - Borrowings table: columns (ID, Book ID, Member ID, Borrowing Date) with ID as primary key and foreign keys Book ID and Member ID referencing the Books and Members tables respectively. This exercise should give you a basic understanding of how to design an E-R diagram and convert it into a database schema