Create an Entity-Relationship Diagram (ERD) using Oracle Data Modeler

Generate DDL from an ERD mode using Oracle Data Modeler

Export the database design from Oracle Data Modeler

The library committee provided you will the following requirements.

A library patron checks out a book.

A book can have zero or one active checked out transactions.

A patron cannot check out a checked-out book until after the other patron returns it.

A patron can request a hold on a checked out book to prevent other patrons from checking out the book upon its return.

A patron can check out more than one book.