Draw an ER diagram with these attributes ( ER diagram for SQLfor a library database)
DRAW ER DIAGRAM AS ONE FULL LIBRARY SYSTEM, NOT DIFFERENT FOREACH ATTRIBUTE.
Attributes :
          Customer
Cust_ID: key identifier, required, simple, singlevalued
Cust_Name{ first name, last name}: Key Identifier,simple;composite, multivaried
  Address{street, city,zip,state}: Customeraddress, required, composite, single can be derived fromzip
(placeholder, there should be another attribute here torepresent the books taken out by the customer. Notsure.)
          Inventory
Book_ID: Key identifier, required, simple singlevalued
Book_Name: Key identifier, required, simple,single-valued
Genre: required: simple; single valued
Publication_Date: required; simple; singlevalued
        Â
         Transaction
   Book_ID: Key identifier, required,simple, single valued
Rental_Date: required, simple, singlevalued
Rental cost: required, simple, singlevalued
Rental_Date: required, simple, singlevalued
