The State has contracted you to build a database for their bookstores.
The State operates fifteen Community College Bookstores where they currently store information about the Colleges, Publishers, Authors, and Books.
You have been given the task of automating the antiquated process the bookstores is currently using.
Each one of the fifteen Community Colleges has a unique number as an identifier, a College name, College location and bookstore employees.
Each publisher has a Name, City and a code that uniquely identifies the publisher.
After talking with the employees and studying the data needs of the bookstore, it has been determined that they need to access and report on the following information:
Requirement 1: For each publisher, list the publisher code, publisher name, and the city in which the publisher is located.
Requirement 2: For each college, list the number, name, location and number of employees working at the bookstore.
Requirement 3: For each book, list its code, title, publisher code, publisher name and price.
Requirement 4: For each author, list its author(s) name. A book could have more than one author.
Complete the requirements using DBDL and create Diagram. Make sure all tables are normalized to 3NF and exhibit proper relationships.