subject : Database System Design and Management

please I need full solution for this assignment , please help me , thank you.

After reading Henry Book database PP slides answer the following questions:

1) Write Seven (7), SQL statements using this database and describe each query and explain each query. (84 points)

For example, if your query is

SELECT Publisher.PublisherName

FROM Publisher

WHERE (((Publisher.City)<>"New York"));

Your explanation should be: This query will list the publisher's name from Publisher table where Publisher City is Not New York

2) Describe what are the tables in this database and what is/are the relationships between these tables. (16 points)