Partition the Sentences
Based on the requirements, the following statements describe the Entities that will
become the basis of the ER Design.
There are several branches in a library system.
Each branch has a branch number, branch name, location (address),
and phone number.
Branch number is a unique identifier for each branch.
Each library branch can own zero to several copies of the same book.
(BNumber, BName, Address 1, Address 2, City, State, Zip, Phone)
Each book has a book number, title, the number of pages of the books,
the name of the publisher, the year of publishing and list of authors of
(ISBN, Title, Publishing, Year, Pages)
Each patron has a patron number, patron’s name, patron’s contact
information such as postal address, phone number and email address.
(PNumber, PName, Address, City, State, Zip, Phone, Email)