0
3.5kviews
You have to design and implement a database that manages information about publishers, authors, and books.
written 7.4 years ago by | modified 2.1 years ago by |
You have to design and implement a database that manages information about publishers, authors, and books.
Some information includes
- A publisher has a name and an address for the headquarters. Each publisher also has a set of branches, each branch having an address and two phone numbers.
- An author has a name and an address.
A book is published by a publisher and has a list of authors associated with it. An author can publish several books and a book can be published by at most one publisher.
a. Design an ODL schema for the above database
b. Write in OQL the following query:
List the name of the author who has published the most books with publisher
ADD COMMENT
EDIT
Creating ER Diagram for easy visualization
a. ODL schema for the above database
b. OQL for the query – List the name of the author who published the most books with publisher “McGraw Hill”