SQL and Oracle question

hello.. i'm currently studying SQL 7.0 on my own and i have come across a hard question in a book which is about SQL and Oracle..i wonder if anyone can give me some help? here's the question from the book:

Top Down Design & SQL Basics

Fly By Night Tours

Fly-By-Night Travel Agencies organizes tours. The company has an agency in the capital cities of 15 countries around the world. Each travel agency organizes a range of tours within their own country. The company does not organize any inter-country tours. Customers book on these tours (a given customer may book on many tours) and may pay for the tour in a series of installments. For each payment, a receipt is issued containing a receipt number (5 characters C5), date of payment (Date), customer number (C5), amount of payment (maximum amount 9999.99) and the tour number (C5).

For each tour the company maintains a worldwide unique tour number (C5), the tour name (C15), tour description (C50), maximum number of participants (maximum of 99), the date of departure (date), and return (date), and details for each overnight stop on the tour which include the date of stop (date), hotel name (C10), hotel fax number (C13), and city (C10) for each overnight stop in the tour.

Each customer is assignment a unique customer number (C5) and the company maintains data on family name (C10), given name (C10), street address (C15), town/city (C10), postcode/zip (C4), and telephone number (C15), of each customer. When a customer books a tour, the company also records the date of the booking, the number of adults and number of children booked on the tour, the deposit paid, and total amount due.

For each agency, the agency code (C2), agency name (C20), telephone number (C15), and manager s name (C20) are recorded.

1. Prepare an ER diagram and data structure diagram, which is a suitable conceptual model for Fly-By-Night Tours.
2. Implement your design using Oracle. Enter some sample data- ten to fifteen records in each table will be sufficient. However, do not forget to create your sample data in such a way that data records are correctly related.
3. You should provide reports for the following formatted enquiries: 7 A printed report of all customers including Customer Number, name, address and telephone number 7 A printed report of all agencies showing agency code, name, telephone number and managers name 7 A printed tour report listing the tour details for all tours organized by Fly-By-Night showing the tour name, description, date of departure and return and the organizing agencies name 7 A printed payments report showing all the payments which have been made. The report should show tour name, customer name, date of payment and amount of payment in customer order within tour order.

These reports must be created using your DBMS s report writer/formatting module. All DBMS programming tasks and report formatting must be carried out via command/procedure files. All your reports should be reproduced from the files you submit.

You should submit your assessment via diskette which include:

7	An index file listing of all the files included in the diskette
7	Your ER diagram (filename: fbn);
7	Electronic access to the full set of files. These should include:


-	The command file to create your tables (schema file)

-	Command file to delete your tables

-	Command files and data files to load tables

-	Command files to produce all desired repots, be sure to conform to the listed filenames above.

--== Sent via Deja.com http://www.deja.com/ ==-- Before you buy.

 Sent via Deja.com http://www.deja.com/
 Before you buy. Received on Sun May 07 2000 - 00:00:00 CDT