Develop an Access database that can support the following database requirements. Make your own data that demonstrates the model. That is, if there is a one-to-many relationship make certain that the many side actually has many rows that are associated with the one side. If there is a many-to-many relationship make certain that the data demonstrates the many-to-many relationship. If there is a one-to-one relationship make certain that there is only one row for each row.

Problem

A company wants to manage its book collection. A book has a title, publish year, weight, price, a publisher, and authors. An author has a first and last name. An author can write multiple books. A book can have many authors. A publisher can publish multiple books. A book has a single publisher. A publisher has a name.