The Smallville Library requires a database to support its activity. There are several branches in the library systems but it only handles books. Each branch obviously retains many book copies. Each branch has a unique branch no, a name, a location, and a
computer science
Description
The Smallville Library requires a database to support its activity. There are several branches in the library systems but it only handles books. Each branch obviously retains many book copies. Each branch has a unique branch no, a name, a location, and a phone #. For each book in its collection, it retains an ISBN, Title, Author(s) information and date of publication. Each book is also assigned to one or more subject categories. A set of standard subject categories is stored in the database to be used in member searches. Each subject category can be assigned to many books and can be classified as being of either a major or a minor type for any particular book.
