SQL ASSIGNMENT HELP
The problem domain is the same as that you came across earlier in Assignment 1. For convenience its description is reproduced below. Also, following the domain description, is provided a simplified relational data model for the problem domain.
This case study deals with a system used by a Book Shop Chain, known as Sydney Book House (SBH). The information to be stored in the system includes four major categories of data: branch information about SBH, author information, book information, and publisher records. Information about employees of SBH and other relevant data are also stored in the system.