deolalkar_pooja 0 Light Poster

Hi to all,
I have nothing idea about how to create relation and solve their queries. I want to relation as follows:
-------------------------------------------------------------------
BookAuthor(book, author, earnings)
BookReference(book, referenceBook, times)
BookReview(book, reviewer, score)
BookPublih(book, year, publisher, price, numbar)

In these database, each book may have 1 or more authors & each author may make a diff. amt. of money from that book. One book may make reference to other book.1 book may be reviewed by diff. reviewers and get diff. scores. an author could also be a reviewer & a publisher.
---------------------------------------------------------------------

I want to solve following queries

1. find all books published in 2003 & reviewed by both Sammer Tulpule & Hemant Mehta.
2.Find all the reviewers who never reviewed their own books.
3.find all authors who reviewed more than 2 books written by Sita Mitra.
4.Find all authors who have written exactly 1 book and reviewed more than 1 book.
5.Find all the reviewer who reviewed every book from 'Stephen King'.
6.find all books published in 1995-2000 in descending order.
------------------------------------------------------------------------

I know, these is not good to find an answer, but believe me i really don't understand hoe to make table with relation & solve above queries.


Thanks & regards,
Pooja.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.